Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

3 Replies
Not applicable
Author

Hi Community Experts,

Help required.

Thanks

hic
Former Employee
Former Employee

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
Not applicable
Author

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