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
Zoho CRM Modules Related lists
Re: Zoho CRM Modules Related lists
You can get information about the tables relationships in our driver by requesting the internal table
SYS_REFERENTIAL_CONSTRAINTS :
SYS_REFERENTIAL_CONSTRAINTS :
Code: Select all
SELECT * FROM SYS_REFERENTIAL_CONSTRAINTS