Xero

Xero ETL connector for data replication

Snapshot

Features	Details
Release Status	Released
Source API Version	v2
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	Xero email Xero password
Replication Type	Full Replication Key based Replication
Replication Key	NA DATE
Suggested Replication Frequency	24 hrs

Integrate Xero with Daton

1. Signin to Daton

2. Select xero from Integrations page

3. Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide your xero account email and Password.

5. After providing the email and password it prompts for the company, select the company to authorize Daton to periodically extract data from xero.

6. Post successful authentication you will be prompted to choose from the list of available tables

7. Then select all required fields for each table

8. Submit the integration.

Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Tables/Apis supported
BankTransactions	Accounts
BankTransfers	Invoices
BatchPayments	Contacts
ContactGroups	CreditNotes
Currencies	Employees
GetProjects

Xero Data

Accounts

Purpose: Returns all the results of Accounts.

Source Api documentation https://developer.xero.com/documentation/api/accounts

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
AccountId	STRING
Name	STRING
Code	STRING
Type	STRING
Taxtype	STRING
EnablePaymentsTOAccount	BOOLEAN
BankAccountNumber	STRING
BankAccountType	STRING
CurrencyCode	STRING

BankTransfers

Purpose: Returns a list of all the bank transfers.

Source Api documentation https://developer.xero.com/documentation/api/bank-transfers

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
BankTransferID	STRING
CreatedDateUTCString	STRING
CreatedDateUTC	STRING
DateString	STRING
Date	STRING
FromBankAccount	RECORD
AccountID	STRING
Name	STRING
ToBankAccount	RECORD
AccountID	STRING
Name	STRING
Amount	STRING
FromBankTransactionID	STRING
ToBankTransactionID	STRING

BankTransactions

Purpose:Returns the results of all the bank transactions.

Source Api documentation https://developer.xero.com/documentation/api/banktransactions

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
Contact	RECORD
ContactID	STRING
Name	STRING
DateString	STRING
DATE	STRING
Status	STRING
LineAmountTypes	STRING
LineItems	RECORD
Description	STRING
UnitAmount	STRING
TaxType	STRING
TaxAmount	STRING
LineAmount	STRING
AccountCode	STRING
Quantity	STRING
LineItemID	STRING
SubTotal	STRING
TotalTax	STRING
Total	STRING
UpdatedDateUTC	STRING
CurrencyCode	STRING
BankTransactionID	STRING
BankAccount	RECORD
AccountID	STRING
Code	STRING
Name	STRING
Type	STRING
Reference	STRING
IsReconciled	STRING

BatchPayments

Purpose:Returns a result of all the batch payments.

Source Api documentation https://developer.xero.com/documentation/api/batch-payments

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
Account	RECORD
AccountID	STRING
Reference	STRING
BatchPaymentID	STRING
DateString	STRING
Date	STRING
Payments	RECORD
Invoice	RECORD
InvoiceID	STRING
Payments	STRING
CreditNotes	STRING
Prepayments	STRING
Overpayments	STRING
HasErrors	BOOLEAN
IsDiscounted	BOOLEAN
LineItems	STRING
PaymentID	STRING
Reference	STRING
Amount	NUMERIC
Type	STRING
Status	STRING
TotalAmount	NUMERIC
UpdatedDateUTC	STRING
IsReconciled	BOOLEAN

Contacts

Purpose:Returns a result of all the contacts.

Source Api documentation https://developer.xero.com/documentation/api/contacts

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
ContactID	STRING
ContactStatus	STRING
Name	STRING
FirstName	STRING
LastName	STRING
EmailAddress	STRING
SkypeUserName	STRING
BankAccountDetails	STRING
TaxNumber	STRING
AccountsReceivableTaxType	STRING
AccountsPayableTaxType	STRING
Addresses	RECORD
AddressType	STRING
AddressLine	STRING
City	STRING
PostalCode	STRING
AttentionTo	STRING
Phones	RECORD
PhoneType	STRING
PhoneNumber	STRING
PhoneAreaCode	STRING
PhoneCountryCode	STRING
UpdatedDateUTC	STRING
IsSupplier	BOOLEAN
IsCustomer	BOOLEAN
DefaultCurrency	STRING

