API Call POST Method - Power Query - Syntax Help

[niculcig]

Hello and good day everyone,

I've been trying for 3 days to connect to an API using Post Method. I been using different methods that I found on some forums but still I can't get the correct result.

This is what I got: 

-URL: https://e-api.gemius.com/api/markets

-Authentication Token : Bearer XXXXX
-JSON response from postman: 

[{"id":2,"iso":"be","name":"Belgium"}]

-Example request from the documentation:
curl -H 'Authorization: Bearer __TOKEN__' -H 'Content-Type: application/json' -X POST 'https://eapi.
gemius.com/api/markets'

I tried this with Power Query with no success :

let
AuthKey = "Bearer XXX",
url = "https://e-api.gemius.com/api/markets",
body = {id="2", iso="be", name="be"},
Source = Json.Document(Web.Contents(url,[
Headers = [#"Authorization"=AuthKey ,
#"Content-Type"="application/json"],
Content = Text.ToBinary(body)
]
))
in
Source

I don't have a lot of experience working with API's if someone can help me it would be wonderfull.

Thx!

[ImkeF]

Hi @niculcig ,

the Power BI /Power Query /M-syntax to create a record or a list is quite the opposite of how you do it in JSON.

So step
body = {id="2", iso="be", name="be"},

in your query is not valid.

To create this record in M, you have to use square brackets instead:

body = [id="2", iso="be", name="be"]