Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi ,
How to generate API access token dynamically using refresh token or basic auth (username and passowrd)
I tried to generate access token dynamically but failed with the below.
let
url ="https://testapi.apples.com/api/v1/auth",
headers = [#"Content-Type" = "application/json"],
postData = Json.FromValue([username="username",
password= "password"]),
response = Web.Contents(
url,
[
Headers = headers,
Content = postData
]
),
access_token = Json.Document(response)
in
access_token
Error:
DataSource.Error: Web.Contents failed to get contents from 'https://testapi.apples.com/api/v1/auth' (400): Bad Request
Details:
DataSourceKind=Web
DataSourcePath=https://testapi.apples.com/api/v1/auth
Url=https://testapi.apples.com/api/v1/auth
Any suggestions would be much appriciated.
Many thanks
Solved! Go to Solution.
@venusura483 , refer if these can help
https://www.advaiya.com/generate-dynamic-token-and-get-data-from-custom-api-in-power-bi/
@amitchandak , It is resolved with https://community.fabric.microsoft.com/t5/Power-Query/Channel-Advisor-API-Connection-with-auth-key-c...
Thank you.