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.
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Desk Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho WorkDrive Resources
Zoho Campaigns Resources
Zoho CRM Resources
Zoho Show Resources
Writer Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.