Help API Connection

[Anonymous]

Hi guys,

I need some help to solve a problem I can't find the solution.

I want to connect PowerQuery to a API that the token change automatically all the time. I tried to make a parameter to capture the token and built the complete URL of the API using that parameter but it doesn't work well. I can connect the API for a couple of minutes but crash later.

Anyone know how to solve it??

The URL to get the token is this one: 

The API is this (the value of the token continue after the equal sign, of course):

Thanks a lot !!!

[mahoneypat]

Instead of a parameter, you can make a query to retrieve your token and "drill down" so the output is a text value (instead of a table).  You can then use the result of that query in your second query.

Pat

[Anonymous]

Hi Mahoneypat,

Thanks a lot for your answer, I really appreciate it.

I don't know how can I do that 😞

[mahoneypat · Accepted solution]

If you create a blank query with Web.Contents (or use the Web connector) and use your Token URL, so you get a token in response?  If so, right click on the "cell" containing the token and choose "Drill Down" to get to just the text value.  Name that query something relevant and then use that name as part of a concatenated string in your second web call. 

Pat