ZOHO CRM API V2 Retrieve Contact Owner
Hello.
Very new to ZOHO API.
I am working on a proof of concept script to retrieve Accounts and Contacts from ZOHO CRM using Python. I have decided to use COQL and build up a SQL Style query to retrieve the info I need as I need to wrap it in a WHERE clauses. Thanks to various posts and samples I have found online I have been able to connect and run basic queries.
However, I am stumped on how to get the attributes of the Account/Contact Owner such as their name at the very least.
The COQL Query I have tried is something like the following which will give me the Owner ID in the response but how do I reference the Owner's Name?
SELECT Owner
,First_Name
,Last_Name
,Lead_Source
,Account_Name
FROM Contacts
WHERE Last_Name is not null
ORDER BY Last_Name
LIMIT 1
Thanks in advance