Calling API (POST) from Power BI

[stribor45]

I am trying to call external API but this code is giving me "Token Literal Expected". I am trying to send JSON in the body of the HTTP request. Can someone suggest what I am missing here please? I have also tried to use only one quote but that didn't work either. 

let

SvcUrl = "https://APIURL",

ApiKey = "myAPIKEY",

Content = "
{
  ""name"": ""someName"",
  ""metrics"": [
      {
          ""metricId"": ""Calls"",
          ""aggregator"": ""count"",
          ""name"": ""calls_count""
      }
  ],
  ""groupBy"": [
      {
          ""attributeId"": ""CallRequestedTime"",
          ""timeDisplayType"": ""day:"",
          ""name"": ""callrequestedtime_day""
      }
  ],
  ""filters"": [
      {
          ""attributeId"": ""CallAgent""
      }
  ],
  ""timeZone"": ""EasternStandard Time""
}"
,
Response= Web.Contents(SvcUrl, 
[
Content=Text.ToBinary(Content),
Headers=[ApiKey=ApiKey, #"Content-Type" = "application/json"]
]
),

Json = Json.Document(Response)

in

[lbendlin]

Check example 2 for an alternative way to submit the request body. 

Web.Contents - PowerQuery M | Microsoft Learn

[stribor45]

That worked for me. I must have missed that page. Thank you