Forum Discussion
Issue with returning a table.
Have you seen this post?
This and a few other posts of Chris' on the topic may offer some guidance.
This is probably where my knowledge of accessing APIs via Power Query ends but I would've thought that something like the below would be more likely to return the format that you're expecting. (note the 'RelativePath...')
// Query2
let
url = "https://auth.myxplor.com/api/v1/auth",
body = "{ ""user"": ""xxxxxxxxx"", ""password"": ""xxxxxxxxx""}",
tokenResponse = Json.Document(
Web.Contents(
url,
[Headers = [#"Content-Type" = "application/json"], Content = Text.ToBinary(body)]
)
),
data1 = tokenResponse[data],
token = "Bearer " & data1[token],
source = (Centreid as text) =>
Json.Document(
Web.Contents(
"https://office.myxplor.com/api/enterprise/booking/center/rooms/summary",
[
RelativePath=Centreid,
Headers = [
#"x-api-key" = "xxxxxxxxxxxxxxxxxxxxxxxxxxxx",
Authorization = token,
#"Content-Type" = "application/json"
]
]
)
)
in
source
Doing this with the code you provided returns an error...
Unless of course that is expected because you haven't provided actual creds to access the API, which is kind of what I'd expect you'd do. 🤔
Edit: removed sensitive info.
Thank you KNP that has worked in the desktop version. You have saved me thank you.
Will need to test once published as I have found some weird errors but will come back as soon as I have tested.
Would you mind deleted the code from your last post I inadvertantly posted passwords etc.
They have been changed but would still like that info gone.
Again thank you I have been trying for weeks to get this far.
KNP
Have edited the post to exclude the sensitive info.
Not sure how to deal with the Syndicate_Admin post though as I don't know if anyone monitors that.