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

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

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

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