I have been trying to retrieve reports based on default report templates through REST API calls. But the fields returned for each report instance is not same as what it is supposed to according to a report instance's description.
Here is an example query in the API explorer,
Query to retrieve Constituent Summary report:
Here is the result of the query:
The default description of the Constituent Summary report is:
Provides a list of address and telephone information for constituent records in your system.
But as you see the result of the query, all the returned rows have only name, and there is no other option in the API explorer to specify fields to be returned.
Things I did to analyse/rectify my query's result it further:
- Made sure that the report instance created in the UI has more than one column selected (that is, not only name but other fields like address, email etc.)
- Deleted the default report instance and created by own in the UI based on the default report templates. But still, the API query returns only these specific fields (in image.)
The above behavior is true for all query against report: It returns only specific fields/columns irrespective of the column selected in the UI.
Please let me know how can I retrieve a report with all columns (as specified for a particular report in Reports tab)