Zoho CRM Modules Related lists

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
george.p
Posts: 1
Joined: Mon 08 Oct 2018 09:51

Zoho CRM Modules Related lists

Post by george.p » 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

MaximG
Devart Team
Posts: 1164
Joined: Mon 06 Jul 2015 11:34

Re: Zoho CRM Modules Related lists

Post by MaximG » 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

Post Reply