Paradox Community

Items in pnews.paradox-programming

Subject:Re: Downloading and saving as a csv via API Call
Date:Mon, 30 Apr 2018 16:48:51 +1000
From:Leslie <"ViaThe List"@NOSPAM.com>
Newsgroups:pnews.paradox-programming
Not sure about Paradox OPAL but there are a bunch of Win32 API calls to 
download a file, Start with the InternetOpenUrl() function.

Leslie.


On 30/04/2018 2:46 PM, Robert MacMillan wrote:
> 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.
>

---
This email has been checked for viruses by AVG.
http://www.avg.com


Copyright © 2004 thedbcommunity.com