Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
Valued Contributor

Re: Zendesk Connector?

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).

6 Replies
delmak2000
Contributor

Re: Zendesk Connector?

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

MVP
MVP

Re: Zendesk Connector?

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

Not applicable

Re: Zendesk Connector?

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
Valued Contributor

Re: Zendesk Connector?

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

chrisbrain
Valued Contributor

Re: Zendesk Connector?

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).

Not applicable

Re: Zendesk Connector?

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.

Community Browser