Zoho CRM Modules Related lists

[george.p]

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

[MaximG]

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