Join in COQL request

Join in COQL request

Hello everyone,

I try to do COQL request with the "G-Connector - Zoho CRM" plugin for Google Sheets. My request worked during severals months, but doesn't work any more now.

This what I try to do:

1. SELECT Id, Account_Name.Account_Name, Deal_Name, Amount, Date_de_d_marrage, Description, Expected_Revenue, Modified_Time, Owner.email, Probability, Site_Icam, Stage, Type, Nombre_d_IP, Nombre_de_semaine, Domaine, Num_ro_d_affaire FROM Deals where Site_Icam = 'Lille' or Tag like 'Lille'
   

 I get this error from Zoho: "the module name given seems to be invalid". It's look to be an issue with the linked table "owner". The simplified request version below return the same error:

1. SELECT Id, Owner.email FROM Deals where Amount >= 0

What I have to do?

Thank you very much,

Simon