Welcome Guest, you are in: Login

QVSource: The QlikView & Qlik Sense API Connector (Docs)

We do not currently have a dedicated Zendesk Connector for QlikView and Qlik Sense, however it is relatively straightforward to use our General XML/JSON API Web Connector to load data from the Zendesk API into QlikView.

Table of Contents [Hide/Show]


If we receive sufficient interest in accessing this API we will consider adding a dedicated more streamlined and user friendly Zendesk specific connector for QlikView and Qlik Sense.

Usage

NOTE: You will now find a more advanced example over on GitHub which illustrates paging through and downloading all tickets in ZenDesk and storing them to a QVD file.

Firstly, locate the API section of your Zendesk Control Panel:

Image

And ensure that either API password or token access is enabled and saved:

Image

In our example we will use the API token method.

Now open up the General XML/JSON API Web Connector for QlikView and enter:
https://[YOUR_ZENDESK_SUBDOMAIN].zendesk.com/api/v2/users/me.json

Into the URI input in the connector:

Image

Then for the username and password enter:
[YOUR_ZENDESK_EMAIL_LOGIN]/token
[YOUR_ZENDESK_API_TOKEN]

Image

You should now be able to test the JsonToXmlRaw table and ensure that you are getting back data for your account:

Image

We can now consult the Zendesk API Docs to discover how to build queries for the data required. For example, to extract all the tickets in Zendesk we can enter the following URI into QVSource:
https://[YOUR_ZENDESK_SUBDOMAIN].zendesk.com/api/v2/tickets.json

Note that the Zendesk API returns JSON so here we are using the QVSource JsonToXmlRaw to convert this data into XML which can then be read and parsed by QlikView by using the generated URL highlighted here:

Image

As the path for a 'Web File' in the QlikView script editor.

With a little more work, we could also use JsonToTable table to generate a structured table directly for QlikView (for example in QVX format), you can read more about this here.

Paging

The notes above offer a simple introduction but do not cover more advanced topics.

For example, from the API docs it is seen that a maximum of 100 records are returned per page. In this case additional next_page values are included in the response and it would be up to the QlikView script developer to extract these and ensure that all pages of data were extracted (if desired).

NOTE: You will now find a more advanced example over on GitHub which illustrates paging through and downloading all tickets in ZenDesk and storing them to a QVD file.
  Name Size
- api access.png 31.44 KB
- api section.png 6.00 KB
- basic auth.png 8.04 KB
- enter uri.png 20.05 KB
- generated load url.png 7.66 KB
- user response.png 33.11 KB


(QVSource works with Qlik Sense as well as QlikView - See this page for notes.)
QVSource - The QlikView & Qlik Sense API Connector | © Copyright 2011 - 2016 Industrial CodeBox Ltd