Account_Name.Account_Name - column given seems to be invalid
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.