Greetings everyone, I'm happy to report a working Citi CC OFX Direct Connect through AqBanking. It took quite a bit of tinkering to figure out. For a while I was stuck on the fact that <TRNUID> had to be a UUID4, which AqBanking cannot produce, but it seems that Citi changed something and now it works as is.
It may be helpful for me to mention that I first discovered the correct OFX request, and then got AqBanking working. A working OFX request is included at the bottom of this message. Unfortunately, it has been a while since I stumbled upon it and I vaguely recall that the request alone was not enough. I am speculating now, but I think I had to enable that 10 minute window mentioned in the thread and during it send a simple signon request (with no transaction/statement request field). Only after it returned a success was I able to request data. In terms of submitting the request, I have a few working options: 1) a POST request with the following headers 'Content-Type': "application/x-ofx", 'User-Agent':"InetClntApp/3.0", "Accept":"*/*" 2) a call to ofxget (part of ofxtools) with the following configuration file (~/.config/ofxtools/ofxget.cfg): [citi] version = 103 appver = 2500 creditcard = # 16 digit credit card number # org = Citigroup fid = 24909 user = #username# url = https://mobilesoa.citi.com/CitiOFXInterface pretty = true unclosedelements = true 3) AqBanking v5.7.8 with the following configuration file: ~/.aqbanking/settings/users/uid0001.conf int uniqueId="58" char backendName="aqofxconnect" char userName="username" char userId="username " char customerId="username " char country="us" char bankCode="0000000000" int lastSessionId="0" data { backend { char bankName="Citi Credit Card" char org="Citigroup" char fid="24909" char serverAddr="https%3A%2F%2Fmobilesoa.citi.com%2FCitiOFXInterface" char appId="QWIN" char appVer="2500" char headerVer="103" char clientUid="a fixed UUID4 string" int httpVMajor="0" int httpVMinor="0" } #backend } #data Finally, here is the working OFX request. If you find this information useful, please consider adding it to the GnuCash wiki. OFXHEADER:100 DATA:OFXSGML VERSION:103 SECURITY:NONE ENCODING:USASCII CHARSET:1252 COMPRESSION:NONE OLDFILEUID:NONE NEWFILEUID:#random uuid4 or just some random large integer, like 20180912052115# <OFX> <SIGNONMSGSRQV1> <SONRQ> <DTCLIENT>20191020111537.000 <USERID>#username# <USERPASS>#passsword# <LANGUAGE>ENG <FI><ORG>Citigroup<FID>24909</FI> <APPID>QWIN <APPVER>2500 <CLIENTUID>#uuid4, i keep it fixed between sessions, but don't recall setting it# </SONRQ> </SIGNONMSGSRQV1> <CREDITCARDMSGSRQV1> <CCSTMTTRNRQ> <TRNUID>20191021211537.000 <CLTCOOKIE>1 <CCSTMTRQ> <CCACCTFROM><ACCTID># 16 digit credit card number#</CCACCTFROM> <INCTRAN> <DTSTART>20191012000000 <DTEND>20191019111537 <INCLUDE>Y</INCTRAN> </CCSTMTRQ> </CCSTMTTRNRQ> </CREDITCARDMSGSRQV1> </OFX> -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
