[GNC] AQBanking OFX DirectConnect

Christopher Singley csingley at gmail.com
Wed Mar 18 12:33:50 EDT 2020


You're sending VERSION="220", which USAA doesn't accept.  You need to 
send VERSION="200" or VERSION="202".  Try that.

On 3/18/20 11:31 AM, John Ralls wrote:
> Interesting. USAA can't parse the OFXv2 that AQBanking 6.1.2 emits. Unfortunately it just returns an HTTP 400 response, no details. Perhaps like v1 there are Intuit-induced quirks in the v2 parser as well and we'd need to capture a v2 interaction with Quicken to figure them out.
>
> Regards,
> John Ralls
>
>> On Mar 18, 2020, at 4:35 AM, csingley <csingley at gmail.com> wrote:
>>
>>> Aside from the extra whitespace, which shouldn't matter, the git code has
>> closing tags on every element while the AQB5 code has closing tags only on
>> grouping elements.
>>> USERID is specified in the OFX 1.6 DTD as
>>> <!ELEMENT USERID    - o %IDTYPE>
>>> and according to
>>> https://en.wikipedia.org/wiki/Standard_Generalized_Markup_Language#OMITTAG
>>> the "- o" in the middle means that it should have an opening tag and no
>>> closing tag.
>> Sorry to butt in..  MAY have, not SHOULD have.  Closing tags are optional
>> for OFXv1 "elements" (i.e. data-bearing leaf nodes).
>>
>> But the spec doesn't really matter in the real world.  The FIs code to
>> Quicken, not to the spec... and Quicken sends OFXv1 with unclosed elements.
>> Therefore, AqBanking really should do so as well in order to be useful.
>>
>> Contrary to the spec, USAA doesn't accept closing tags on elements.
>> However, USAA does accept OFXv2, specifically versions 202 and 205.  Just
>> send them XML.
>>
>> Here's the result of scanning USAA's server:
>>
>> (ofxtools) 6:30:50 csingley at nous ofxtools sequences ? ofxget scan usaa
>> [{"versions": [102, 151], "formats": [{"pretty": false, "unclosedelements":
>> true}, {"pretty": true, "unclosedelements": true}]}, {"versions": [200,
>> 202], "formats": [{"pretty": false}, {"pretty": true}]}, {"chgpinfirst":
>> false, "clientuidreq": false, "authtokenfirst": false, "mfachallengefirst":
>> false}]
>>
>>
>>
>>
>> --
>> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at 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.


More information about the gnucash-user mailing list