Using Power BI Query to submit a PUT API request to obtain authorization token for GET API

gand3rs0n — Fri, 04 Dec 2020 23:55:44 GMT

Probably a beginner question here.

Trying to access a third party vendor API (GET). It requires an authorization token based on user supplied ID and password through a PUT API. Is there a way to use a Power BI query to get the authorization token. Once that is done is there a way to ensure it is dynamically included in the power BI query GET API? I think I need to include the PUT in the header somehow, but I am not able to figure this out.

The PUT API is structured as follows:

URL: https://xxxxx.xxxxx-put.com/api/Auth/Login

Request Type: PUT

Parameter Content Type: application/json

Body Parameters:

{

"Username": "string",

"Password": "string",

}

Response: {

"Data": {

"access_token": "xbxbssgdgdgdgdgdggdgd",

"token_type": "bearer"

"KeyValue": null,

"IsSuccessful": true,

"Errors": null

}

The get API is as follows

https://xxxxx.get.com/api/General/GetData

Any help is greatly appreciated

topic Using Power BI Query to submit a PUT API request to obtain authorization token for GET API in Developer

Using Power BI Query to submit a PUT API request to obtain authorization token for GET API