Forum Discussion

a68tbird's avatar
a68tbird
Resolver II
8 years ago
Solved

Multiple API Calls as Source

Hello All,    I am extracting geographical and event information from a third-party API call into PowerBI. The challenge here is that I have over a hundred calls to make in order to get my full data...
Need Help
ericOnline's avatar
ericOnline
Post Patron
7 years ago

Hello v-chuncz-msft. If I could as a follow-on question here...

 

What about POST requests that use JSON rather than a URL parameter? How can I pass key : value pairs from a table rather than 1 by 1?

 

Here is my example API call (works great):

 

let
    url = "https://company.com/api/path",
    headers = [
        "apikey" = thisisnotreallymyapikey
        "accept" = application/json,
        "Content-Type" = application/json
    ],
    content = "{
        ""key"": {
            ""nestedKey"": value,
            ""nestedKey"": value
        },
        ""key"": """",
        ""key"": ""value"",
        ""key"": ""value"",
        ""key"": value,
        ""key"": [
            {""key"": ""value"", ""key"": ""value""}
        ]
    }",
    webdata = Web.Contents(url, [Headers=headers,Content = Text.ToBinary(content)]),
    response = Json.Document(webdata)
in
    response