Downloading Transactions

[abz]

Many thanks. I'm looking forward to using it.

[bvauchelle]

You probably want to try the URL https://online.americanexpress.com/myca ... fxdownload instead of https://www99.americanexpress.com/myca/ ... opdownload .
For me the login seems to work with this.

Code: Select all

OFX REQUEST https://online.americanexpress.com/myca/ofxdl/desktop/desktopDownload.do?request_type=nl_ofxdownload
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX>
<SIGNONMSGSRQV1>
<SONRQ>
<DTCLIENT>20100415
<USERID> [color=#FF0000]xxxxxxxxx[/color]
<USERPASS>[color=#FF0000]xxxxxxxxx[/color]
<LANGUAGE>ENG
<FI>
<ORG>AMEX
<FID>3101
</FI>
<APPID>QWIN
<APPVER>1500
</SONRQ>
</SIGNONMSGSRQV1>
<CREDITCARDMSGSRQV1>
<CCSTMTTRNRQ>
<TRNUID> [color=#FF0000]xxxxxxxxx[/color]
<CCSTMTRQ>
<CCACCTFROM>
<ACCTID> [color=#FF0000]xxxxxxxxx[/color]
</CCACCTFROM>
<INCTRAN>
<DTSTART>19700101
<INCLUDE>Y
</INCTRAN>
</CCSTMTRQ>
</CCSTMTTRNRQ>
</CREDITCARDMSGSRQV1>
</OFX>



OFX RESPONSE
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX>
   <SIGNONMSGSRSV1>
      <SONRS>
         <STATUS>
            <CODE>0
            <SEVERITY>INFO
            <MESSAGE>Login successful
         </STATUS>
         <DTSERVER>20100414143905.425[-7:MST]
         <LANGUAGE>ENG
         <FI>
            <ORG>AMEX
            <FID>3101
         </FI>
         <START.TIME>20100414143905
         <ORIGIN.ID>FMPWeb
      </SONRS>
   <SIGNONMSGSRSV1>
   <CREDITCARDMSGSRSV1>
      <CCSTMTTRNRS>
         <TRNUID> [color=#FF0000]xxxxxxxxx[/color]
         <STATUS>
            <CODE>2003
            <SEVERITY>ERROR
         </STATUS>
      </CCSTMTTRNRS>
   </CREDITCARDMSGSRSV1>
</OFX>

But I can't go further: it seems that my account is unknown (I had a look a the meaning of the error code 2003 in the ofx spec). I don't know exactly what is the number I should put in the "Number:" field (which is used for the <ACCTID> request value). Which part of the credit card number did you use? First ten? Last ten?

I have a french Amex card, I don't know if it is supposed to work or not.

[abz]

I get the same error in version 4. How do I fix this so I can download transactions?

Server
https://www99.americanexpress.com/myca/ ... opdownload

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

<OFX>
<SIGNONMSGSRQV1>
<SONRQ>
<DTCLIENT>20100519
<USERID>XXXXXXXXX
<USERPASS>XXXXXX
<LANGUAGE>ENG
<FI>
<ORG>AMEX
<FID>3101
</FI>
<APPID>QWIN
<APPVER>9999
</SONRQ>
</SIGNONMSGSRQV1>
<CREDITCARDMSGSRQV1>
<CCSTMTTRNRQ>
<TRNUID>E7B4A15D-9A02-445C-A275-5A52FCA0AA2B
<CCSTMTRQ>
<CCACCTFROM>
<ACCTID>xxxxxxxxxx
</CCACCTFROM>
<INCTRAN>
<DTSTART>19700101
<INCLUDE>Y
</INCTRAN>
</CCSTMTRQ>
</CCSTMTTRNRQ>
</CREDITCARDMSGSRQV1>
</OFX>

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

<OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>2000<SEVERITY>ERROR<MESSAGE>[ofx.unsupportedClientApplication]
Client application or version is not supported by this server.
[ref: 20100520020332.312]</STATUS><DTSERVER>20100519190332.312[-7:MST]<LANGUAGE>ENG<FI><ORG>AMEX<FID>3101</FI></SONRS></SIGNONMSGSRSV1><CREDITCARDMSGSRSV1><CCSTMTTRNRS><TRNUID>E7B4A15D-9A02-445C-A275-5A52FCA0AA2B<STATUS><CODE>15500<SEVERITY>ERROR</STATUS></CCSTMTTRNRS></CREDITCARDMSGSRSV1></OFX>

[abz]

Per message above, the Amex address in the factory default is incorrect. The author above cited the correct address: https://online.americanexpress.com/myca ... fxdownload.

However, T Rowe Price is not working at all:

Server
https://www3.troweprice.com/ffs/ffsweb/OFXServlet

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

<OFX>
<SIGNONMSGSRQV1>
<SONRQ>
<DTCLIENT>20100519
<USERID>XXXXXXXX
<USERPASS>XXXXXXXXX
<LANGUAGE>ENG
<FI>
<ORG>T. Rowe Price
<FID>
</FI>
<APPID>QWIN
<APPVER>1500
</SONRQ>
</SIGNONMSGSRQV1>
<INVSTMTMSGSRQV1>
<INVSTMTTRNRQ>
<TRNUID>FA8AD224-4088-4E4C-BFEE-5BA7FFD2B26D
<INVSTMTRQ>
<INVACCTFROM>
<ACCTID>XXXXXXXXXXX
<BROKERID>troweprice.com
</INVACCTFROM>
<INCTRAN>
<DTSTART>19700101
<INCLUDE>Y
</INCTRAN>
</INVSTMTRQ>
</INVSTMTTRNRQ>
</INVSTMTMSGSRQV1>
</OFX>

Response
OFXAdapter: Failed to parse request: Unable to parse a union field "OFXRequest.OFXRequest.SignOnMsgsRqUn": union is empty.
Remaining unparsed data:
<SIGNONMSGSRQV1>
<SONRQ>
<DTCLIENT>20100519
<USERID>xxxxxx
<USERPASS>xxxxxxxx
<LANGUAGE>ENG
<FI>
<ORG>T. Rowe Price
<FID>
</FI>
<APPID>QWIN
<APPVER>1500
</SONRQ>
</SIGNONMSGSRQV1>
<INVSTMTMSGSRQV1>
<INVSTMTTRNRQ>
<TRNUID>FA8AD224-4088-4E4C-BFEE-5BA7FFD2B26D
<INVSTMTRQ>
<INVACCTFROM>
<ACCTID>xxxxxxxx
<BROKERID>troweprice.com
</INVACCTFROM>
<INCTRAN>
<DTSTART>19700101
<INCLUDE>Y
</INCTRAN>
</INVSTMTRQ>
</INVSTMTTRNRQ>
</INVSTMTMSGSRQV1>
</OFX>

[Angeman]

I get the same error in version 4. How do I fix this so I can download transactions?

...

<OFX><SIGNONMSGSRSV1><SONRS><STATUS><CODE>2000<SEVERITY>ERROR<MESSAGE>[ofx.unsupportedClientApplication]
Client application or version is not supported by this server.
[ref: 20100520020332.312]</STATUS><DTSERVER>20100519190332.312[-7:MST]<LANGUAGE>ENG<FI><ORG>AMEX<FID>3101</FI></SONRS></SIGNONMSGSRSV1><CREDITCARDMSGSRSV1><CCSTMTTRNRS><TRNUID>E7B4A15D-9A02-445C-A275-5A52FCA0AA2B<STATUS><CODE>15500<SEVERITY>ERROR</STATUS></CCSTMTTRNRS></CREDITCARDMSGSRSV1></OFX>

Try to change App ID and version in the import window to QWIN and 1700 for example.

Capture d’écran 2010-05-20 à 10.19.11.png (53.36 KiB) Viewed 233 times

However, T Rowe Price is not working at all:

Make sure the type of your account is "Credit Card" as it doesn't seem able to parse the request otherwise and uncheck the "Institution ID" box as well. I don't know if it works as I don't have a real login/password to try with but at least the error I got was different.

[abz]

Sorry, didn't work. The error says, "OFXAdapter: Failed to parse request: Unable to parse a composite field "OFXRequest.OFXRequest": postTag "/OFX" not found." It appears as though there are some closing statements for which there are no opening statements:

<INVACCTFROM>
<ACCTID>#########
<BROKERID>troweprice.com
</INVACCTFROM>
<INCTRAN>
<DTSTART>19700101
<INCLUDE>Y
</INCTRAN>
</INVSTMTRQ>
</INVSTMTTRNRQ>
</INVSTMTMSGSRQV1>
</OFX>

These statements have no corresponding opening (e.g., <INVSTMTRQ>):
</INVSTMTRQ>
</INVSTMTTRNRQ>
</INVSTMTMSGSRQV1>

[Angeman]

The <INVACCTFROM> tag means you set the type of your account to "Investment" so could you change it to "Credit Card" in the account window and try again ?

[abz]

Thanks for your prompt reply. Changing the account type to "Credit Card" yield a different error:

OFXAdapter: FFSException: OFXAdapter: Unable to find FI information. Make sure the FI in the request is configured with this server

[Angeman]

This one I don't know how to solve it. Is there any chance your bank could tell you the "Institution ID" to use for OFX direct download connection ?