[GNC] AQBanking OFX DirectConnect

chris graves mohavebaked at gmail.com
Wed Mar 18 16:59:27 EDT 2020


I think that would have been a mistake, git defaults to OFXv1.

> On Mar 18, 2020, at 1:38 PM, Christopher Singley <csingley at gmail.com> wrote:
> 
> See the top post on this thread - John Ralls reporting that git only speaks OFXv2.  However many banks only speak OFXv1.
> 
> I can confirm that I can download from USAA by speaking OFXv1.0.2.
> 
> I can no longer speak OFXv2 to USAA; something has changed on their side.
> 
> Sorry John, no workaround yet.
> 
> On 3/18/20 3:30 PM, Chris Graves wrote:
>> Here is what I was thinking were significant differences found in ofx.log.
>> AQB5 vs git, which should be defaulting to OFX 1.
>> 
>> AQB5:
>> Sending:
>> -------------------------------------
>> OFXHEADER:100
>> DATA:OFXSGML
>> VERSION:102
>> SECURITY:NONE
>> ENCODING:USASCII
>> CHARSET:1252
>> COMPRESSION:NONE
>> OLDFILEUID:NONE
>> NEWFILEUID:20200318081757.000
>> 
>> <OFX>...
>> 
>> git:
>> Sending:
>> -------------------------------------
>> <?xml version="1.0" encoding="utf-8" standalone="no"?>
>> <?OFX OFXHEADER="200" VERSION="220" SECURITY="NONE" OLDFILEUID="NONE"?>
>> <OFX>...
>> 
>> On Wed, Mar 18, 2020 at 1:23 PM John Ralls <jralls at ceridwen.us <mailto:jralls at ceridwen.us>> wrote:
>> That would be because they are XML syntax. OFX V2 is XML.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>> > On Mar 18, 2020, at 1:15 PM, chris graves <mohavebaked at gmail.com <mailto:mohavebaked at gmail.com>> wrote:
>> > 
>> > Because I don't see them in the AQB5 ofx.log file and to me they look like XML syntax.  Not being knowledgeable on the subject I can't say for sure.  I thought at v1.6, the syntax was pure SMGL.  But again, I don't know what I don't know.
>> > 
>> >> On Mar 18, 2020, at 1:12 PM, John Ralls <jralls at ceridwen.us <mailto:jralls at ceridwen.us>> wrote:
>> >> 
>> >> And why were you thinking that?
>> >> 
>> >> Regards,
>> >> John Ralls
>> >> 
>> >> 
>> >>> On Mar 18, 2020, at 1:05 PM, chris graves <mohavebaked at gmail.com <mailto:mohavebaked at gmail.com>> wrote:
>> >>> 
>> >>> I was thinking that it could be the first two lines of your file below.
>> >>> 
>> >>>> On Mar 18, 2020, at 12:40 PM, John Ralls <jralls at ceridwen.us <mailto:jralls at ceridwen.us>> wrote:
>> >>>> 
>> >>>> 
>> >>>> 
>> >>>>> On Mar 18, 2020, at 9:33 AM, Christopher Singley <csingley at gmail.com <mailto:csingley at gmail.com>> wrote:
>> >>>>> 
>> >>>>> You're sending VERSION="220", which USAA doesn't accept.  You need to send VERSION="200" or VERSION="202".  Try that.
>> >>>> 
>> >>>> No joy, I still get a 400 response, but it does occur to me that it isn't necessarily an OFX issue, it could be that the HTTP request itself is malformed.
>> >>>> 
>> >>>> <?xml version="1.0" encoding="utf-8" standalone="no"?>
>> >>>> <?OFX OFXHEADER="200" VERSION="202" SECURITY="NONE" OLDFILEUID="NONE"?>
>> >>>> <OFX>
>> >>>> <SIGNONMSGSRQV1>
>> >>>> <SONRQ>
>> >>>> <DTCLIENT>20200318122832</DTCLIENT>
>> >>>> <USERID>XXXXXXXX</USERID>
>> >>>> <USERPASS>XXXXXXXX</USERPASS>
>> >>>> <LANG>ENG</LANG>
>> >>>> <FI>
>> >>>> <ORG>USAA</ORG>
>> >>>> <FID>24591</FID>
>> >>>> </FI>
>> >>>> <APPID>QWIN</APPID>
>> >>>> <APPVER>2300</APPVER>
>> >>>> </SONRQ>
>> >>>> </SIGNONMSGSRQV1>
>> >>>> <CREDITCARDMSGSRQV1>
>> >>>> <CCSTMTTRNRQ>
>> >>>> <TRNUID>20200318122835</TRNUID>
>> >>>> <CCSTMTRQ>
>> >>>> <CCACCTFROM>
>> >>>> <BANKID>24591</BANKID>
>> >>>> <ACCTID>XXXXXXXXXX</ACCTID>
>> >>>> </CCACCTFROM>
>> >>>> <INCTRAN>
>> >>>> <DTSTART>20200310000000</DTSTART>
>> >>>> <DTEND>20200318000000</DTEND>
>> >>>> <INCLUDE>Y</INCLUDE>
>> >>>> </INCTRAN>
>> >>>> </CCSTMTRQ>
>> >>>> </CCSTMTTRNRQ>
>> >>>> </CREDITCARDMSGSRQV1>
>> >>>> </OFX>
>> >>>> 
>> >>>> Regards,
>> >>>> John Ralls
>> >>>> _______________________________________________
>> >>>> gnucash-user mailing list
>> >>>> gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
>> >>>> To update your subscription preferences or to unsubscribe:
>> >>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>> >>>> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists <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