Required access: Analytics and API token
Difficulty: Developer only!
Borealis table widgets are the best way to organize your data to prepare it for integration with another system in your organization. For example, you may want to:
- Get the list of grievances for this month with their risk level
- Get the list of new stakeholders with their email addresses
- Provide statistics of data usage for global reporting purposes
How to grab the data from a table widget
- Make sure you have a valid API token. This should be provided by your superuser.
- Find the widget for which you want to grab the data. You can do this via the web interface or the API documentation (https://COMPANY.boreal-is.com/api-docs/YOUR_INSTANCE/).
- Note: If you are not using a corporate pack, COMPANY and YOUR_INSTANCE should be the same thing.
- If you found it using the Web interface, the URL for the widget will contain the widget ID. For example, the URL : https://COMPANY.boreal-is.com/YOUR_INSTANCE/analytics/widgets/table#254 is for widget ID 254
- Once you have the ID, you can do your first test. Here is a sample curl command to grab the data.
curl -X GET "https://COMPANY.boreal-is.com/api/v2/YOUR_INSTANCE/analytics/widgets/254?offset=0&limit=10" -H "accept: application/json" -H "api_key: MY_TOKEN"
I have lots of data, what do I do?
If your widget contains lots of data, you may need to perform multiple calls to get all your data. Notice in the previous call the following parameters:
This means that the call will give back a maximum of 10 results, starting with the first one. If you know the widget will give more results eventually, you have two options.
- Make the limit parameter bigger (the highest accepted value is 1000)
- If you have more data than that, you will need to perform multiple calls
- offset=0&limit=1000 --Get the first 1000 results
- offset=1000&limit=1000 --Get results 1001 to 2000
- And so on until the number of results returned is smaller than the limit you set.