Forum Discussion
Solved
Can connect to API from PBI Desktop but cannot complete CURL example for data binary element - Help!
Hello, I have an API that I am able to connect to and are authorized, but I cannot seem to get the data binary part of the cURL example working. How do I enter something like this in PBI as my un...
I thought I was to use Example 2That's my mistake, apologies. Indeed I wanted you to look primarily at example 1 which shows both RelativePath and Query. But your sample curl script indicates that all filter parameters are in the POST body, so the Query part is not relevant (the RelativePath part is).
You can convert the curl -d value into a Power Query Content value like this
CURL:
{"filter":{"query":"-status:closed -category:job","period":{"by":"day","fromValue":7}}}Power Query:
Text.ToBinary("{""filter"":{""query"":""-status:closed -category:job"",""period"":{""by"":""day"",""fromValue"":7}}}")
lbendlinI keep getting an invalid identifier on "filter" = [ in all the examples. I'm going to try something like this next but welcome your feedback or anyone else in the community.
let
base_url = "https://hostname:443",
api_key = "<Your API Key>",
url = base_url & "/incidents/search",
headers = [
#"Content-Type" = "application/json",
#"Accept" = "application/json",
#"Authorization" = api_key
],
filterJson = [
"filter" = [
"query" = "-status:closed -category:job",
"period" = [
"by" = "day",
"fromValue" = 7
]
]
],
bodyText = Text.FromBinary(Json.FromValue(filterJson)),
// Create a custom request
request = Http.Request(url, [
Content = Text.ToBinary(bodyText), // Convert payload to binary
Headers = headers,
ManualStatusHandling = {404} // Handle 404 errors if needed
]),
// Make the API request using Web.Contents
response = Web.Contents(request),
// Handle response
jsonResponse = Json.Document(response)
in
jsonResponse
Please read the documentation again and use the RelativePath feature.
Do you also have documentation that is not Python library specific?