Module "Calls", field "Call_Status" - "unsupported column" error
Dear Zoho developers!
I've got a really strange problem.
There are 2 Zoho CRM accounts: my developer's account and one of my client's account.
- {
- "system_mandatory": false,
- "webhook": false,
- "json_type": "string",
- "crypt": null,
- "field_label": "Call Status",
- "tooltip": null,
- "created_source": "default",
- "field_read_only": false,
- "display_label": "Call Status",
- "read_only": true,
- "association_details": null,
- "businesscard_supported": false,
- "multi_module_lookup": {},
- "currency": {},
- "id": "xxxx000090001",
- "custom_field": false,
- "lookup": {},
- "visible": true,
- "length": 120,
- "view_type": {
- "view": false,
- "edit": false,
- "quick_create": false,
- "create": false
- },
- "subform": null,
- "external": null,
- "api_name": "Call_Status",
- "unique": {},
- "history_tracking": false,
- "data_type": "picklist",
- "formula": {},
- "decimal_place": null,
- "mass_update": false,
- "blueprint_supported": false,
- "multiselectlookup": {},
- "pick_list_values": [],
- "auto_number": {}
- }
{
"select_query": "select Call_Status FROM Calls WHERE Owner is null OR Owner is not null LIMIT 200 OFFSET 0"
}
Returns:
- For my account:
- {
- "data": [
- {
- "id": "4197230000000241660",
- "Call_Status": "Overdue"
- }
- ],
- "info": {
- "count": 1,
- "more_records": false
- }
- }
- For client's account:
- {
"code": "INVALID_QUERY",
"details": {
"column_name": "Call_Status"
},
"message": "unsupported column",
"status": "error"
}
So, dear developers, why? And how to fix this?