Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Need some help calling API with body

so i have an API link to get data, it requires simply a post command with the api link and some body information   the body info is as followed:   This works fine in Postman and I get the d...
Need Help
v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi Anonymous ,

 

Based on your description, I will use Datasets - Get Dataset In Group  API as an example:

let
//Get API Token
  tokenapiUrl = "https://login.microsoftonline.com/ecxxxxxxxx/oauth2/v2.0/token",
    body = [
          client_id="d32xxxxxx",
          grant_type="client_credentials",
          client_secret="vMfxxxxxx",
          scope="https://analysis.windows.net/powerbi/api/.default"
],

API_Response = Json.Document(Web.Contents(tokenapiUrl, [Headers = [Accept = "application/json"],
Content = Text.ToBinary(Uri.BuildQueryString(body))])),
token = API_Response[access_token],
//Get Data
apiUrl = "https://api.powerbi.com/v1.0/myorg/groups/476xxxxxxx/datasets/3a7xxxxxx",
data  = Json.Document(Web.Contents(apiUrl,[Headers=[#"Authorization"="Bearer "&token,#"Content-Type"="application/json"]]))
in
data

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Jianboli,

 

First of all thanks for the detailed answer, however i think I'm running into one problem, the following things are given in the body of the getData call (not in the headers):

 

- access_token=

- version= (9.5 for example)

- images= (0 for example)

 

I'm dealing with a POST request, not a get request, and these parameters will not work when given as a header, but only when given in the body.