Forum Discussion
Connect to API with token that changes
Hello, I am trying to connect to an API that requires re creation of a token every 8 hours. I can get it to create a token and pull the json into postman, but not into Power Bi. When I use that postm...
I'm now finding the issue is it is a POST request instead of GET, is there any way to connect to data of they have it set up as a POST?
HI Anonymous,
In fact, you can also use post requests in the power query web connector. You need to add the request contents to the header or body(this is based on your API settings) and attached them to the data connector.
let
rootURL = "app.xxx.com",
secretId = xxxxx,
GetJson =
Web.Contents(
rootURL,
[
Headers = [
#"Authorization" = "Basic " & secretId,
#"Content-Type" = "application/json"
],
Content = Text.ToBinary("grant_type=client_credentials")
]
),
body = "xxxxx",
Result =
Web.Contents(
rootURL,
[
Headers = [
Authorization = "Bearer " + token,
apikey = "xxxxxxx",
RelativePath = "/api/departments/list/",
Content = Text.ToBinary(body),
ContentType = "application/json"
],
Query = [
page = "1",
sortDirection = "asc"
]
]
)
in
Result
Regards,
Xiaoxin Sheng