Excel - Powerquery Help with setting up Authentication through API

[Desotronics]

Hi There,

Could some one help me setup a web query *through powerquery* to a website called.
https://woei.degraaflogistics.nl/nl/default.aspx

i would like to download the data behind the login screen but first i need to login.
The IT people of the company has made a name a Apikey and a token for me.

I'm not sure how to start setting up and what i exactly need to do so.

So far i've read.
You need to put the apikey/token in the header in the advanced editor (so hard code it)
You always need to click anonymous.

i have tried some things but i wont get far...

greetings,

Aaron

[AliGW]

There's an excellent tutorial here: https://www.myonlinetraininghub.com/...-filling-forms

[Olly]

Change your Web.Contents query string to include the API Token:

Please Login or Register  to view this content.

Now change the Data Source Settings, Edit Permissions, Edit Credentials, select Web API and enter your API key:

Attachment 633749

[Desotronics]

Hi There,

I can't download anything and i am using office 365 with powerquery added in.

But that looks like a nice tut.

gr,

Aaron

[Olly]

You don't need to download anything?

[Desotronics]

Hey olly,

Hmm that's weird i replied to the post of the lady.

Ill try your method soon

sadly i can't see the attachment.
it redirects me to this website with a contact the moderator.

gr,

Aaron

[Olly]

The attachment was just an image of the Access Web Content dialog box, where you need to select "Web API" and enter your API key.

[AliGW]

I didn't tell you to download anything - I merely pointed you to a tutorial that I felt might help you!

Image from post #3:

[Desotronics]

I didn't tell you to download anything - I merely pointed you to a tutorial that I felt might help you!

the tutorial describes i need to download selenium basic in order to get moving. sadly i can't download anything since we have an IT department.
thanks for the image.. Im going to try and set this thing up!

[Desotronics]

Change your Web.Contents query string to include the API Token:

Please Login or Register  to view this content.

Now change the Data Source Settings, Edit Permissions, Edit Credentials, select Web API and enter your API key:

Attachment 633749

Hey olly,

What do i exactly need to do?

As far as i can understand:

Create a new source -> different sources -> Web.

At url I use default - https://woei.degraaflogistics.nl/nl/default.aspx -> OK


than copy past the stuff you said to advanced editor.

Now when i click source i can see that the from WEB has changed to advanced and there is a url-part and now i see Parameters of http header = APItoken .

Now it gives me the error that my reference that i gve is invalid
When i open the error it gives me the Key and level i need the key to be used.

I have tried to put the token in but then he say's a web API key can only be used when the web api key has a name.
so now im stranded there

They made me a login name - a password and a token. Is the token the two combined?

greetings,

Aaron

[Olly]

Anything I advise now will be guesswork - you need to speak to the API authors to clarify exactly what needs passed in the query, to authenticate correctly.

[Desotronics]

I will try and contact the IT department @ the website.

thanks for the help.

greetings,
aaron