OFX connection to Vanguard

[Mark Soper]

Thanks, David!  I was able to get it to work by removing the FID.

Cheers,

Mark

-----------------------
Mark Soper
markasoper at hotmail.com
25 Fairmont St #2
Cambridge, MA 02139
(617) 491-4134
-----Original Message-----
From: David Reiser [mailto:dbreiser at earthlink.net] 
Sent: Wednesday, April 18, 2007 12:18 AM
To: Mark Soper
Cc: gnucash-user at gnucash.org
Subject: Re: OFX connection to Vanguard

Yes, make sure you don't define <FID> for Vanguard (leave it out of  
ofx.py). Vanguard, and many other brokers, do not have an FID. Some  
of them ignore extra info on login attempts. Vanguard fails the login  
attempt if you send it anything more than it requires.


On 17 Apr 2007, at 11:19:16 PM, Mark Soper wrote:

> Hi -
>
>
>
> Anyone successfully connected to Vanguard via OFX?  I have tried many
> different combinations of message and headers using ofx.py, but  
> keep getting
> a "400: Bad Request" error.  Any ideas would be appreciated.   
> Details below:
>
> Regards,
>
> Mark Soper
> --------------------------------------- urllib2 header
> -----------------------------
>
> {'Content-length': 765, 'Content-type': 'application/x-ofx'}
>
> ----------------------------------------- ofx request
> ------------------------------
>
> <?OFX OFXHEADER="200" VERSION="200" SECURITY="NONE" OLDFILEUID="NONE"
> NEWFILEUID="NONE" ?>
>
> <OFX>
> <SIGNONMSGSRQV1>
> <SONRQ>
> <DTCLIENT>20070417220540</DTCLIENT>
> <USERID>********</USERID>
> <USERPASS>**********</USERPASS>
> <LANGUAGE>ENG</LANGUAGE>
> <FI>
> <ORG>The Vanguard Group</ORG>
> <FID>5641</FID>
> </FI>
> <APPID>QWIN</APPID>
> <APPVER>1200</APPVER>
> </SONRQ>
> </SIGNONMSGSRQV1>
> <INVSTMTMSGSRQV1>
> <INVSTMTTRNRQ>
> <TRNUID>BE758D81-3935-4A32-8BE0-A55007A31A65</TRNUID>
> <INVSTMTRQ>
> <INVACCTFROM>
> <BROKERID>vanguard.com</BROKERID>
> <ACCTID>*********4345</ACCTID>
> </INVACCTFROM>
> <INCTRAN>
> <INCLUDE>Y</INCLUDE>
> </INCTRAN>
> <INCOO>Y</INCOO>
> <INCPOS>
> <INCLUDE>Y</INCLUDE>
> </INCPOS>
> <INCBAL>Y</INCBAL>
> </INVSTMTRQ>
> </INVSTMTTRNRQ>
> </INVSTMTMSGSRQV1>
> </OFX>
>
Dave
--
David Reiser
dbreiser at earthlink.net