REST API that allows CRUD based operations on its objects.

[ImranAslamSSW]

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

[v-jingzhang]

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.