Forum Discussion
Rest API Authentication API-Key
If the API requires a POST call then you need to put the data in the body, not the header. Consult the API documentation, and then use Json.FromValue() to binary encode the payload.
Like so:
let URL = "http://xxx/tstat", headers = [#"Content-Type"="application/json"], data = Json.FromValue([tmode = 2,t_cool = Setpoint,hold = 0]), web = Web.Contents(URL, [ Content = data, Headers = headers, ManualStatusHandling = {404, 400}]), result = Json.Document(web), ...you are missing the quotes around the key
data = Json.FromValue([apiKey = "123ABC"]),
If the API requires a POST call then you need to put the data in the body, not the header. Consult the API documentation, and then use Json.FromValue() to binary encode the payload.
Like so:
let
URL = "http://xxx/tstat",
headers = [#"Content-Type"="application/json"],
data = Json.FromValue([tmode = 2,t_cool = Setpoint,hold = 0]),
web = Web.Contents(URL, [ Content = data, Headers = headers, ManualStatusHandling = {404, 400}]),
result = Json.Document(web),
...Hi Ibendlin,
do you mean that I have to put my apikey into the Json.FromValue function?
let
URL = "URL",
headers = [#"Content-Type"="application/json"],
data = Json.FromValue([apiKey = 123ABC]),
web = Web.Contents(URL,[ Content = data,Headers = headers, ManualStatusHandling = {404, 400}]),
result = Json.Document(web)
in
resultIt gives ma an error, my api key is mixture of letters and numbers.
my API documentation says:
HTTP Method
POST
Query
A json object contaaining only the "apiKey" field inside.
body: {
apiKey: "xxxxx"
}
you are missing the quotes around the key
data = Json.FromValue([apiKey = "123ABC"]),