Forum Discussion

ImranAslamSSW's avatar
ImranAslamSSW
Frequent Visitor
3 years ago

REST API that allows CRUD based operations on its objects.

Hi, 

I have one api and I need to access the data in power bi. From where I can start.

Details as per below

 

To fetch a task with ID 123, you would perform the following
curl -g -X GET -H 'Content-Type: application/json' -H 'Authorization: bearer YourTokenHere' 'https://app.celoxis.com/psa/api/v2/tasks/123'
 
Thanks
Need Help

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    3 years ago

    Hi ImranAslamSSW 

     

    This is a GET request to an API. You can create a blank query in Power Query Editor, open its Advanced Editor then paste below code into it to replace anything there. Save the code and check whether it can return you the correct result. 

    let
  url = "https://app.celoxis.com/psa/api/v2/tasks/123",
  headers = [#"Content-Type" = "application/json", #"Authorization" = "bearer YourTokenHere"],
  response = Web.Contents(url, [Headers = headers]),
  jsonResponse = Json.Document(response)
in
  jsonResponse

    For the first time, you need to click "Edit Credentials" and select "Anonymous" type. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.