API Access (Tip Retrieval)

If you want to build you own Exchange interface, without using Gruss Betting Assist, or don’t want to use our spreadsheet, here’s our spreadsheet retrieves tips using an API call.

Our spreadsheet uses a built in Windows program called cURL.exe.

You will need to encode (Base64Encoding) your username & password, separated with a “:” (colon).

e.g. sAuth = “Username:Password” > Base64Encoded

The VBA function that performs Base64Encoding is included in a separate post, in this forum.

Select the subscription type you have paid for:

sSubscriptionType = “single” | “dual” (one or the other)

Build a command line call with cURL.exe like:

sCmd = sCmd & “cURL.exe –globoff -H ” & Chr(34) & “Authorization:Basic ”
sCmd = sCmd & sAuth & Chr(34) & ” ”
sCmd = sCmd & “-X GET https://www.flat-racing.com/wp-json/wp/v2/pages?slug=tip-” & sSubscriptionType & ” “

You will need an active subscription before you can retrieve a tip. Our website limits tip retrieval, by username, to 1 or 2 attempts, based on the subscription type (single, or dual tip).

• This topic was modified 4 years, 5 months ago by nick257.