Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Help with API, URL , Power Bi

Hi guys,

I set up a token code to get data from a privet API in POWER BI.

 

How the code work is from the main URL I get access to toking and under the main URL, I can specify the sub-toke URL with a unit ID number.

 

The problem is I can use this method to get access to one sub-token instead two or more. The main reason is when I run the code the main URL can be used for one sub-token. I tried to duplicate the code and plagued the different client IDs and client secrets with the main URL but as I said the main URL worked just for one.

 

Is there anyone who can help me with this problem?

 

let

url = "main URL",
headers = [#"Content-Type" = "application/json"],
postData = Json.FromValue([username="<user_name>",
password= "<password>"]),
response = Web.Contents(
url,
[
ApiKeyName="api_key",
Headers = headers,
Content = postData

 

url2 = "sub_url_12344",

headers2 = [#"Content-Type" = "application/json",#"Authorization"="Bearer " & Value1],

//postData = Text.ToBinary("grant_type=client_credentials&client_id=vvvvvv&client_secret=12345"),

 


]
),
jsonResponse = Json.Document(response)
in
JSON response

 

No Replies