Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

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

Hi Community Experts,

Help required.

Thanks

Employee
Employee

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

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

pinchofsalt
New Contributor III

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

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

Community Browser