Skip to main content
WARNING You're browsing the documentation for an old version of Deskpro. Consider updating to Deskpro Horizon.

Access DeskPRO API using Excel or PowerBI

in Integration
Authors list
Published: 12 Nov 2019|Last updated: 12 Nov 2019

If you need to obtain and handle data outside of Deskpro, you can connect to our API either from Excel or PowerBI using the below details:

1- Open Excel, and the open Power Query Editor

2- Click in New Source > Other Sources > Web

image.png

3- Select the Advanced radio button and the enter:

  • URL Part: The endpoint you want to query, in this case was /api/v2/tickets/1
  • HTTP Header, select Autorization annd then enter the API key like the example: key 3:87548975634289756439 -Click ok

image.png

4- If you click on the data, it will show the records present in the endpoint

image.png

5- At the end select the fields you want to import into the table and the records are imported.

image.png

HelpfulUnhelpful

0 of 1 people found this page helpful

next pageUsing web hook actions

Please log in or register to submit a comment.