|Can I use the API to create a custom report for my site?
One of the best ways to create custom reports for an organization is to leverage the Blue Triangle API with a report customization source such as Excel.
Firstly, one will need to setup an API request using the Blue Triangle API Overview guide and the relevant endpoint(s) for the request that are linked within that guide.
Secondly one will need to be able to parse that information from the JSON that is returned via the API call.
In Excel, there are a number of different methods to do this that have excellent guides online.
A few of the possible conversion methods involve leveraging custom-written VBA, Pre-packaged Excel tools such as VBA-JSON, and direct parsing of JSON content that has been placed into spreadsheet cells.
Once the data has been parsed and processed, at that point it is up to the user to massage the data into a useable format, for which Excel VBA code is very useful.
See also: How to use the API - Overview