How to get record owner name using Zoho CRM COQL ?

How to get record owner name using Zoho CRM COQL ?

I am trying to use search API and I can see the name is nested inside Owner object in JSON response like this



but now, I want to use COQL and I want to get record Owner id, Owner email and Owner name

  1. {
  2. "select_query" : "SELECT Owner.id, Owner.email FROM Deals WHERE Created_Time >= '2023-08-02T17:00:00+07:00' AND Created_Time < '2023-08-03T17:00:00+07:00' ORDER BY Created_Time LIMIT 2000"
  3. }

as you can see, If I only want to get Owner.id and Owner.email I can run that query above successfully, but when I add Owner.name in SELECT statement, then I will have this error (invalid request) like the image below


so how to get record owner name using COQL?