Query Reports

Query Reports allow partners to add their own SQL queries - and get the results of this query via a request to the API. In the API payload certain customizations can be made to the query including modifying the select, order by and group by statements.

The user also specifies what output format they want in response. The endpoint can return a representation of the data in JSON, Microsoft Excel, CSV or PDF format.

There are Client Query Reports that are available for Client Users. These work the same as regular Query Reports but are limited to the clients' data.

Adding a new Query Report is highly technical and requires a sanity check on performance and data access permissions. Therefore, this is done via contact with Quiddly development team.