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

Zendesk Connector?

Hi guys,

I'm very new to QlikView and the QlikCommunity. Do you know the most efficient way to load all your Zendesk data into QlikView?

I came across this QVSource wiki - http://wiki.qvsource.com/Zendesk-Connector-For-QlikView.ashx

However, I would love to see a working example if any of you have done the same and are willing to share your ideas and learnings.

Thanks much for sharing your knowledge,

Vaibhav

1 Solution

Accepted Solutions
chrisbrain
Partner - Specialist II
Partner - Specialist II

Further to my last post, I have just uploaded a much more advanced ZendDesk example:

https://github.com/QVSource/QVSource-ZenDesk-Example-For-QlikView

Which shows one way of constructing the QlikView script to loop through all pages of tickets in ZenDesk and load them into QlikView (and store them into a QVD file).

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense

View solution in original post

6 Replies
delmak2000
Creator
Creator

Hi People,

Please we do need answers to this post. I know there are QVsource developers in this forum, who have promoted QVsource as a means to connecting to Google Analytics and others like Zendesk.

I know some names(wouldn't want to mention) and do expect they provide similar apps like what they did for Google Analytics.

Please, also I would like to through the attention  of the Qlikview support and those behind this Qlikcommunity to help us find answers. I am desperate!

Thanks,

Ayodele

QlikTech Admin

Community Administrator

rbecher
MVP
MVP

Hi,

have you tried the solution QVSource has proposed? If you do not want to use a ready to run 3rd party solution you can roll your own, or ask an experienced company to build one meeting your requirements.

However, this is not related to QlikView support since webservice connect is not a QlikView feature.

- Ralf

Astrato.io Head of R&D
Not applicable
Author

Thanks Ayodele,

I tried using the free QVSource web connector and it lets me import only 100 Zendesk tickets. I think I have to figure out coding with REST API.

chrisbrain
Partner - Specialist II
Partner - Specialist II

The QVSource Connector does not limit you to only importing 100 items, it's just that our example page here

Zendesk Connector For QlikView - QVSource - The QlikView API Connector (Docs)

Only illustrates how to get the first 100 - we have a specific note at the footer of this page:

http://wiki.qvsource.com/Zendesk-Connector-For-QlikView.ashx#Paging_0

Saying that further work would be needed to page through all the results. In the background this is using the REST API anyway so you would still have to solve the paging issue.

We will try to expand our sample code to illustrate paging, something we have already done for our sample to connect to Desk:

QVSource/QVSource-Desk.com-Example-For-QlikView · GitHub

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
chrisbrain
Partner - Specialist II
Partner - Specialist II

Further to my last post, I have just uploaded a much more advanced ZendDesk example:

https://github.com/QVSource/QVSource-ZenDesk-Example-For-QlikView

Which shows one way of constructing the QlikView script to loop through all pages of tickets in ZenDesk and load them into QlikView (and store them into a QVD file).

beeido.com - BI | Software | Qlik Integration Services
GitFirst - A CI/CD solution for Qlik Sense
Not applicable
Author

Hello,

You may try to use this connector: QlikView API Connector for Zendesk

It read following tables from Zendesk:

Tickets, Users, Photos, PhotoThumbnails, Organizations, Locales, Groups, Categories, CustomRoles, Forums, Macros, Requests, SatisfactionRatings, SharingAgreements, Tags, Topics, Triggers, Views, HelpCenter_Categories, HelpCenter_Sections, HelpCenter_Articles.

Best regards,

Roman.