Xero Connector Reference

54 metrics340 dimensions

Fields Options

The Xero connector exposes 394 fields (54 metrics, 340 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Available options

profit_and_loss_timeframe Profit And Loss Timeframe

Return one Profit and Loss column per period of this size across the selected date range. Leave unset for a single total column.

Possible values (3)

MONTHQUARTERYEAR

profit_and_loss_periods Profit And Loss Periods

Number of comparison periods to return (1-11). Leave empty to span the selected date range automatically.

Xero Fields

Xero accounts fields

The accounts report of the Xero connector includes 18 fields.

ID	Type	Name	Description
accounts__accountid	TEXT	accounts.AccountID	accounts.AccountID
accounts__bankaccountnumber	TEXT	accounts.BankAccountNumber	accounts.BankAccountNumber
accounts__bankaccounttype	TEXT	accounts.BankAccountType	accounts.BankAccountType
accounts__class	TEXT	accounts.Class	accounts.Class
accounts__code	TEXT	accounts.Code	accounts.Code
accounts__currencycode	TEXT	accounts.CurrencyCode	accounts.CurrencyCode
accounts__description	TEXT	accounts.Description	accounts.Description
accounts__enablepaymentstoaccount	BOOLEAN	accounts.EnablePaymentsToAccount	accounts.EnablePaymentsToAccount
accounts__hasattachments	BOOLEAN	accounts.HasAttachments	accounts.HasAttachments
accounts__name	TEXT	accounts.Name	accounts.Name
accounts__reportingcode	TEXT	accounts.ReportingCode	accounts.ReportingCode
accounts__reportingcodename	TEXT	accounts.ReportingCodeName	accounts.ReportingCodeName
accounts__showinexpenseclaims	BOOLEAN	accounts.ShowInExpenseClaims	accounts.ShowInExpenseClaims
accounts__status	TEXT	accounts.Status	accounts.Status
accounts__systemaccount	TEXT	accounts.SystemAccount	accounts.SystemAccount
accounts__taxtype	TEXT	accounts.TaxType	accounts.TaxType
accounts__type	TEXT	accounts.Type	accounts.Type
accounts__updateddateutc	DATE	accounts.UpdatedDateUTC	accounts.UpdatedDateUTC

Xero balance_sheet fields

The balance_sheet report of the Xero connector includes 8 fields.

ID	Type	Name	Description
balance_sheet__account	TEXT	balance_sheet.Account	Line label (account or summary name).
balance_sheet__accountid	TEXT	balance_sheet.AccountID	Xero account id for the line, when it maps to an account.
balance_sheet__amount	NUMERIC	balance_sheet.Amount	Amount reported for the line in the given period.
balance_sheet__period	TEXT	balance_sheet.Period	Label of the amount column this line belongs to. Xero's Balance Sheet also returns a prior-period comparison column, so each date becomes its own row - filter on this to pick the reporting date.
balance_sheet__reportdate	TEXT	balance_sheet.ReportDate	Report date as shown in Xero.
balance_sheet__reportname	TEXT	balance_sheet.ReportName	Name of the Xero report (e.g. Balance Sheet).
balance_sheet__rowtype	TEXT	balance_sheet.RowType	Row kind: Row for a line item, SummaryRow for a section total.
balance_sheet__section	TEXT	balance_sheet.Section	Report section the line sits under (e.g. Assets, Liabilities).

Xero bank_transactions fields

The bank_transactions report of the Xero connector includes 22 fields.

ID	Type	Name	Description
bank_transactions__bankaccount	OBJECT	bank_transactions.BankAccount	bank_transactions.BankAccount
bank_transactions__banktransactionid	TEXT	bank_transactions.BankTransactionID	bank_transactions.BankTransactionID
bank_transactions__contact	OBJECT	bank_transactions.Contact	bank_transactions.Contact
bank_transactions__currencycode	TEXT	bank_transactions.CurrencyCode	bank_transactions.CurrencyCode
bank_transactions__currencyrate	NUMERIC	bank_transactions.CurrencyRate	bank_transactions.CurrencyRate
bank_transactions__date	DATE	bank_transactions.Date	bank_transactions.Date
bank_transactions__datestring	TEXT	bank_transactions.DateString	bank_transactions.DateString
bank_transactions__externallinkprovidername	TEXT	bank_transactions.ExternalLinkProviderName	bank_transactions.ExternalLinkProviderName
bank_transactions__hasattachments	BOOLEAN	bank_transactions.HasAttachments	bank_transactions.HasAttachments
bank_transactions__isreconciled	BOOLEAN	bank_transactions.IsReconciled	bank_transactions.IsReconciled
bank_transactions__lineamounttypes	TEXT	bank_transactions.LineAmountTypes	bank_transactions.LineAmountTypes
bank_transactions__lineitems	OBJECT	bank_transactions.LineItems	bank_transactions.LineItems
bank_transactions__overpaymentid	TEXT	bank_transactions.OverpaymentID	bank_transactions.OverpaymentID
bank_transactions__prepaymentid	TEXT	bank_transactions.PrepaymentID	bank_transactions.PrepaymentID
bank_transactions__reference	TEXT	bank_transactions.Reference	bank_transactions.Reference
bank_transactions__status	TEXT	bank_transactions.Status	bank_transactions.Status
bank_transactions__subtotal	NUMERIC	bank_transactions.SubTotal	bank_transactions.SubTotal
bank_transactions__total	NUMERIC	bank_transactions.Total	bank_transactions.Total
bank_transactions__totaltax	NUMERIC	bank_transactions.TotalTax	bank_transactions.TotalTax
bank_transactions__type	TEXT	bank_transactions.Type	bank_transactions.Type
bank_transactions__updateddateutc	DATE	bank_transactions.UpdatedDateUTC	bank_transactions.UpdatedDateUTC
bank_transactions__url	TEXT	bank_transactions.Url	bank_transactions.Url

Xero bank_transfers fields

The bank_transfers report of the Xero connector includes 12 fields.

ID	Type	Name	Description
bank_transfers__amount	NUMERIC	bank_transfers.Amount	bank_transfers.Amount
bank_transfers__banktransferid	TEXT	bank_transfers.BankTransferID	bank_transfers.BankTransferID
bank_transfers__createddateutc	DATE	bank_transfers.CreatedDateUTC	bank_transfers.CreatedDateUTC
bank_transfers__createddateutcstring	TEXT	bank_transfers.CreatedDateUTCString	bank_transfers.CreatedDateUTCString
bank_transfers__currencyrate	NUMERIC	bank_transfers.CurrencyRate	bank_transfers.CurrencyRate
bank_transfers__date	DATE	bank_transfers.Date	bank_transfers.Date
bank_transfers__datestring	TEXT	bank_transfers.DateString	bank_transfers.DateString
bank_transfers__frombankaccount	OBJECT	bank_transfers.FromBankAccount	bank_transfers.FromBankAccount
bank_transfers__frombanktransactionid	TEXT	bank_transfers.FromBankTransactionID	bank_transfers.FromBankTransactionID
bank_transfers__hasattachments	BOOLEAN	bank_transfers.HasAttachments	bank_transfers.HasAttachments
bank_transfers__tobankaccount	OBJECT	bank_transfers.ToBankAccount	bank_transfers.ToBankAccount
bank_transfers__tobanktransactionid	TEXT	bank_transfers.ToBankTransactionID	bank_transfers.ToBankTransactionID

Xero branding_themes fields

The branding_themes report of the Xero connector includes 4 fields.

ID	Type	Name	Description
branding_themes__brandingthemeid	TEXT	branding_themes.BrandingThemeID	branding_themes.BrandingThemeID
branding_themes__createddateutc	DATE	branding_themes.CreatedDateUTC	branding_themes.CreatedDateUTC
branding_themes__name	TEXT	branding_themes.Name	branding_themes.Name
branding_themes__sortorder	NUMERIC	branding_themes.SortOrder	branding_themes.SortOrder

Xero contact_groups fields

The contact_groups report of the Xero connector includes 4 fields.

ID	Type	Name	Description
contact_groups__contactgroupid	TEXT	contact_groups.ContactGroupID	contact_groups.ContactGroupID
contact_groups__hasvalidationerrors	BOOLEAN	contact_groups.HasValidationErrors	contact_groups.HasValidationErrors
contact_groups__name	TEXT	contact_groups.Name	contact_groups.Name
contact_groups__status	TEXT	contact_groups.Status	contact_groups.Status

Xero contacts fields

The contacts report of the Xero connector includes 38 fields.

ID	Type	Name	Description
contacts__accountnumber	TEXT	contacts.AccountNumber	contacts.AccountNumber
contacts__accountspayabletaxtype	TEXT	contacts.AccountsPayableTaxType	contacts.AccountsPayableTaxType
contacts__accountsreceivabletaxtype	TEXT	contacts.AccountsReceivableTaxType	contacts.AccountsReceivableTaxType
contacts__addresses	OBJECT	contacts.Addresses	contacts.Addresses
contacts__attachments	OBJECT	contacts.Attachments	contacts.Attachments
contacts__balances	OBJECT	contacts.Balances	contacts.Balances
contacts__bankaccountdetails	TEXT	contacts.BankAccountDetails	contacts.BankAccountDetails
contacts__batchpayments	OBJECT	contacts.BatchPayments	contacts.BatchPayments
contacts__brandingtheme	OBJECT	contacts.BrandingTheme	contacts.BrandingTheme
contacts__contactgroups	OBJECT	contacts.ContactGroups	contacts.ContactGroups
contacts__contactid	TEXT	contacts.ContactID	contacts.ContactID
contacts__contactnumber	TEXT	contacts.ContactNumber	contacts.ContactNumber
contacts__contactpersons	OBJECT	contacts.ContactPersons	contacts.ContactPersons
contacts__contactstatus	TEXT	contacts.ContactStatus	contacts.ContactStatus
contacts__defaultcurrency	TEXT	contacts.DefaultCurrency	contacts.DefaultCurrency
contacts__discount	NUMERIC	contacts.Discount	contacts.Discount
contacts__emailaddress	TEXT	contacts.EmailAddress	contacts.EmailAddress
contacts__firstname	TEXT	contacts.FirstName	contacts.FirstName
contacts__hasattachments	BOOLEAN	contacts.HasAttachments	contacts.HasAttachments
contacts__hasvalidationerrors	BOOLEAN	contacts.HasValidationErrors	contacts.HasValidationErrors
contacts__iscustomer	BOOLEAN	contacts.IsCustomer	contacts.IsCustomer
contacts__issupplier	BOOLEAN	contacts.IsSupplier	contacts.IsSupplier
contacts__lastname	TEXT	contacts.LastName	contacts.LastName
contacts__name	TEXT	contacts.Name	contacts.Name
contacts__paymentterms	OBJECT	contacts.PaymentTerms	contacts.PaymentTerms
contacts__phones	OBJECT	contacts.Phones	contacts.Phones
contacts__purchasesdefaultaccountcode	TEXT	contacts.PurchasesDefaultAccountCode	contacts.PurchasesDefaultAccountCode
contacts__purchasestrackingcategories	OBJECT	contacts.PurchasesTrackingCategories	contacts.PurchasesTrackingCategories
contacts__salesdefaultaccountcode	TEXT	contacts.SalesDefaultAccountCode	contacts.SalesDefaultAccountCode
contacts__salestrackingcategories	OBJECT	contacts.SalesTrackingCategories	contacts.SalesTrackingCategories
contacts__skypeusername	TEXT	contacts.SkypeUserName	contacts.SkypeUserName
contacts__taxnumber	TEXT	contacts.TaxNumber	contacts.TaxNumber
contacts__trackingcategoryname	TEXT	contacts.TrackingCategoryName	contacts.TrackingCategoryName
contacts__trackingcategoryoption	TEXT	contacts.TrackingCategoryOption	contacts.TrackingCategoryOption
contacts__updateddateutc	DATE	contacts.UpdatedDateUTC	contacts.UpdatedDateUTC
contacts__validationerrors	OBJECT	contacts.ValidationErrors	contacts.ValidationErrors
contacts__website	TEXT	contacts.Website	contacts.Website
contacts__xeronetworkkey	TEXT	contacts.XeroNetworkKey	contacts.XeroNetworkKey

Xero credit_notes fields

The credit_notes report of the Xero connector includes 26 fields.

ID	Type	Name	Description
credit_notes__allocations	OBJECT	credit_notes.Allocations	credit_notes.Allocations
credit_notes__appliedamount	NUMERIC	credit_notes.AppliedAmount	credit_notes.AppliedAmount
credit_notes__brandingthemeid	TEXT	credit_notes.BrandingThemeID	credit_notes.BrandingThemeID
credit_notes__contact	OBJECT	credit_notes.Contact	credit_notes.Contact
credit_notes__creditnoteid	TEXT	credit_notes.CreditNoteID	credit_notes.CreditNoteID
credit_notes__creditnotenumber	TEXT	credit_notes.CreditNoteNumber	credit_notes.CreditNoteNumber
credit_notes__currencycode	TEXT	credit_notes.CurrencyCode	credit_notes.CurrencyCode
credit_notes__currencyrate	NUMERIC	credit_notes.CurrencyRate	credit_notes.CurrencyRate
credit_notes__date	DATE	credit_notes.Date	credit_notes.Date
credit_notes__datestring	TEXT	credit_notes.DateString	credit_notes.DateString
credit_notes__duedate	DATE	credit_notes.DueDate	credit_notes.DueDate
credit_notes__duedatestring	TEXT	credit_notes.DueDateString	credit_notes.DueDateString
credit_notes__fullypaidondate	DATE	credit_notes.FullyPaidOnDate	credit_notes.FullyPaidOnDate
credit_notes__hasattachments	BOOLEAN	credit_notes.HasAttachments	credit_notes.HasAttachments
credit_notes__id	TEXT	credit_notes.ID	credit_notes.ID
credit_notes__lineamounttypes	TEXT	credit_notes.LineAmountTypes	credit_notes.LineAmountTypes
credit_notes__lineitems	OBJECT	credit_notes.LineItems	credit_notes.LineItems
credit_notes__reference	TEXT	credit_notes.Reference	credit_notes.Reference
credit_notes__remainingcredit	NUMERIC	credit_notes.RemainingCredit	credit_notes.RemainingCredit
credit_notes__senttocontact	BOOLEAN	credit_notes.SentToContact	credit_notes.SentToContact
credit_notes__status	TEXT	credit_notes.Status	credit_notes.Status
credit_notes__subtotal	NUMERIC	credit_notes.SubTotal	credit_notes.SubTotal
credit_notes__total	NUMERIC	credit_notes.Total	credit_notes.Total
credit_notes__totaltax	NUMERIC	credit_notes.TotalTax	credit_notes.TotalTax
credit_notes__type	TEXT	credit_notes.Type	credit_notes.Type
credit_notes__updateddateutc	DATE	credit_notes.UpdatedDateUTC	credit_notes.UpdatedDateUTC

Xero employees fields

The employees report of the Xero connector includes 6 fields.

ID	Type	Name	Description
employees__employeeid	TEXT	employees.EmployeeID	employees.EmployeeID
employees__externallink	TEXT	employees.ExternalLink	employees.ExternalLink
employees__firstname	TEXT	employees.FirstName	employees.FirstName
employees__lastname	TEXT	employees.LastName	employees.LastName
employees__status	TEXT	employees.Status	employees.Status
employees__updateddateutc	DATE	employees.UpdatedDateUTC	employees.UpdatedDateUTC

Xero invoices fields

The invoices report of the Xero connector includes 37 fields.

ID	Type	Name	Description
invoices__amountcredited	NUMERIC	invoices.AmountCredited	invoices.AmountCredited
invoices__amountdue	NUMERIC	invoices.AmountDue	invoices.AmountDue
invoices__amountpaid	NUMERIC	invoices.AmountPaid	invoices.AmountPaid
invoices__brandingthemeid	TEXT	invoices.BrandingThemeID	invoices.BrandingThemeID
invoices__contact	OBJECT	invoices.Contact	invoices.Contact
invoices__creditnotes	OBJECT	invoices.CreditNotes	invoices.CreditNotes
invoices__currencycode	TEXT	invoices.CurrencyCode	invoices.CurrencyCode
invoices__currencyrate	NUMERIC	invoices.CurrencyRate	invoices.CurrencyRate
invoices__date	DATE	invoices.Date	invoices.Date
invoices__datestring	TEXT	invoices.DateString	invoices.DateString
invoices__duedate	DATE	invoices.DueDate	invoices.DueDate
invoices__duedatestring	TEXT	invoices.DueDateString	invoices.DueDateString
invoices__expectedpaymentdate	DATE	invoices.ExpectedPaymentDate	invoices.ExpectedPaymentDate
invoices__expectedpaymentdatestring	TEXT	invoices.ExpectedPaymentDateString	invoices.ExpectedPaymentDateString
invoices__fullypaidondate	DATE	invoices.FullyPaidOnDate	invoices.FullyPaidOnDate
invoices__hasattachments	BOOLEAN	invoices.HasAttachments	invoices.HasAttachments
invoices__haserrors	BOOLEAN	invoices.HasErrors	invoices.HasErrors
invoices__invoiceid	TEXT	invoices.InvoiceID	invoices.InvoiceID
invoices__invoicenumber	TEXT	invoices.InvoiceNumber	invoices.InvoiceNumber
invoices__isdiscounted	BOOLEAN	invoices.IsDiscounted	invoices.IsDiscounted
invoices__lineamounttypes	TEXT	invoices.LineAmountTypes	invoices.LineAmountTypes
invoices__lineitems	OBJECT	invoices.LineItems	invoices.LineItems
invoices__overpayments	OBJECT	invoices.Overpayments	invoices.Overpayments
invoices__payments	OBJECT	invoices.Payments	invoices.Payments
invoices__plannedpaymentdate	DATE	invoices.PlannedPaymentDate	invoices.PlannedPaymentDate
invoices__plannedpaymentdatestring	TEXT	invoices.PlannedPaymentDateString	invoices.PlannedPaymentDateString
invoices__prepayments	OBJECT	invoices.Prepayments	invoices.Prepayments
invoices__reference	TEXT	invoices.Reference	invoices.Reference
invoices__senttocontact	BOOLEAN	invoices.SentToContact	invoices.SentToContact
invoices__status	TEXT	invoices.Status	invoices.Status
invoices__subtotal	NUMERIC	invoices.SubTotal	invoices.SubTotal
invoices__total	NUMERIC	invoices.Total	invoices.Total
invoices__totaldiscount	NUMERIC	invoices.TotalDiscount	invoices.TotalDiscount
invoices__totaltax	NUMERIC	invoices.TotalTax	invoices.TotalTax
invoices__type	TEXT	invoices.Type	invoices.Type
invoices__updateddateutc	DATE	invoices.UpdatedDateUTC	invoices.UpdatedDateUTC
invoices__url	TEXT	invoices.Url	invoices.Url

Xero items fields

The items report of the Xero connector includes 14 fields.

ID	Type	Name	Description
items__code	TEXT	items.Code	items.Code
items__description	TEXT	items.Description	items.Description
items__inventoryassetaccountcode	TEXT	items.InventoryAssetAccountCode	items.InventoryAssetAccountCode
items__ispurchased	BOOLEAN	items.IsPurchased	items.IsPurchased
items__issold	BOOLEAN	items.IsSold	items.IsSold
items__istrackedasinventory	BOOLEAN	items.IsTrackedAsInventory	items.IsTrackedAsInventory
items__itemid	TEXT	items.ItemID	items.ItemID
items__name	TEXT	items.Name	items.Name
items__purchasedescription	TEXT	items.PurchaseDescription	items.PurchaseDescription
items__purchasedetails	OBJECT	items.PurchaseDetails	items.PurchaseDetails
items__quantityonhand	NUMERIC	items.QuantityOnHand	items.QuantityOnHand
items__salesdetails	OBJECT	items.SalesDetails	items.SalesDetails
items__totalcostpool	NUMERIC	items.TotalCostPool	items.TotalCostPool
items__updateddateutc	DATE	items.UpdatedDateUTC	items.UpdatedDateUTC

Xero manual_journals fields

The manual_journals report of the Xero connector includes 10 fields.

ID	Type	Name	Description
manual_journals__date	DATE	manual_journals.Date	manual_journals.Date
manual_journals__hasattachments	BOOLEAN	manual_journals.HasAttachments	manual_journals.HasAttachments
manual_journals__journallines	OBJECT	manual_journals.JournalLines	manual_journals.JournalLines
manual_journals__lineamounttypes	TEXT	manual_journals.LineAmountTypes	manual_journals.LineAmountTypes
manual_journals__manualjournalid	TEXT	manual_journals.ManualJournalID	manual_journals.ManualJournalID
manual_journals__narration	TEXT	manual_journals.Narration	manual_journals.Narration
manual_journals__showoncashbasisreports	BOOLEAN	manual_journals.ShowOnCashBasisReports	manual_journals.ShowOnCashBasisReports
manual_journals__status	TEXT	manual_journals.Status	manual_journals.Status
manual_journals__updateddateutc	DATE	manual_journals.UpdatedDateUTC	manual_journals.UpdatedDateUTC
manual_journals__url	TEXT	manual_journals.Url	manual_journals.Url

Xero organisations fields

The organisations report of the Xero connector includes 30 fields.

ID	Type	Name	Description
organisations__addresses	OBJECT	organisations.Addresses	organisations.Addresses
organisations__apikey	TEXT	organisations.APIKey	organisations.APIKey
organisations__basecurrency	TEXT	organisations.BaseCurrency	organisations.BaseCurrency
organisations__countrycode	TEXT	organisations.CountryCode	organisations.CountryCode
organisations__createddateutc	DATE	organisations.CreatedDateUTC	organisations.CreatedDateUTC
organisations__defaultpurchasestax	TEXT	organisations.DefaultPurchasesTax	organisations.DefaultPurchasesTax
organisations__defaultsalestax	TEXT	organisations.DefaultSalesTax	organisations.DefaultSalesTax
organisations__endofyearlockdate	DATE	organisations.EndOfYearLockDate	organisations.EndOfYearLockDate
organisations__externallinks	OBJECT	organisations.ExternalLinks	organisations.ExternalLinks
organisations__financialyearendday	NUMERIC	organisations.FinancialYearEndDay	organisations.FinancialYearEndDay
organisations__financialyearendmonth	NUMERIC	organisations.FinancialYearEndMonth	organisations.FinancialYearEndMonth
organisations__isdemocompany	BOOLEAN	organisations.IsDemoCompany	organisations.IsDemoCompany
organisations__legalname	TEXT	organisations.LegalName	organisations.LegalName
organisations__lineofbusiness	TEXT	organisations.LineOfBusiness	organisations.LineOfBusiness
organisations__name	TEXT	organisations.Name	organisations.Name
organisations__organisationentitytype	TEXT	organisations.OrganisationEntityType	organisations.OrganisationEntityType
organisations__organisationid	TEXT	organisations.OrganisationID	organisations.OrganisationID
organisations__organisationstatus	TEXT	organisations.OrganisationStatus	organisations.OrganisationStatus
organisations__organisationtype	TEXT	organisations.OrganisationType	organisations.OrganisationType
organisations__paymentterms	OBJECT	organisations.PaymentTerms	organisations.PaymentTerms
organisations__paystax	BOOLEAN	organisations.PaysTax	organisations.PaysTax
organisations__periodlockdate	DATE	organisations.PeriodLockDate	organisations.PeriodLockDate
organisations__phones	OBJECT	organisations.Phones	organisations.Phones
organisations__registrationnumber	TEXT	organisations.RegistrationNumber	organisations.RegistrationNumber
organisations__salestaxbasis	TEXT	organisations.SalesTaxBasis	organisations.SalesTaxBasis
organisations__salestaxperiod	TEXT	organisations.SalesTaxPeriod	organisations.SalesTaxPeriod
organisations__shortcode	TEXT	organisations.ShortCode	organisations.ShortCode
organisations__taxnumber	TEXT	organisations.TaxNumber	organisations.TaxNumber
organisations__timezone	TEXT	organisations.Timezone	organisations.Timezone
organisations__version	TEXT	organisations.Version	organisations.Version

Xero overpayments fields

The overpayments report of the Xero connector includes 21 fields.

ID	Type	Name	Description
overpayments__allocations	OBJECT	overpayments.Allocations	overpayments.Allocations
overpayments__appliedamount	NUMERIC	overpayments.AppliedAmount	overpayments.AppliedAmount
overpayments__contact	OBJECT	overpayments.Contact	overpayments.Contact
overpayments__currencycode	TEXT	overpayments.CurrencyCode	overpayments.CurrencyCode
overpayments__currencyrate	NUMERIC	overpayments.CurrencyRate	overpayments.CurrencyRate
overpayments__date	DATE	overpayments.Date	overpayments.Date
overpayments__datestring	TEXT	overpayments.DateString	overpayments.DateString
overpayments__hasattachments	BOOLEAN	overpayments.HasAttachments	overpayments.HasAttachments
overpayments__id	TEXT	overpayments.ID	overpayments.ID
overpayments__lineamounttypes	TEXT	overpayments.LineAmountTypes	overpayments.LineAmountTypes
overpayments__lineitems	OBJECT	overpayments.LineItems	overpayments.LineItems
overpayments__overpaymentid	TEXT	overpayments.OverpaymentID	overpayments.OverpaymentID
overpayments__payments	OBJECT	overpayments.Payments	overpayments.Payments
overpayments__reference	TEXT	overpayments.Reference	overpayments.Reference
overpayments__remainingcredit	NUMERIC	overpayments.RemainingCredit	overpayments.RemainingCredit
overpayments__status	TEXT	overpayments.Status	overpayments.Status
overpayments__subtotal	NUMERIC	overpayments.SubTotal	overpayments.SubTotal
overpayments__total	NUMERIC	overpayments.Total	overpayments.Total
overpayments__totaltax	NUMERIC	overpayments.TotalTax	overpayments.TotalTax
overpayments__type	TEXT	overpayments.Type	overpayments.Type
overpayments__updateddateutc	DATE	overpayments.UpdatedDateUTC	overpayments.UpdatedDateUTC

Xero payments fields

The payments report of the Xero connector includes 18 fields.

ID	Type	Name	Description
payments__account	OBJECT	payments.Account	payments.Account
payments__amount	NUMERIC	payments.Amount	payments.Amount
payments__bankamount	NUMERIC	payments.BankAmount	payments.BankAmount
payments__batchpaymentid	TEXT	payments.BatchPaymentID	payments.BatchPaymentID
payments__creditnote	OBJECT	payments.CreditNote	payments.CreditNote
payments__currencyrate	NUMERIC	payments.CurrencyRate	payments.CurrencyRate
payments__date	DATE	payments.Date	payments.Date
payments__hasaccount	BOOLEAN	payments.HasAccount	payments.HasAccount
payments__hasvalidationerrors	BOOLEAN	payments.HasValidationErrors	payments.HasValidationErrors
payments__invoice	OBJECT	payments.Invoice	payments.Invoice
payments__isreconciled	BOOLEAN	payments.IsReconciled	payments.IsReconciled
payments__overpayment	OBJECT	payments.Overpayment	payments.Overpayment
payments__paymentid	TEXT	payments.PaymentID	payments.PaymentID
payments__paymenttype	TEXT	payments.PaymentType	payments.PaymentType
payments__prepayments	OBJECT	payments.Prepayments	payments.Prepayments
payments__reference	TEXT	payments.Reference	payments.Reference
payments__status	TEXT	payments.Status	payments.Status
payments__updateddateutc	DATE	payments.UpdatedDateUTC	payments.UpdatedDateUTC

Xero prepayments fields

The prepayments report of the Xero connector includes 21 fields.

ID	Type	Name	Description
prepayments__allocations	OBJECT	prepayments.Allocations	prepayments.Allocations
prepayments__appliedamount	NUMERIC	prepayments.AppliedAmount	prepayments.AppliedAmount
prepayments__contact	OBJECT	prepayments.Contact	prepayments.Contact
prepayments__currencycode	TEXT	prepayments.CurrencyCode	prepayments.CurrencyCode
prepayments__currencyrate	NUMERIC	prepayments.CurrencyRate	prepayments.CurrencyRate
prepayments__date	DATE	prepayments.Date	prepayments.Date
prepayments__datestring	TEXT	prepayments.DateString	prepayments.DateString
prepayments__hasattachments	BOOLEAN	prepayments.HasAttachments	prepayments.HasAttachments
prepayments__id	TEXT	prepayments.ID	prepayments.ID
prepayments__lineamounttypes	TEXT	prepayments.LineAmountTypes	prepayments.LineAmountTypes
prepayments__lineitems	OBJECT	prepayments.LineItems	prepayments.LineItems
prepayments__payments	OBJECT	prepayments.Payments	prepayments.Payments
prepayments__prepaymentid	TEXT	prepayments.PrepaymentID	prepayments.PrepaymentID
prepayments__reference	TEXT	prepayments.Reference	prepayments.Reference
prepayments__remainingcredit	NUMERIC	prepayments.RemainingCredit	prepayments.RemainingCredit
prepayments__status	TEXT	prepayments.Status	prepayments.Status
prepayments__subtotal	NUMERIC	prepayments.SubTotal	prepayments.SubTotal
prepayments__total	NUMERIC	prepayments.Total	prepayments.Total
prepayments__totaltax	NUMERIC	prepayments.TotalTax	prepayments.TotalTax
prepayments__type	TEXT	prepayments.Type	prepayments.Type
prepayments__updateddateutc	DATE	prepayments.UpdatedDateUTC	prepayments.UpdatedDateUTC

Xero profit_and_loss fields

The profit_and_loss report of the Xero connector includes 8 fields.

ID	Type	Name	Description
profit_and_loss__account	TEXT	profit_and_loss.Account	Line label (account or summary name).
profit_and_loss__accountid	TEXT	profit_and_loss.AccountID	Xero account id for the line, when it maps to an account.
profit_and_loss__amount	NUMERIC	profit_and_loss.Amount	Amount reported for the line in the given period.
profit_and_loss__period	TEXT	profit_and_loss.Period	Label of the amount column this line belongs to.
profit_and_loss__reportdate	TEXT	profit_and_loss.ReportDate	Report date as shown in Xero.
profit_and_loss__reportname	TEXT	profit_and_loss.ReportName	Name of the Xero report (e.g. Profit and Loss).
profit_and_loss__rowtype	TEXT	profit_and_loss.RowType	Row kind: Row for a line item, SummaryRow for a section total.
profit_and_loss__section	TEXT	profit_and_loss.Section	Report section the line sits under (e.g. Income, Expenses).

Xero purchase_orders fields

The purchase_orders report of the Xero connector includes 30 fields.

ID	Type	Name	Description
purchase_orders__attentionto	TEXT	purchase_orders.AttentionTo	purchase_orders.AttentionTo
purchase_orders__brandingthemeid	TEXT	purchase_orders.BrandingThemeID	purchase_orders.BrandingThemeID
purchase_orders__contact	OBJECT	purchase_orders.Contact	purchase_orders.Contact
purchase_orders__currencycode	TEXT	purchase_orders.CurrencyCode	purchase_orders.CurrencyCode
purchase_orders__currencyrate	NUMERIC	purchase_orders.CurrencyRate	purchase_orders.CurrencyRate
purchase_orders__date	DATE	purchase_orders.Date	purchase_orders.Date
purchase_orders__datestring	TEXT	purchase_orders.DateString	purchase_orders.DateString
purchase_orders__deliveryaddress	TEXT	purchase_orders.DeliveryAddress	purchase_orders.DeliveryAddress
purchase_orders__deliverydate	DATE	purchase_orders.DeliveryDate	purchase_orders.DeliveryDate
purchase_orders__deliverydatestring	TEXT	purchase_orders.DeliveryDateString	purchase_orders.DeliveryDateString
purchase_orders__deliveryinstructions	TEXT	purchase_orders.DeliveryInstructions	purchase_orders.DeliveryInstructions
purchase_orders__expectedarrivaldate	DATE	purchase_orders.ExpectedArrivalDate	purchase_orders.ExpectedArrivalDate
purchase_orders__expectedarrivaldatestring	TEXT	purchase_orders.ExpectedArrivalDateString	purchase_orders.ExpectedArrivalDateString
purchase_orders__hasattachments	BOOLEAN	purchase_orders.HasAttachments	purchase_orders.HasAttachments
purchase_orders__haserrors	BOOLEAN	purchase_orders.HasErrors	purchase_orders.HasErrors
purchase_orders__isdiscounted	BOOLEAN	purchase_orders.IsDiscounted	purchase_orders.IsDiscounted
purchase_orders__lineamounttypes	TEXT	purchase_orders.LineAmountTypes	purchase_orders.LineAmountTypes
purchase_orders__lineitems	OBJECT	purchase_orders.LineItems	purchase_orders.LineItems
purchase_orders__purchaseorderid	TEXT	purchase_orders.PurchaseOrderID	purchase_orders.PurchaseOrderID
purchase_orders__purchaseordernumber	TEXT	purchase_orders.PurchaseOrderNumber	purchase_orders.PurchaseOrderNumber
purchase_orders__reference	TEXT	purchase_orders.Reference	purchase_orders.Reference
purchase_orders__senttocontact	BOOLEAN	purchase_orders.SentToContact	purchase_orders.SentToContact
purchase_orders__status	TEXT	purchase_orders.Status	purchase_orders.Status
purchase_orders__subtotal	NUMERIC	purchase_orders.SubTotal	purchase_orders.SubTotal
purchase_orders__telephone	TEXT	purchase_orders.Telephone	purchase_orders.Telephone
purchase_orders__total	NUMERIC	purchase_orders.Total	purchase_orders.Total
purchase_orders__totaldiscount	NUMERIC	purchase_orders.TotalDiscount	purchase_orders.TotalDiscount
purchase_orders__totaltax	NUMERIC	purchase_orders.TotalTax	purchase_orders.TotalTax
purchase_orders__type	TEXT	purchase_orders.Type	purchase_orders.Type
purchase_orders__updateddateutc	DATE	purchase_orders.UpdatedDateUTC	purchase_orders.UpdatedDateUTC

Xero repeating_invoices fields

The repeating_invoices report of the Xero connector includes 16 fields.

ID	Type	Name	Description
repeating_invoices__brandingthemeid	TEXT	repeating_invoices.BrandingThemeID	repeating_invoices.BrandingThemeID
repeating_invoices__contact	OBJECT	repeating_invoices.Contact	repeating_invoices.Contact
repeating_invoices__currencycode	TEXT	repeating_invoices.CurrencyCode	repeating_invoices.CurrencyCode
repeating_invoices__hasattachments	BOOLEAN	repeating_invoices.HasAttachments	repeating_invoices.HasAttachments
repeating_invoices__id	TEXT	repeating_invoices.ID	repeating_invoices.ID
repeating_invoices__lineamounttypes	TEXT	repeating_invoices.LineAmountTypes	repeating_invoices.LineAmountTypes
repeating_invoices__lineitems	OBJECT	repeating_invoices.LineItems	repeating_invoices.LineItems
repeating_invoices__reference	TEXT	repeating_invoices.Reference	repeating_invoices.Reference
repeating_invoices__repeatinginvoiceid	TEXT	repeating_invoices.RepeatingInvoiceID	repeating_invoices.RepeatingInvoiceID
repeating_invoices__schedule	OBJECT	repeating_invoices.Schedule	repeating_invoices.Schedule
repeating_invoices__status	TEXT	repeating_invoices.Status	repeating_invoices.Status
repeating_invoices__subtotal	NUMERIC	repeating_invoices.SubTotal	repeating_invoices.SubTotal
repeating_invoices__total	NUMERIC	repeating_invoices.Total	repeating_invoices.Total
repeating_invoices__totaldiscount	NUMERIC	repeating_invoices.TotalDiscount	repeating_invoices.TotalDiscount
repeating_invoices__totaltax	NUMERIC	repeating_invoices.TotalTax	repeating_invoices.TotalTax
repeating_invoices__type	TEXT	repeating_invoices.Type	repeating_invoices.Type

Xero tax_rates fields

The tax_rates report of the Xero connector includes 12 fields.

ID	Type	Name	Description
tax_rates__canapplytoassets	BOOLEAN	tax_rates.CanApplyToAssets	tax_rates.CanApplyToAssets
tax_rates__canapplytoequity	BOOLEAN	tax_rates.CanApplyToEquity	tax_rates.CanApplyToEquity
tax_rates__canapplytoexpenses	BOOLEAN	tax_rates.CanApplyToExpenses	tax_rates.CanApplyToExpenses
tax_rates__canapplytoliabilities	BOOLEAN	tax_rates.CanApplyToLiabilities	tax_rates.CanApplyToLiabilities
tax_rates__canapplytorevenue	BOOLEAN	tax_rates.CanApplyToRevenue	tax_rates.CanApplyToRevenue
tax_rates__displaytaxrate	NUMERIC	tax_rates.DisplayTaxRate	tax_rates.DisplayTaxRate
tax_rates__effectiverate	NUMERIC	tax_rates.EffectiveRate	tax_rates.EffectiveRate
tax_rates__name	TEXT	tax_rates.Name	tax_rates.Name
tax_rates__reporttaxtype	TEXT	tax_rates.ReportTaxType	tax_rates.ReportTaxType
tax_rates__status	TEXT	tax_rates.Status	tax_rates.Status
tax_rates__taxcomponents	OBJECT	tax_rates.TaxComponents	tax_rates.TaxComponents
tax_rates__taxtype	TEXT	tax_rates.TaxType	tax_rates.TaxType

Xero tracking_categories fields

The tracking_categories report of the Xero connector includes 8 fields.

ID	Type	Name	Description
tracking_categories__name	TEXT	tracking_categories.Name	tracking_categories.Name
tracking_categories__option	TEXT	tracking_categories.Option	tracking_categories.Option
tracking_categories__options	OBJECT	tracking_categories.Options	tracking_categories.Options
tracking_categories__status	TEXT	tracking_categories.Status	tracking_categories.Status
tracking_categories__trackingcategoryid	TEXT	tracking_categories.TrackingCategoryID	tracking_categories.TrackingCategoryID
tracking_categories__trackingcategoryname	TEXT	tracking_categories.TrackingCategoryName	tracking_categories.TrackingCategoryName
tracking_categories__trackingoptionid	TEXT	tracking_categories.TrackingOptionID	tracking_categories.TrackingOptionID
tracking_categories__trackingoptionname	TEXT	tracking_categories.TrackingOptionName	tracking_categories.TrackingOptionName

Xero users fields

The users report of the Xero connector includes 8 fields.

ID	Type	Name	Description
users__emailaddress	TEXT	users.EmailAddress	users.EmailAddress
users__firstname	TEXT	users.FirstName	users.FirstName
users__issubscriber	BOOLEAN	users.IsSubscriber	users.IsSubscriber
users__lastname	TEXT	users.LastName	users.LastName
users__organisationrole	TEXT	users.OrganisationRole	users.OrganisationRole
users__updateddateutc	DATE	users.UpdatedDateUTC	users.UpdatedDateUTC
users__userid	TEXT	users.UserID	users.UserID
users__validationerrors	OBJECT	users.ValidationErrors	users.ValidationErrors

Xero other fields

The Xero connector has 23 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description	Report
account_id	TEXT	Account ID	Account ID.
account_name	TEXT	Account Name	Account name.
currencies__code	TEXT	currencies.Code	currencies.Code	currencies
currencies__description	TEXT	currencies.Description	currencies.Description	currencies
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
date	DATE	Date	Date.
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
week	TEXT	Week	Week (Sun-Sat).
week_day	TEXT	Day of week and day number	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso	TEXT	Day of week and day number, ISO	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso	TEXT	Week ISO	Week, ISO format (Mon-Sun).
year	TEXT	Year	Year
year_month	TEXT	Yearmonth	Year and month, e.g. 2024\|3
year_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
year_of_week	TEXT	Year of week	The year that contains first day of the week (Sun-Sat).
year_of_week_iso	TEXT	Year of week, ISO	The year that contains first day of the ISO week (Mon-Sun).
year_week	TEXT	Year week	Year and week for US weeks (Sun-Sat), e.g. 2024\|15
year_week_iso	TEXT	Year week ISO	Year and week for ISO weeks (Mon-Sun), e.g. 2024\|20

API Connectors