Preskoči in pojdi v glavno vsebino
WARNING You're browsing the documentation for an old version of Deskpro. Consider updating to Deskpro Horizon.

Access DeskPRO API using Excel or PowerBI

v Integration
Seznam avtorjev
Objavljeno: 12. nov. 2019|Nazadnje Posodobljeno: 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

UporabnoNeuporabno

0 od skupaj 1 oseb je ocenilo to stran kot uporabno.

naslednja stranUsing web hook actions

Pred objavo komentarja se moraš prijaviti.