[GNC] Unsuccessful aqBanking to TD AmeriTrade

[Morris Beavers]

 Hello Everyone,

I am trying to migrate from Windows/Quicken (successful online access) to
Raspbian/GnuCash (failure). New GnuCash user here. I’m trying to get online
data from TD AmeriTrade.

Hardware: Raspberry Pi 4, 4GB. Software: GnuCash Ver 3.4 Build id 3.4+
(2018-12-30) Finance::Quote: 1.49, libaqbanking35-5.7.8-3 with plugins and
data, libaqofxconnect7-5.7.8-3

If someone has success with online access to TD AmeriTrade please reply
with User and Account settings or indicate what is wrong with my aqBanking
User or Account settings.

Below are my actions to create user and account, query Account list
(successfully?), Get Balance and Transactions (failure).

Define aqBanking User and Account.

File contents: .aqbanking/settings/users/uid%3a%3a0000000c.conf
int uniqueId="30"
char backendName="aqofxconnect"
char userName="John Doe"
char userId="xxxxxxxx5"
char customerId="xxxxxxxx5"
char country="us"
char bankCode="0000000000"
int lastSessionId="0"

data {
  backend {
  char bankName="TD Ameritrade"
  char brokerId="ameritrade.com"
  char org="ameritrade.com"
  char fid="5024"
  char serverAddr="https%3A%2F%2Fofxs.ameritrade.com%2Fcgi-bin%2Fapps%2FOFX"
  char appId="QWIN"
  char appVer="2200"
  char headerVer="102"
  int httpVMajor="1"
  int httpVMinor="1"
  } #backend
} #data

File contents: .aqbanking/settings/accounts/uid%3a%3a00000006.conf
char provider="aqofxconnect"
int uniqueId="32"
int accountType="7"
char accountNumber="xxxxxxxx5"
char bankCode="ameritrade.com"
char bankName="ameritrade.com"
char country="us"
int user="30"

data {
  backend {
  int maxPurposeLines="1"
  int debitAllowed="0"
  } #backend
} #data

Download account list output:
06:56:42 Sending request...
06:56:42 Using GnuTLS default ciphers.
06:56:42 TLS: SSL-Ciphers negotiated: TLS1.2:RSA-AES-256-GCM:AEAD
06:56:42 Waiting for response...
06:56:42 Parsing response...
06:56:42 Parsing response
06:56:42 Status for signon request: Success (Code 0, severity "INFO")
The server successfully processed the request.
06:56:42 Status for account info request: Success (Code 0, severity "INFO")
The server successfully processed the request.
06:56:42 Adding account xxxxxxxx5 to bank ameritrade.com
06:56:42 Operation finished, you can now close this window.

Match Online accounts with GnuCash accounts.
Bank code ameritrade.com (ameritrade.com), Account xxxxxxxx5()
Assets:Investments:JohnDoe Roth IRA xx5

Open the “JohnDoe Roth IRA xx5” account:
Actions>Online Action>Get Balance:
Log Messages:
AqBanking v5.7.8.0stable
Sending jobs to the bank(s)
Locking user xxxxxxxx5

Prompt for Password:

Log Messages:
Sending request...
Connecting to server...
Resolving hostname "ofxs.ameritrade.com" ...
IP address is "198.200.171.142"
Connecting to "ofxs.ameritrade.com"
Connected to "ofxs.ameritrade.com"
Using GnuTLS default ciphers.
TLS: SSL-Ciphers negotiated: TLS1.2:RSA-AES-256-GCM:AEAD
Connected.
Sending message...
Message sent.
Waiting for response...
Receiving response...
HTTP-Status: 400 (Bad Request)
Error parsing server response
Unlocking user xxxxxxxx5
Postprocessing jobs
Job Get Balance: finished
Resetting provider queues

Actions>Online Action>Get Transactions:

Log Messages:
AqBanking v5.7.8.0stable
Sending jobs to the bank(s)
Locking user xxxxxxxx5

Prompt for Password:

Log Messages:
Sending request...
Connecting to server...
Resolving hostname "ofxs.ameritrade.com" ...
IP address is "198.200.171.142"
Connecting to "ofxs.ameritrade.com"
Connected to "ofxs.ameritrade.com"
Using GnuTLS default ciphers.
TLS: SSL-Ciphers negotiated: TLS1.2:RSA-AES-256-GCM:AEAD
Connected.
Sending message...
Message sent.
Waiting for response...
Receiving response...
HTTP-Status: 400 (Bad Request)
Error parsing server response
Unlocking user xxxxxxxx5
Postprocessing jobs
Job Get Transactions: finished
Resetting provider queues

Pop-up message:
The Online Banking import returned no transaction for the selected time
period.

Thank you for your interest and assistance,

Morris