Can not get FirstName and LastName columns for a custom lookup column using Query API

For default lookup columns such as Owner, when executing the following query in Query API I was able to get data

{

"select_query":"select Owner.first_name,Owner.last_name,Owner.id from Accounts where id is not null"

}

However I have created a custom lookup column and when executing the following query:

{

"select_query": "select Lookup_2.first_name, Lookup_2 .id, Lookup_2.last_name from Accounts WHERE id is not null limit 0,200"

}

I get the following error:

{"column_name":"Lookup_2.last_name"},"message":"column given seems to be invalid","status":"error"}

Are FirstName and LastName columns exposed in custom lookup fields or only on default ones?

Note: I have executed the query above using only FirstName and the same error is thrown, but when using only Id the query is executed successfully.

Tout forum

France ZUGs

Zoho SalesIQ Resources

Sticky Posts
Extension pointers - Simple yet significant pointers #13: On change of field value for CRM variables
CRM variables provide global access to a variable across an entire extension. They also help in the storage of user-specific data provided by the user at the time of installation, which can later be fetched to perform data functionalities. Additionally,
Extension pointers: Extend end-user benefits and allow personalization by implementing extensions with custom actions
From our earlier post on custom actions, we know that we can create templated actions, share them with end users, and allow them to reuse those actions to achieve personalized outcomes. In this post, we'll look at how custom actions make it easy for users
Extension pointers - Simple yet significant pointers #12: Functions for Zoho CRM extensions
Functions are essential in achieving logical functionality for an extension. You can easily code your functions in Deluge using drag-and-drop tools to meet your requirements. How to create functions for Zoho CRM extensions in Sigma Go to Sigma and select
Extension pointers - Simple yet significant pointers #11: Testing an extension in sandbox
After developing an extension using the Zoho developer platform, developers will want to test it before publishing it and making it available to end-users/customers. The Zoho developer platform includes a sandbox testing environment, which is a simulated
Extension pointers - Simple yet significant pointers #10: Publishing
Publishing an extension An extension can be created for an internal organizational purpose or to meet a common business need. In either case, an extension can only be made available to users after it has been published. Types of extension publishing Private: