Xero 

Xero is an online accounting software for small businesses, automating invoicing, bank reconciliations, and reporting.

Xero integration replicates data using the Xero Accounting API.

Feature snapshot

A high-level look at this connector, including useful links, and supported features.

Feature/Capability	Support details
Supported Qlik Talend Data Integration projects	Replication projects only. Data pipeline projects are not supported.
Target update methods	Replication tasks: Apply changes Store changes Landing data in a data lake tasks: Change data capture (CDC)
Managing metadata	Manual metadata generation is not required.
Schema evolution	Only the Change column data type operation is supported.
Replication of LOB columns (NCLOB, CLOB, and BLOB)	Not supported.
Scheduled CDC	Required. This is how the target is kept up-to-date with changes to the source. For replication tasks, see Scheduling CDC for replication tasks For lake landing tasks, see Scheduling CDC for lake landing tasks
Notifications	Partially supported Setting notifications for changes in operation
Monitoring	CDC-only, as full load is not relevant for this connector. Monitoring an individual data task
Automatic denesting of JSON column payloads	Not supported. JSON column payloads in source datasets are not denested automatically on the target.

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

To connect to the Xero integration, you need to have your client ID, client secret, user ID, and tenant ID. Follow the procedures below to copy each setting.

To obtain your client ID and secret:

1. Log into your Xero account.
2. Create a new app.
3. Click Configuration on the left. The client ID and secret are displayed.
4. As the client secret is displayed only once, copy and paste it to a secured file. Otherwise, you have to create a new app.
5. Make sure Authorized Redirect URIs is set to https://connector.qlik.com/auth/oauth/v3.htm.

To obtain your user ID:

1. Log into your Xero account.
2. Select the organization in the drop-down list in the top-left corner.
3. Select User from the menu.
4. Select the user account you want to use.

   The user ID is part of the URL https://go.xero.com/app/.../settings/users/edit?userId=%7BTHIS_IS_THE_USER_ID%7D).

To obtain your tenant ID:

1. Log into your Xero account.
2. To display the tenant ID, select Show auto-generated headers.

Creating the connection

For more information, see Connecting to SaaS applications.

1. Click Authenticate when you have filled in the required connection settings.

   You may be asked to log in to the source application.

   A window is displayed with an authentication code.

2. Copy the code to the clipboard and return to the connection dialog.

3. Paste the code in Complete authentication with the code provided by the source and click Verify.

   Tip noteYou may need to scroll down to see this field.

   When status is Verified, the authentication is verified.

4. Provide a name for the connection in Connection name.

5. Select Open connection metadata to define metadata for the connection when it has been created.