Schema Information of Xero Connector
This topic provides a structured reference to assist you in working with Daton's Xero connector and the associated fields and tables.
Schema Information of Xero Connector
This topic provides a structured reference to assist you in working with Daton's Xero connector and the associated fields and tables.
Tables/APIs
The following is the list of tables or APIs associated with the Xero connector:
- Accounts
- BankTransfers
- BankTransactions
- BatchPayments
- Contacts
- ContactGroups
- Employees
- Invoices
- GetProjects
- Currencies
- CreditNotes
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 |
