What details required to connect REST API to Power BI

[toovishant]

Hi All,

Here are the Rest API details I have and unable to connect, not sure I follow the rest steps to connect. Please help.

curl -X 'GET' \  'https://---------------------/GetAllBuildingsPublicBasic?PageNumber=1&PageSize=5000' \  -H 'accept: */*' \  -H 'x-api-key: ---------------' 

 Any help apperciated.

Thank You

Vishant

[kushanNa · Accepted solution]

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

[toovishant]

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.

[kushanNa]

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
    Expanded

[toovishant]

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

[kushanNa]

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'

[toovishant]

It worked Thank You @kushanNa .

[toovishant]

I get the follow error when i try to use WEB and API key, I am using the right details to autheticate and connect API?

[Gabry]

Hey, what's your issue? M code should look like this:

let
    url = "https://---------------------/GetAllBuildingsPublicBasic?PageNumber=1&PageSize=5000",
    apiKey = "---------------",
    response = Web.Contents(url,
        [
            Headers = [
                #"accept" = "*/*",
                #"x-api-key" = apiKey
            ]
        ]
    ),
    json = Json.Document(response)
in
    json

It should work