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. 1.
    Signin to Daton
  2. 2.
    Select xero from Integrations page
  3. 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. 4.
    Provide your xero account email and Password.
  5. 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. 6.
    Post successful authentication you will be prompted to choose from the list of available tables
  7. 7.
    Then select all required fields for each table
  8. 8.
    Submit the integration.

Workflow

  1. 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. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 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.
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.
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.
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
BatchPayments
Purpose:Returns a result of all the 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
Contacts
Purpose:Returns a result of all the 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
ContactGroups
Purpose: Returns a list of all the Contact groups.
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.
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.
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
GetProjects
purpose:Returns the list of all the Projects.
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
Currencies
purpose:Returns the list of all the 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.
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