Devart Forums

Posted: **Mon 08 Oct 2018 10:03**

Hi all,

I am using the Zoho CRM ODBC driver to connect to Power BI. Can someone point me to what SQL query do I need to use in order to get all related fields data? For instance, I would like to get the notes for a deal.

Thanks,
George

Posted: **Mon 08 Oct 2018 12:30**

You can get information about the tables relationships in our driver by requesting the internal table
SYS_REFERENTIAL_CONSTRAINTS :

Code: Select all

SELECT * FROM SYS_REFERENTIAL_CONSTRAINTS

Devart Forums

Zoho CRM Modules Related lists

Zoho CRM Modules Related lists

Re: Zoho CRM Modules Related lists