Welcome Guest, you are in: Login

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

Xero Connector For QlikView & Qlik Sense

RSS
Modified on 2015/09/06 10:06 by chrisb Categorized as connector
We have started work on a Xero connector for QlikView and Qlik Sense. This is available in QVSource 1.5.9 and later.

IMPORTANT: This initial release only supports access tokens which last for 30 minutes. This means that you will need to authenticate with the connector and then load your desired data in to QlikView/Qlik Sense within 30 minutes otherwise you will have to first re-authenticate with the connector. We are hoping to improve on this situation soon.

Table of Contents [Hide/Show]


Usage

Currently the connector supports the following tables:
  • Organisation
  • Contacts
  • Accounts
  • CustomRequest

Note that the CustomRequest table should allow you to use the Xero API docs to construct any request to retrieve data via the API and return this data as XML which can then be parsed natively in QlikView or Qlik Sense.

Image

Custom Request

You can use the Xero API Docs to build a custom request - for example from the Contacts documentation we can see that a the contacts can be retrieved using:
https://api.xero.com/api.xro/2.0/Contacts

We can enter this in to the Connector and retrieve the results as XML - we can then copy the generated URL and use it in QlikView or Qlik Sense where the XML can be parsed natively.

Image

Change Log

0.8.1 - 06/09/15
  • Added note to all tables that authentication is only valid for 30 minutes.

0.8.0 - 17/02/15
  • Initial release.
  Name Size
- Xero - Custom Request.png 121.28 KB
- Xero Connector.png 141.50 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