How to Connect & Fetch Data from QlikView with ZOHO-CRM

[#1]

Hi All,

I need to know how do i connect and fetch data from ZOHO CRM. Any help highly appreciated.

Process what i performed:

Fetch the data from Zoho CRM by using this URL

https://crm.zoho.com/crm/private/xml/Leads/getRecords?newFormat=1&authtoken=0375827c3ae07fbc78e26f3b...

But Problem is that, it created the tables for every record entries.

Thanks,

Arsal

[#2]

Hi Community Experts,

Help required.

Thanks

[hic]

To convert this xml structure to a tabular model understood by QlikView, you need to understand (or reverse engineer) the Zoho internal structure. I don't have that knowledge.

HIC

[Anonymous]

To transform the data that is returned from Zoho by the API you need to use a Generic Load.  There is an explanation of that here: The Generic Load

I've adapted this code for Zoho - have a look at the last part of my post here: ZOHO API with Qlik REST Connector and table transpose