Downloading Transactions
Re: Downloading Transactions
Many thanks. I'm looking forward to using it.
-
- Posts: 1
- Joined: 15 April 2010, 00:08
Re: Downloading Transactions
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.
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.
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>
I have a french Amex card, I don't know if it is supposed to work or not.
Re: Downloading Transactions
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>
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>
Last edited by abz on 20 May 2010, 04:26, edited 1 time in total.
Re: Downloading Transactions
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>
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
- Administrateur
- Posts: 2303
- Joined: 28 December 2008, 21:28
- Location: Toulouse, France
- Contact:
Re: Downloading Transactions
Try to change App ID and version in the import window to QWIN and 1700 for example.abz wrote: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>
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 wrote:However, T Rowe Price is not working at all:
Re: Downloading Transactions
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>
<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
- Administrateur
- Posts: 2303
- Joined: 28 December 2008, 21:28
- Location: Toulouse, France
- Contact:
Re: Downloading Transactions
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 ?
Re: Downloading Transactions
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
OFXAdapter: FFSException: OFXAdapter: Unable to find FI information. Make sure the FI in the request is configured with this server
- Angeman
- Administrateur
- Posts: 2303
- Joined: 28 December 2008, 21:28
- Location: Toulouse, France
- Contact:
Re: Downloading Transactions
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 ?