Download Report Data
This endpoint will allow you to download the results of running a report on CommCare. To identify the reports available, use the List Reports API.
Authentication: For more information, please review CommCare's API Authentication Documentation.
Base URL: https://www.commcarehq.org/a/[PROJECT]/api/v0.5/configurablereportdata/REPORTID/
The report data can be filtered (based on the report's filter) and is also paged.
|offset||The record number to start at. Default is 0.||offset=100|
|limit||The maximum number of records to return. Maximum: 50||limit=50|
Each report can be filtered by filters defined on the List Reports API. Each filter is optional and can provide values for multiple filters.
For date filters, you are required to provide "start" and "end" ranges (ex. form_date-start and form_date-end)
To filter on multiple values for a given filter use the %1F separator between the values.
For numeric types, its possible to filter on greater than / less than (i.e. age > 10). To do this, you need to provide an operator and an operand. For example, to filter on age, you can use age-operator=>&age-operand=10. Valid operators are >= <= = != < >.
If the column type is "expanded", there may be multiple results for a given column - these named column_id-0, column_id-1, etc. Each result represents a unique value of that column. The headers section includes details on the value of each column.