Documentation

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Talk To sales
  • Start Trial

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.

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Pulse

    • Daton

      Need help with something?

      Talk to data expert

      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
      connector schema xero schema

      Was this article helpful?

      Yes
      No
      Give feedback about this article

      Related Articles

      • Essential Attributes and Supported Tables
      • How to Integrate Xero with Daton

      Table of Contents

      Tables/APIs Xero Data

      Get Started on your Data Journey Today!

      Get a free 14-day trial of Daton today, no credit card is required.

      Start Free Trial
      Talk To Experts
      • Quick & Easy Setup
      • Secure & Reliable
      • No-Code Platform
      • Auto Updates
      • 24/7 Support

      Follow Us

      Linkedin Youtube

      Company

      • Customers
      • Partner With Us
      • Contact Us

      Culture

      • About
      • People
      • Careers

      Offerings

      • Daton
      • For Brands
      • For Agencies

      Policies

      • Terms of Service
      • Privacy Policy
      • MSA

      Follow Us

      Linkedin Youtube

      DISCLAIMER: Various trademarks are held by their respective owners

      © 2023 sarasanalytics.com

      Sitemap

      Get Started on your Data Journey Today!

      Get a free 14-day trial of Daton today, no credit card is required.

      Start Free Trial
      Talk To Sales
      DISCLAIMER: Trademarks are held by their respective owners
      • Quick & Easy Setup
      • Secure & Reliable
      • No-Code Platform
      • Auto Updates
      • 24/7 Support

      Company

      • Customers
      • Partners
      • About
      • People
      • Careers
      • Contact Us

      Offerings

      • Daton
      • Solution for Brands
      • Solution for Agencies
      • Dashboards
      • Founder's Note
      • Status

      Policies

      • Terms of Service
      • Privacy Policy
      • MSA
      • Sitemap

      © 2023 sarasanalytics.com

      Linkedin Youtube

      Knowledge Base Software powered by Helpjuice

      Expand