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 'Cont...
Need Help
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.