Forum Discussion
What details required to connect REST API to Power BI
Hi toovishant
click get data > blank query > advanced editor > copy and past the following code and fill it up with the url and api key > click edit credentials > pick Anonymous > connect and see if it works ?
let Source = Json.Document(Web.Contents("https://---------------------/GetAllBuildingsPublicBasic?PageNumber=1&PageSize=5000", [ Headers = [ #"accept" = "*/*", #"x-api-key" = "---------------" ] ] )) in Source
Hi toovishant
click get data > blank query > advanced editor > copy and past the following code and fill it up with the url and api key > click edit credentials > pick Anonymous > connect and see if it works ?
let
Source = Json.Document(Web.Contents("https://---------------------/GetAllBuildingsPublicBasic?PageNumber=1&PageSize=5000",
[
Headers = [
#"accept" = "*/*",
#"x-api-key" = "---------------"
]
]
))
in
Source
You Rock My Friend kushanNa - It worked like a magic.
I think there are other steps to get the data. Please can you proivde if possible.
No worries , click list > to table > ok > click expand column button and see if it expands the data ?
or try this code
let // Get the raw JSON Source = Json.Document(Web.Contents("https://---------------------/GetAllBuildingsPublicBasic?PageNumber=1&PageSize=5000", [ Headers = [ #"accept" = "*/*", #"x-api-key" = "---------------" ] ] )), // Navigate to the "value" key which contains the list ValueList = Source[Value], // Convert list to table ToTable = Table.FromList(ValueList, Splitter.SplitByNothing(), null, null, ExtraValues.Error), // Expand the records into columns Expanded = Table.ExpandRecordColumn(ToTable, "Column1", {"Name", "Value"}) in ExpandedIt worked Thank You kushanNa .
Hey kushanNa - What if I want to connect via the api key what details and steps required?
Should I go via the Connect data >Web>Web API
not sure what details need to enter in "Key", As mentioned earlier I have these details.
curl -X 'GET' \ 'https://---------------------/GetAllBuildingsPublicBasic?PageNumber=1&PageSize=5000' \ -H 'accept: */*' \ -H 'x-api-key: ---------------'
Thank You
To the best of my knowledge, the 'key' is typically used with a general header like 'Authorization', but in your case, you’re using a custom header like 'x-api-key'