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
Check out new user group experience and if you are a leader please create your group
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.