The following is the process required to pull a summary list of Event Delegate data into Excel.

First, open Excel, then go to the data tab. Here, you can select from web. Next, select advanced and enter the data shown below for Event Pupil List Summary.


The Xperios API.

https://api.paritor.com/api/bi/

The Query Name followed by question mark. For Example:

Get_EventPupilListSummaryAsync?

Parameters and Values. The parameters for the example query:

FromDate=01-Jan-2020&

ToDate=01-Jan-2021

IncludeEvaluating=true

Note the last parameter does not end with &.

Type Authorization in the HTTP request header.

Paste in your API key as the value. Click OK and the resultant Query Preview will be displayed.


Graphical user interface, text, application??Description automatically generated


You must now transform the data into Excel. The data is contained in the first line called "objectList". Click on the "Into Table" button to convert to a table.


Graphical user interface, application??Description automatically generated


Double click on the Cell containing the work "List", and then from the transform header at the top select convert to list.


Graphical user interface, application??Description automatically generated


Click on "To Table" button to display the table dialogue.


Graphical user interface, application, Excel??Description automatically generated


Click OK.


Graphical user interface, application??Description automatically generated

Click on the Expand Column to select and expand the required columns.


Graphical user interface, application, table??Description automatically generated


Select all columns you wish to view and then click ok.


Graphical user interface, application??Description automatically generated


Click on the Close and Load button to save to Excel Sheet.


Table, Excel??Description automatically generated