Discussion board where members can get started with Qlik Sense.
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
But Problem is that, it created the tables for every record entries.
Hi Community Experts,
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.
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