[AccessD] Retrieve data from a URL.

Doug Steele dbsteele at dccnet.com
Mon Feb 15 14:19:35 CST 2010


Hello All:

I'm trying to implement the www.toodledo.com API from an Access database.
To work with the API, you first send a URL with a command, like:

http://api.toodledo.com/api.php?method=getToken;userid=td4b703588b0844

then the website sends you back some xml with the response, like:

<token>td4b799afb28f85</token>

How can I get the response text back into Access?  If I do something like

Application.FollowHyperlink "
http://api.toodledo.com/api.php?method=getToken;userid=td4b703588b0844"

Then I just get an Internet Explorer window with the xml showing it it.  I
found some code on the web which gets Yahoo stock prices saves them into a
text file, reads the file and parses it, but that seems a bit roundabout.

Thanks,

Doug



More information about the AccessD mailing list