Retrieves the full details of an existing formula column by its ID. Returns the column name, default value, and all condition definitions including their criteria and criteria patterns.
https://{server-hostname}:8383/dcapi/reports/customReports/formulaColumn/{columnID}
CustomReport.READCopied!
Authorization: d92d4xxxxxxxxxxxxx15f52
The columnID retrieved for saved formula column
curl --request GET \
--url https://appdomain/dcapi/reports/customReports/formulaColumn/{columnID} \
--header 'Accept: application/formulaColumnDetails.v1+json' \
--header 'Authorization: d92d4xxxxxxxxxxxxx15f52'Display name of the formula column
Default value returned when no condition matches (the ELSE branch)
Array of condition objects. Each defines a CASE-WHEN branch with criteria and result value
Result value when this condition's criteria matches
Array of criteria filter objects for this condition
Column ID the criteria is evaluated against. Fetch from Get Available Columns
Comparison operator used (e.g., contains, equal, greater than)
Array of string values to compare against
Logical operator (AND or OR) for combining with previous criteria
Logical expression combining criteria (e.g., 1, 1 AND 2, (1 OR 2) AND 3)
Unauthorized error code: 401. User does not own this formula column
Message indicating user is not authorized to access this formula column
Forbidden error code returned when the authenticated user does not have the required uem-roles (e.g., DataEncryption_Admin or DataEncryptionRecoveryKey_Admin)
Message indicating insufficient privileges to access this resource
Expectation failed error code: Custom Report V2 is not enabled
Message indicating Custom Report V2 feature is not active
Rate limit error code returned when the API call threshold (configured via threshold/duration in security XML) is exceeded; client is locked out for lock-period minutes
Rate limit exceeded message with retry guidance
Internal error code: unexpected failure during formula column retrieval
Detailed error description for the internal server error
Formula column with multiple CASE-WHEN conditions
{
"defaultValue": "Other",
"columnDetails": [
{
"criteria": [
{
"comparator": "contains",
"logicalOperator": "AND",
"columnID": 103,
"searchValue": [
"Windows"
]
}
],
"value": "Windows",
"criteriaPattern": "1"
},
{
"criteria": [
{
"comparator": "contains",
"logicalOperator": "AND",
"columnID": 103,
"searchValue": [
"Linux"
]
},
{
"comparator": "contains",
"logicalOperator": "OR",
"columnID": 103,
"searchValue": [
"Ubuntu"
]
}
],
"value": "Linux",
"criteriaPattern": "1 OR 2"
}
],
"columnName": "OSCategory"
}
Formula column with a single condition
{
"defaultValue": "Low",
"columnDetails": [
{
"criteria": [
{
"comparator": "greater than",
"logicalOperator": "AND",
"columnID": 205,
"searchValue": [
"90"
]
}
],
"value": "High",
"criteriaPattern": "1"
}
],
"columnName": "PriorityLevel"
}
User does not own this formula column
{
"errorMessage": "You are not authorized to access this formula column",
"errorCode": "401"
}
User does not have the required role
{
"errorMessage": "User does not have the required role to access this resource",
"errorCode": "403"
}
Custom Report V2 is not enabled
{
"errorMessage": "Custom Report V2 is not enabled",
"errorCode": "417"
}
Rate limit exceeded
{
"errorMessage": "Rate limit exceeded. Please retry after some time",
"errorCode": "429"
}
Unexpected failure during formula column retrieval
{
"errorMessage": "Internal server error while retrieving formula column details",
"errorCode": "500"
}
![]()
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.
© 2026, Zoho Corporation Pvt. Ltd. All Rights Reserved.