Using Data API In Excel
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.
The Query Name followed by question mark. For Example:
Parameters and Values. The parameters for the example query:
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.
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.
Double click on the Cell containing the work "List", and then from the transform header at the top select convert to list.
Click on "To Table" button to display the table dialogue.
Click on the Expand Column to select and expand the required columns.
Select all columns you wish to view and then click ok.
Click on the Close and Load button to save to Excel Sheet.