ContactGroups

Purpose: Returns a list of all the Contact groups.

Source Api documentation https://developer.xero.com/documentation/api/contactgroups

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
ContactGroupID	STRING
NAME	STRING
Status	STRING

Employees

Purpose: Returns a list of all the employees.

Source Api documentation https://developer.xero.com/documentation/api/employees

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
EmployeeID	STRING
Status	STRING
FirstName	STRING
LastName	STRING
ExternalLink	RECORD
Url	STRING
Description	STRING
UpdatedDateUTC	STRING

Invoices

purpose:Returns a list of all the Invoices.

Source Api documentation: https://developer.xero.com/documentation/api/invoices

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
Type	STRING
Contact	RECORD
ContactID	STRING
ContactStatus	STRING
Name	STRING
Addresses	RECORD
AddressType	STRING
Phones	REOCRD
PhoneType	STRING
UpdatedDateUTC	STRING
IsSupplier	STRING
IsCustomer	STRING
Date	STRING
DueDate	STRING
DateString	STRING
DueDateString	STRING
Status	STRING
LineAmountTypes	STRING
LineItems	RECORD
Description	STRING
Quantity	STRING
UnitAmount	STRING
TaxType	STRING
TaxAmount	STRING
LineAmount	STRING
AccountCode	STRING
Tracking	RECORD
TrackingCategoryID	STRING
Name	STRING
Option	STRING
LineItemID	STRING
SubTotal	STRING
TotalTax	STRING
Total	STRING
UpdatedDateUT	STRING
CurrencyCode	STRING
InvoiceID	STRING
InvoiceNumber	STRING
Payments	RECORD
Date	STRING
Amount	STRING
PaymentID	STRING
AmountDue	STRING
AmountPaid	STRING
AmountCredited	STRING

GetProjects

purpose:Returns the list of all the Projects.

Source Api documentation https://developer.xero.com/documentation/projects/projects#GET

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
projectId	STRING
contactId	STRING
name	STRING
currencyCode	STRING
minutesLogged	NUMERIC
totalTaskAmount	RECORD
currency	STRING
value	NUMERIC
totalExpenseAmount	RECORD
currency	STRING
value	NUMERIC
minutesToBeInvoiced	NUMERIC
taskAmountToBeInvoiced	RECORD
currency	STRING
value	NUMERIC
taskAmountInvoiced	RECORD
currency	STRING
value	NUMERIC
expenseAmountToBeInvoiced	RECORD
currency	STRING
value	NUMERIC
expenseAmountInvoiced	RECORD
currency	STRING
value	NUMERIC
projectAmountInvoiced	RECORD
currency	STRING
value	NUMERIC
deposit	RECORD
currency	STRING
value	NUMERIC
depositApplied	RECORD
currency	STRING
value	NUMERIC
creditNoteAmount	RECORD
deposit	RECORD
currency	STRING
deadlineUtc	STRING
totalInvoiced	RECORD
currency	STRING
value	NUMERIC
totalToBeInvoiced	RECORD
currency	STRING
value	NUMERIC
estimate	RECORD
currency	STRING
value	NUMERIC
status	STRING

Currencies

purpose:Returns the list of all the currencies.

Source Api documentation https://developer.xero.com/documentation/api/currencies

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
Code	STRING
Description	STRING

CreditNotes

purpose:Returns the list of all the Credit notes.

Source Api documentation https://developer.xero.com/documentation/api/credit-notes

Replication: Key-Based Replication

Replication Key: lastRunDate

Fields

Name	Target Datatype
Contact	RECORD
ContactID	STRING
Name	STRING
DateString	STRING
Date	STRING
Status	STRING
LineAmountTypes	STRING
SubTotal	NUMERIC
TotalTax	NUMERIC
Total	NUMERIC
UpdatedDateUTC	STRING
CurrencyCode	STRING
FullyPaidOnDate	STRING
Type	STRING
CreditNoteID	STRING
CreditNoteNumber	STRING
CurrencyRate	NUMERIC
RemainingCredit	NUMERIC
Allocations	RECORD
Amount	NUMERIC
Date	STRING
Invoice	RECORD
InvoiceID	STRING
InvoiceNumber	STRING