Post payload not recognised as Json

Anonymous — Wed, 01 Apr 2020 11:15:50 GMT

Hi I am trying to connect the Piwik API with Power BI. Unfortunately when I try to post the query payload the API returns an error because it is not recognised as a Json. The API only allows JSON. The Python code only works with payload:

headers = { "Content-Type" : "application/json", json} and response = requests.post(query_url, headers=headers, data = json.dumps(data)).

Below my code snippet in Power Query. Suggestions are very welcome!

let

authKey = "{""grant_type"":""client_credentials"",

""client_id"":""***"",

""client_secret"":""***""}",

url = "https://tenant.piwik.pro",

// Uses the authentication/token method to obtain a token

GetJson = Json.Document(Web.Contents(url,

[Headers= [#"Content-Type"="application/json"],

Content=Text.ToBinary(authKey), RelativePath="/auth/token"])),

AccessToken = GetJson[access_token],

-- It works untill here

body = "{""columns"": [{ ""column_id"": ""website_name""}, { ""column_id"": ""session_entry_url""}],

{ ""format"": ""json""},

{ ""date_from"": ""2020-01-01""},

{ ""date_to"": ""2020-03-01""},

{ ""website_id"": ""a33fcc21-7349-4013-981c-468e1231696e""} ,

{ ""offset"": ""0""},

{ ""limit"": ""100""}

}",

data= Json.Document( Web.Contents(url,

[Headers = [#"Authorization"="Bearer "&AccessToken, #"Content-Type"="application/json", #"Accept-Encoding"= "gzip"],

RelativePath="/api/analytics/v1/sessions",Content = Json.FromValue(body)]))

data

topic Post payload not recognised as Json in Developer

Post payload not recognised as Json