Forum Discussion
Issue with returning a table.
- 4 years ago
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.
Hi KNP.
Its works in desktop however when published to the web and I try a refresh i get this error.
[Unable to combine data] Section1/Centreids/Expanded Query1 references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
- KNP4 years agoSuper User
Have you seen this post?
This and a few other posts of Chris' on the topic may offer some guidance.
- v-jingzhang4 years agoCommunity Support
Hi trwatts
I found a similar question, see if the solution there works. Unable to combine data...AutoRemovedColumns1...Please rebuild this data combination (microsoft.com)
Best Regards,
Community Support Team _ Jing