Accessing the Results API using third-party tools
The Results API OData feeds are designed to return specific datum and granular subsets of data. When querying multiple data in a feed, querying multiple feeds simultaneously, or querying against the content in a variable that is not a key field for the feed, the Results API may timeout. Users are encouraged to design queries to use specific key values.
Although you can access all the result data in shared repository's Results Warehouse database through a web browser, you can also use third-party tools to generate reports using the Results API. These third-party tools, like Microsoft Excel, Power Pivot for Excel, and Tableau, can access and pull result data from the Results API and then create reports using that data. Different OData tools will interact with the Results API in different ways. This section explains how to connect to our Results API using the Power Pivot add-in for Excel, Excel, and Tableau. For information how to connect to the Results API and create reports with result data via other third-party tools, please refer to the documentation for the respective third-party tool.
This chapter contains the following sections:
- Accessing the Results API using Power Pivot
- Accessing the Results API using Excel
- Accessing the Results API using Tableau
It is also important to note that if you have a large Results Warehouse (i.e., a large amount of result data), attempts to retrieve a large number of results at once might return a 500 Internal Server Error message. If you receive this error, try limiting the amount of data you are trying to retrieve by using filters until you no longer receive this error. You can filter by assessment instead of all assessments, or filters assessments by smaller period of time.