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.
Currently the connector supports the following tables:
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.
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:
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.
Change Log0.8.1 - 06/09/15
0.8.0 - 17/02/15
- Added note to all tables that authentication is only valid for 30 minutes.