Forum Discussion

eyelikedata2's avatar
eyelikedata2
Helper I
3 years ago
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...
Interesting Links
Need Help
Tips and Tricks
  • lbendlin's avatar
    lbendlin
    3 years ago
    I thought I was to use Example 2

    That'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}}}")

     

eyelikedata2's avatar
eyelikedata2
Helper I
3 years ago

Could I do something like this?

 

Here is the new code:

let
body= [GrantType="**",Username="**",Password="***",ClientId="***",ClientSecret=""],
Source = Json.Document(Web.Contents("https://****/token",
    [ 
     Headers=[#"Content-Type"="application/json"],
     Content= Json.FromValue(body)
    ]))
in
    #"Source"