[GNC] AQ Banking OFX Direct Connect

[Edwin Franks]

I am trying to get connected to my banking institutions using the AQ Banking OFX Direct Connect module.  The application apparently authenticates my user name and password properly, but instead of returning data, it returns an error.  For my American Express credit card, it gives an “Account not found” error.  For my Citibank credit card, it gives me an Http-Status: 403 (Forbidden) error.  Below are the contents of the messages from the AQ Banking GUI and OFX.LOG files for both the American Express and Citibank attempts:

American Express Messages:

Messages shown in the AQBanking GUI:

AqBanking v6.2.2.0stable
Sending jobs to the bank(s)
Sorting commands by account
Sorting commands by account
Sorting commands by provider
Send commands to providers
Send commands to provider "aqofxconnect"
Locking customer "2"
Saving communication log to /tmp/ofx.log
Sending request...
Connecting to server...
Resolving hostname "online.americanexpress.com" ...
IP address is "23.67.235.83"
Connecting to "online.americanexpress.com"
Connected to "online.americanexpress.com"
Using GnuTLS default ciphers.
TLS: SSL-Ciphers negotiated: TLS1.3:ECDHE-RSA-AES-256-GCM:AEAD
Connected.
Sending message...
Message sent.
Waiting for response...
Receiving response...
HTTP-Status: 200 (OK)
Response received.
Disconnecting from server...
Disconnected.
Saving communication log to /tmp/ofx.log
Parsing response...
Status for signon request: Success (Code 0, severity "INFO")
The server successfully processed the request.
Status for transaction statement request: Account not found (Code 2003, severity "ERROR")
The specified account number does not correspond to one of the user's accounts.
Unlocking customer "2"

Sanitized Contents of the OFX.LOG File:

Sending:
-------------------------------------
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:20201019194220.000

<OFX>
<SIGNONMSGSRQV1>
<SONRQ>
<DTCLIENT>20201019194201.000
<USERID>XXXXXXXX
<USERPASS>XXXXXXXXXXXX
<LANGUAGE>ENG
<FI>
<ORG>AMEX
<FID>3101
</FI>
<APPID>QWIN
<APPVER>2200
</SONRQ>
</SIGNONMSGSRQV1>
<CREDITCARDMSGSRQV1>
<CCSTMTTRNRQ>
<TRNUID>20201019194220.000
<CLTCOOKIE>1
<CCSTMTRQ>
<CCACCTFROM>
<ACCTID>XXXXXXXXXXXXXXXX
</CCACCTFROM>
<INCTRAN>
<DTSTART>20201014000000.000
<DTEND>20201019000000.000
<INCLUDE>Y
</INCTRAN>
</CCSTMTRQ>
</CCSTMTTRNRQ>
</CREDITCARDMSGSRQV1>
</OFX>


Received:
-------------------------------------
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:20201019194220.000

<OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO<MESSAGE>Login successful</STATUS><DTSERVER>20201019124220.670[-7:MST]<LANGUAGE>ENG<FI><ORG>AMEX<FID>3101</FI><ORIGIN.ID>FMPWeb<CUSTOMER.TYPE>BCM<START.TIME>20201019124220</SONRS></SIGNONMSGSRSV1><CREDITCARDMSGSRSV1><CCSTMTTRNRS><TRNUID>20201019194220.000<STATUS><CODE>2003<SEVERITY>ERROR</STATUS><CLTCOOKIE>1</CCSTMTTRNRS></CREDITCARDMSGSRSV1></OFX>

Citibank Messages:

Messages Shown in the AQBanking GUI:

AqBanking v6.2.2.0stable
Sending jobs to the bank(s)
Sorting commands by account
Sorting commands by account
Sorting commands by provider
Send commands to providers
Send commands to provider "aqofxconnect"
Locking customer "3"
Saving communication log to /tmp/ofx.log
Sending request...
Connecting to server...
Resolving hostname "www.accountonline.com" ...
IP address is "104.72.140.84"
Connecting to "www.accountonline.com"
Connected to "www.accountonline.com"
Using GnuTLS default ciphers.
TLS: SSL-Ciphers negotiated: TLS1.2:ECDHE-RSA-AES-256-GCM:AEAD
Connected.
Sending message...
Message sent.
Waiting for response...
Receiving response...
HTTP-Status: 403 (Forbidden)
Unlocking customer "3"

Messages in the OFX.LOG File:

Sending:
-------------------------------------
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:20201019151026.000

<OFX>
<SIGNONMSGSRQV1>
<SONRQ>
<DTCLIENT>20201019150941.000
<USERID>XXXXXXXX
<USERPASS>XXXXXXXXXXXX
<LANGUAGE>ENG
<FI>
<ORG>Citigroup
<FID>24909
</FI>
<APPID>QWIN
<APPVER>2200
<CLIENTUID>
</SONRQ>
</SIGNONMSGSRQV1>
<CREDITCARDMSGSRQV1>
<CCSTMTTRNRQ>
<TRNUID>20201019151026.000
<CLTCOOKIE>1
<CCSTMTRQ>
<CCACCTFROM>
<ACCTID>XXXXXXXXXXXXXXXX
</CCACCTFROM>
<INCTRAN>
<DTSTART>20201010000000.000
<DTEND>20201019000000.000
<INCLUDE>Y
</INCTRAN>
</CCSTMTRQ>
</CCSTMTTRNRQ>
</CREDITCARDMSGSRQV1>
</OFX>

Thank you for any help you might give me.

Dale Franks

Sent from Mail for Windows 10