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)]))
in
data
