Retrieves the result data and column metadata for a previously saved query report identified by its ID. The report ID can be obtained from Retrieve All Query Reports. The saved SQL SELECT query is re-executed with the specified pagination parameters and the results are returned. The saved report's reportName is included in the response for identification.
get /dcapi/reports/queryReports/{id}/data
https://{serverurl}/dcapi/reports/queryReports/{id}/data
Authorization: Zoho-oauthtoken d92d4xxxxxxxxxxxxx15f52
The unique id retrieved for saved query report
Starting row index for pagination (1-based). Default is 1
Maximum number of rows to return per response. Value must be between 1 and 1000. Defaults to the saved report's limit when not provided
curl --request GET \
--url https://appdomains/dcapi/reports/queryReports/{id}/data \
--header 'Accept: application/queryResult.v1+json' \
--header 'Authorization: Zoho-oauthtoken d92d4xxxxxxxxxxxxx15f52'The report name echoed back from the request for identification
Array of row objects where each key is a column name and each value is the column value as a string
Example column value. Actual keys vary based on the SQL query provided in the request
Example column value. Actual keys vary based on the SQL query provided in the request
Example column value. Actual keys vary based on the SQL query provided in the request
Example column value. Actual keys vary based on the SQL query provided in the request
Example column value. Actual keys vary based on the SQL query provided in the request
Example column value. Actual keys vary based on the SQL query provided in the request
Array of column metadata objects describing the result set columns including name and JDBC data type
Name of the column in the result set as returned by the database
JDBC java.sql.Types constant for the column. Common values: -5 (BIGINT), 4 (INTEGER), 12 (VARCHAR), 93 (TIMESTAMP)
Error code for invalid query. INVALID_QUERY = the saved SQL query is syntactically invalid or fails construction during re-execution
Human-readable message describing why the saved query failed validation or construction
Error code for unauthorized access. REPORT_UNAUTHORIZED = the specified report ID was not found or the user does not have permission to access it
Human-readable message indicating the user is not authorized to access the specified query report
Error code for unauthorized MSP access. REPORT_UNAUTHORIZED = MSP non-admin user attempting to access query reports
Human-readable message indicating the user is not authorized as an MSP admin to access query reports
Error code for server-side failure. INTERNAL_ERROR = an unexpected error occurred during query execution or report lookup (e.g., SQLException)
Human-readable message describing the internal server error encountered while fetching query report data
Result of executing the saved query report's SQL query
{
"reportName": "sample",
"data": [
{
"user_id": "1",
"last_name": "null",
"description": "No Description",
"middle_name": "null",
"first_name": "admin",
"createdtime": "1774255689700"
},
{
"user_id": "2",
"last_name": "null",
"description": "No Description",
"middle_name": "null",
"first_name": "guest",
"createdtime": "1774255689700"
}
],
"columnDetails": [
{
"columnDataType": -5,
"columnName": "user_id"
},
{
"columnDataType": 12,
"columnName": "first_name"
},
{
"columnDataType": 12,
"columnName": "middle_name"
},
{
"columnDataType": 12,
"columnName": "last_name"
},
{
"columnDataType": -5,
"columnName": "createdtime"
},
{
"columnDataType": 12,
"columnName": "description"
}
]
}
Saved SQL query is syntactically invalid or fails construction during re-execution
{
"errorMessage": "Invalid query syntax or unsupported statement",
"errorCode": "INVALID_QUERY"
}
Report ID does not exist or user does not have permission to access it
{
"errorMessage": "You are not authorized to access this report",
"errorCode": "REPORT_UNAUTHORIZED"
}
MSP non-admin user attempting to access query reports
{
"errorMessage": "You are not authorized to access this resource",
"errorCode": "REPORT_UNAUTHORIZED"
}
Unexpected error during saved query execution or report lookup
{
"errorMessage": "An internal server error occurred while fetching query report data",
"errorCode": "INTERNAL_ERROR"
}
![]()
Duration: 1 minute | Threshold: 30 | Lock period: 5 minutes
Duration - Time window for the threshold.
Threshold - Number of API calls allowed within the specified duration.
Lock Period - Wait time before consecutive API requests.
© 2026, Zoho Corporation Pvt. Ltd. All Rights Reserved.