Hello,
I'm very new to working with Power Query when it comes to integrating with APIs. We have a platform that we use for which we're trying to get data from their API.
I've looked at some other posts on the community and the only that I've found that seems similar to my situation is the one below, however I have tried both the solutions on there and they result in the same issue.
https://community.powerbi.com/t5/Power-Query/Getting-data-from-API-with-JSON-body/m-p/1030682
I've put together a query using the same format as suggested on that post however I received the 'Web.Contents failed to get contents from 'URL' (400)' error. The query I've written is below:
let
url = "URL",
body = "{""since"": ""2021-01-01"",
""until"": ""2021-05-10"",
""channels"": [""200620789980139""],
""metrics"": [""page_impressions"",""page_engagement""],
""aggregation"": {
""unit"": ""day"",
""times"": 1,
""aligned"": false,
""firstdayofweek"": 1,
""function"": ""default""
}
}",
Source = Json.Document(Web.Contents(url,[
Headers = [#"Content-Type"="application/json"],
Content = Text.ToBinary(body)
]))
in
Source
The URL has to include the api key for authorisation and is included in this. I've also tried the same body content and URL on a website called reqbin and this brought up results when the call was made.
If you could please assist with how I can amend this query to get the data it would be a massive help. As I say, this is my first time working with APIs as a whole and the first time doing so in Power Query as well so much appreciated.
