Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Check example 2 for an alternative way to submit the request body.
That worked for me. I must have missed that page. Thank you
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
51 | |
19 | |
12 | |
11 |