Hi Team,
I'm using COQL API to fetch Contact information from Zoho CRM. I'm facing the "column given seems to be invalid" issue for the column Account_Name.Account_Name for one of the merchants and for others is working fine without any issues. Here, I'm trying to understand the issue of how a standard field is an invalid column.
I tried to reproduce this issue in my test account, enterprise account, and in free account but no luck. I tried to make that Account_Name field of the Contact object "Read Only" & "Don't Show" under Field Permissions. I didn't find an option to delete the field "Account_Name.Account_Name".
Sample Request:
Body:
{
"select_query": "select id, Last_Name, Email, First_Name, Account_Name.Account_Name, Phone from Contacts where Email in 'abc@example.com' limit 0,200"
}
Response:
{
"code": "INVALID_QUERY",
"details": {
"column_name": "Account_Name.Account_Name"
},
"message": "column given seems to be invalid",
"status": "error"
}
Need help in understanding this issue & steps to resolve this error.