Paradox Community

Items in pnews.paradox-programming

Subject:Downloading and saving as a csv via API Call
Date:Mon, 30 Apr 2018 14:46:53 +1000
From:Robert MacMillan <macfam@bigpond.net.au>
Newsgroups:pnews.paradox-programming
Hello

this should be easy but I cant figure it out.

I have API access to this address:- 
http://www.puntingform.com.au/api/ratingsservice/getsouthcoastdata/standard/true/all?apikey=xxxxxxxxxxxxxxxxxxxxxxxxx

I can open it from within Paradox using a ShellexecuteA call but that 
just opens up the browser with the information visible in csv format. 
Presumably it is possible to then send commands to the window via DDE to 
save the file and then close the window but that is not my preferred 
option nor do I know how to do it.

What I want to do is simply call it like I do the Betfair API, return 
the information not as a string but saved directly into a .csv file. 
Same place and file name every day.

Should be about 5 or 6 lines of code but I cant figure it out.

The returned information looks like-

Race_Date,Track_Code,Track_Name,Race_Number,Horse_Name,TP20R,TP20P,PFScore,NSWPr,VICPr,PrSe,RunStyle,AHSP,ETRPrRk,ETRPrice,RPR,RPP,WP20R,WP20P,WPTP20R,WPTP20P,ClsDiff,ATWC,AveATWC,ScRank,SPrice,Tab_No,HorseId
14/04/2018,ARAT,Ararat,1,Avachat,5,29.97,67,10.2,7.7,7,bm,92.21,25,900,5,30.33,4,36.51,4,32.92,-6.4,61.4,72.54,25,900,1,834727

Many thanks for all help.


Copyright © 2004 thedbcommunity.com