Forum Discussion

trwatts's avatar
trwatts
Helper I
4 years ago
Solved

Issue with returning a table.

Hi Everyone  New to M query and having issues get a table of records.  I am calling through API. Bearer Token needs to be called. The URL has a dynamic ID at the end of the url which returns a se...
Need Help
trwatts's avatar
trwatts
Helper I
4 years ago

I had a type in my code so updated. Was just the line which had "Query=10"
Followed the gif and got this

 

Notepad copy of the error. 
I think its closer

where the end of the url reads rooms/summary?postid=11169 it should read
rooms/summary/11169

And i really appreciate you helping me to trouble shoot this. 

 

 

 

KNP's avatar
KNP
Super User
4 years ago

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.