How to Integrate Qlik with Xero

This tutorial shows how to connect Qlik Sense to Xero using the REST connector to load accounting and financial data for analysis.

Notes:

• Qlik Sense does not have a native Xero connector. The REST connector using the Xero API is the recommended approach.
• You need an Xero account, a registered app in the Xero Developer portal, and valid OAuth 2.0 credentials.
  

1. Log in and open your Qlik Sense app, and click Data load editor from the top menu.
2. Click Create new connection in the Data connection panel on the right.
3. Select REST from the connector list.
4. Enter an Xero API endpoint URL (for example, an invoices or accounts endpoint with your Xero tenant ID).
5. In the request headers, add an Authorization header with your OAuth 2.0 Bearer token and an Xero-tenant-id header with your organization ID, then click Test connection to verify the request.
6. Click Create to store the connection. You can now access the saved connection, browse the available tables, and select the ones you want to load into your app.