Account_Name.Account_Name - column given seems to be invalid

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.


      • Sticky Posts

      • Free Webinar - Digital signatures for digital contract management with Zoho CRM

        Hi, Did you know you can seamlessly send and collect signatures on important business documents like business proposals, vendor agreements, sales contracts, invoices, and other inventory documents with Zoho Sign’s extension for Zoho CRM? Join our upcoming

      • New User Interface for your Email integration in Zoho CRM

        Hello folks,  As most of you may already know, Zoho Mail recently got a new user interface that's a lot better and easier to use. As a result, this change will affect your email integration with your Zoho CRM account**.  If you have your email integration in Zoho CRM set up through POP, your Emails UI in CRM will be moved to the new Zoho Mail UI. We hope that you like the new and improved Emails interface inside Zoho CRM. Feel free to share your feedback by commenting below.  **Please note that,

      • Fetching leads from Zoho CRM into Zoho Creator, automatically

        I'd like to pull new leads from the CRM system, into Creator, on a daily basis. Is this possible?   Yes, it is possible. Zoho Creator and Zoho CRM are integrated with each other, enabling you to synchronize data between them. This is done by fetching records from CRM into a Zoho Creator form. In order to achieve this, you'll have to configure a workflow alert in Zoho CRM.  For instance, you can maintain the lead details in CRM on a separate form in Zoho Creator by fetching the details automatically