Help with Excel Web Query with Pinnaclesports

[pringles]

Hi, i have a problem using Pinnaclesports feed.
I used to scrape Pinnacle API with Excel Web query and have a parser built for manipulation


I didnt use Excel for months ... in december they introduced that API Key Authentication is being replaced with HTTP Basic Authentication


Anyways now i got back to my excel stuff and obviously im having trouble scraping pinacle xml feed at the moment


Last time i would do something simple like this in Excel Web Query + would add my API key in the URL :


https://api.pinnaclesports.com/v1/feed?sportid={sportid}&leagueid={leaguei d}&last={last}&oddsformat={oddsformat}&i slive={islive}&currencycode={currencycod e}


Now i need to put this coded username and password somewhere in the URL and i dont know where exactly and support wont help me with XML issues...


Only this text is in Pinnacle´s API FAQ


"
Authentication


Always use HTTPS to access the API.
API use HTTP Basic access authentication. You need to send HTTP Authorization header for all API commands . The Authorization header is constructed as follows:


1. Username and password are combined into a UTF-8 string "clientidassword"
2. The resulting string literal is then encoded using Base64
3. "Basic " is then put before the encoded string.


For example, if the client id is 'Aladdin' and password is 'open sesame' then the header is formed as
follows:
Authorization: Basic QWxhZGRpbjpvcGVuIHNlc2FtZQ==
"


So how do i input my username and password into the URL ...

Thanks guys

[pringles]

Cmon such a simple thing, most of you use pinny API .

[hotcoffee76]

Sorry I don't have a full answer but a quick google check looks like you need to write some VBA code. The issue is that you need to set the authentication details in the http request header - they can't be passed as URL parameters.

Maybe this helps:

http://excelramblings.blogspot.com/2012/05/how-to-do-http-basic-authentication.html

[sKaaaaY]

I'm sorry but I have the same problem.
Is someone hier who is able to give me an example?

Thanks