Forum Discussion

LP2803's avatar
LP2803
Responsive Resident
5 years ago

How to fetch Data from API with dynamic access token

Hi Team,   Im new to API/REST API methods in PowerBI. So please help me with understand and how to achieve the below requirement   Im trying to fetch the WebEx meeting informaiton for my analysis...
Need Help
  • vr_2020's avatar
    vr_2020
    Frequent Visitor
    3 years ago

    shrutivyas06 - I was trying to use this code in Blank Query in Advance editor as per your blog and getting filed token not found. Looks like the API URL for token generation that I am trying to use in the following code seems to be wrong. Can you please help me with one sample API URL format that should be used in url = <<API Url for token generation>>

     

    let

    url = <<API Url for token generation>>,

    headers = [#"Content-Type" = "application/json"],

    postData = Json.FromValue([username="<<User Name>>",

    password= "<<Password>>"]),

    response = Web.Contents(

    url,

    [

    Headers = headers,

    Content = postData

    ]

    ),

    Data = Json.Document(response),

    access_token=Data[token]

    in

    access_token