Xero
Xero
FonteUse Dataddo's Xero connector to explore any data available via the official API of Xero. Access hundreds of metrics and attributes, from basic to advanced. Build and blend custom datasets directly in Dataddo, then send them anywhere.
CAMPOS DE DADOS
Explore os dados que você pode extrair de Xero
Categoria de dados
- Todos os atributos (535)
- Accounts (14)
- Balance Sheet (8)
- Balance Sheet Monthly (7)
- Bank Transactions (26)
- Bank Transfers (11)
- Batch payments (15)
- Contacts (13)
- Credit notes (15)
- Employees (5)
- History invoices (9)
- History payments (9)
- Invoice Line Items (34)
- Invoice Payments (26)
- Invoices (18)
- Items (16)
- Journal Lines (21)
- Journals (5)
- Journals with Tracking (21)
- Linked Transactions (11)
- Manual journals (8)
- Organizations (3)
- Overpayments (18)
- Payments (18)
- Prepayments (18)
- Profit and Loss (7)
- Profit and Loss by Tracking Category (13)
- Projects (35)
- Purchase orders (18)
- Quotes (21)
- Quotes Line Items (31)
- Reports - Aged Receivables Summary (14)
- Reports - Bank summary (10)
- Reports - Budget summary (17)
- Tenants (5)
- Tracking categories (4)
- Trial Balance (11)
Precisa de campos que não vê?
Informe-nos e nós os adicionaremos ao conector. Basta enviar um pedido aqui..
Atributos disponíveis (535)
| Atributo |
|---|
AccountID Account ID |
Code Code |
Name Name |
Type Type |
TaxType Tax Type |
EnablePaymentsToAccount Enable Payments To Account |
BankAccountNumber Bank Account Number |
BankAccountType Bank Account Type |
CurrencyCode Currency Code |
ReportingCode Reporting Code |
ReportingCodeName Reporting Code Name |
Status Account Status |
Description Description |
XeroTenantID Xero Tenant Id |
ReportID Report ID |
ReportName ReportName |
Item Balance Sheet Item |
OpeningBalance Opening Balance |
ClosingBalance Closing Balance |
DateStart Date Start |
DateStop DateStop |
XeroTenantID Xero Tenant Id |
ReportID Report ID |
ReportName ReportName |
DateStart Date Start |
DateStop DateStop |
OpeningBalance Opening Balance |
ClosingBalance Closing Balance |
XeroTenantID Xero Tenant Id |
XeroTenantID Xero Tenant Id |
ContactName confidencial Contact Name |
ContactID Contact ID |
Date Date |
Status Status |
LineAmountTypes Line Amount Types |
LineItemDescription Line Item Description |
LineItemUnitAmount Line Item Unit Amount |
LineItemTaxType Line Item Tax Type |
LineItemTaxAmount Line Item Tax Amount |
LineItemLineAmount Line Item Line Amount |
LineItemAccountCode Line Item Account Code |
LineItemQuantity Line Item Quantity |
LineItemID Line Item ID |
SubTotal Sub Total |
Total Total |
TotalTax Total Tax |
CurrencyCode Currency Code |
BankTransactionID Bank Transaction ID |
BankAccountAccountID Bank Account Account ID |
BankAccountCode Bank Account Code |
BankAccountName Bank Account Name |
Type Type |
Reference Reference |
IsReconciled Is Reconciled |
LineItemTracking Line Item Tracking |
XeroTenantID Xero Tenant Id |
BankTransferID Bank Transfer ID |
Date Date |
CreatedDate Created Date |
FromBankAccountId From Bank Account ID |
FromBankAccountName From Bank Account Name |
ToBankAccountId To Bank Account ID |
ToBankAccountName To Bank Account Name |
Amount Amount |
FromBankTransactionID From Bank Transaction ID |
ToBankTransactionID To Bank Transaction ID |
XeroTenantID Xero Tenant Id |
AccountID Account ID |
Reference Reference |
BatchPaymentID Batch Payment ID |
Date Date |
InvoiceID Invoice ID |
HasErrors Has Errors |
IsDiscounted Is Discounted |
PaymentID Payment ID |
PaymentReference Payment Reference |
PaymentAmount Payment Amount |
Type Type |
Status Status |
TotalAmount Total Amount |
IsReconciled Is Reconciled |
XeroTenantID Xero Tenant Id |
ContactID Contact ID |
ContactStatus Contact Status |
AccountNumber Account Number |
Name confidencial Name |
FirstName confidencial First Name |
LastName confidencial Last Name |
EmailAddress confidencial Email Address |
SkypeUserName Skype User Name |
BankAccountDetails Bank Account Details |
TaxNumber Tax Number |
AccountsReceivableTaxType Accounts Receivable Tax Type |
AccountsPayableTaxType Accounts Payable Tax Type |
XeroTenantID Xero Tenant Id |
ContactID Contact ID |
ContactName confidencial Contact Name |
Date Date |
Status Status |
LineAmountTypes Line Amount Types |
SubTotal Sub Total |
Total Total |
TotalTax Total Tax |
CurrencyCode Currency Code |
Type Type |
CreditNoteID Credit Note ID |
CreditNoteNumber Credit Note Number |
CurrencyRate Currency Rate |
RemainingCredit Remaining Credit |
XeroTenantID Xero Tenant Id |
EmployeeID Employee ID |
Status Status |
FirstName confidencial First Name |
LastName confidencial Last Name |
XeroTenantID Xero Tenant Id |
Id Id |
Status Status |
ProviderName Provider Name |
Changes Changes |
Date Date |
User User |
Details Details |
InvoiceID Invoice ID |
Id Id |
XeroTenantID Xero Tenant Id |
Status Status |
ProviderName Provider Name |
Date Date |
Changes Changes |
User User |
Details Details |
PaymentID Payment ID |
AmountCredited Amount Credited |
AmountDue Amount Due |
AmountPaid Amount Paid |
ContactName confidencial Contact Name |
ContactID Contact ID |
CurrencyCode Currency Code |
CurrencyRate Currency Rate |
Date Date |
UpdatedDate Updated Date |
DueDate Due Date |
InvoiceNumber Invoice Number |
InvoiceID Invoice ID |
Reference Reference |
Status Status |
SubTotal Sub Total |
Total Total |
TotalTax Total Tax |
Type Type |
LineItemDescription Line Item - Description |
LineItemQuantity Line Item - Quantity |
LineItemUnitAmount Line Item - Unit Amount |
LineItemItemCode Line Item - Item Code |
LineItemAccountCode Line Item - Account Code |
LineItemID Line Item - ID |
LineItemTaxType Line Item - Tax Type |
LineItemTaxAmount Line Item - Tax Amount |
LineItemLineAmount Line Item - Line Amount |
LineItemDiscountRate Line Item - Discount Rate |
LineItemDiscountAmount Line Item - Discount Amount |
LineItemTrackingName Line Item - Tracking - Name |
LineItemTrackingOption Line Item - Tracking - Option |
LineItemTrackingCategoryID Line Item - Tracking - CategoryID |
XeroTenantID Xero Tenant Id |
LineAmountTypes Line Amount Types |
XeroTenantID Xero Tenant Id |
AmountCredited Amount Credited |
AmountDue Amount Due |
AmountPaid Amount Paid |
ContactName confidencial Contact Name |
ContactID Contact ID |
CurrencyCode Currency Code |
CurrencyRate Currency Rate |
Date Date |
DueDate Due Date |
InvoiceNumber Invoice Number |
InvoiceID Invoice ID |
Reference Reference |
Status Status |
SubTotal Sub Total |
Total Total |
TotalTax Total Tax |
Type Type |
PaymentAmount Payment - Amount |
PaymentBatchPaymentID Payment - Batch Payment ID |
PaymentCurrencyRate Payment - Currency Rate |
PaymentDate Payment - Date |
PaymentHasAccount Payment - Has Account |
PaymentHasValidationErrors Payment - Has Validation Errors |
PaymentID Payment - ID |
PaymentReference Payment - Reference |
InvoiceID Invoice ID |
XeroTenantID Xero Tenant Id |
AmountCredited Amount Credited |
AmountDue Amount Due |
AmountPaid Amount Paid |
ContactName confidencial Contact Name |
ContactID Contact ID |
CurrencyCode Currency Code |
CurrencyRate Currency Rate |
Date Date |
DueDate Due Date |
InvoiceNumber Invoice Number |
Reference Reference |
Status Status |
SubTotal Sub Total |
Total Total |
TotalTax Total Tax |
Type Type |
XeroTenantID Xero Tenant Id |
ItemID Item ID |
Code Code |
Description Description |
PurchaseDescription Purchase Description |
UpdatedDate Updated Date |
PurchaseDetailsUnitPrice Purchase Details Unit Price |
PurchaseDetailsAccountCode Purchase Details Account Code |
PurchaseDetailsTaxType Purchase Details Tax Type |
SalesDetailsUnitPrice Sales Details Unit Price |
SalesDetailsAccountCode Sales Details Account Code |
SalesDetailsTaxType Sales Details Tax Type |
Name Name |
IsTrackedAsInventory Is Tracked As Inventory |
IsSold Is Sold |
IsPurchased Is Purchased |
XeroTenantID Xero Tenant Id |
AccountCode Account Code |
AccountID Account ID |
AccountName Account Name |
AccountType Account Type |
GrossAmount Gross Amount |
JournalLineID Journal Line ID |
JournalID Journal ID |
JournalNumber Journal Number |
JournalDate Journal Date |
NetAmount Net Amount |
TaxAmount Tax Amount |
SourceID Source ID |
SourceType Source Type |
TaxName Tax Name |
TaxType Tax Type |
Reference Reference |
TrackingCategories_Name Tracking Categories Name |
TrackingCategories_Option Tracking Categories Option |
TrackingCategories_ID Tracking Categories ID |
TrackingCategories_optionID Tracking Categories option ID |
XeroTenantID Xero Tenant Id |
JournalID Journal ID |
JournalNumber Journal Number |
JournalDate Journal Date |
CreatedDate Created Date |
XeroTenantID Xero Tenant Id |
AccountCode Account Code |
AccountID Account ID |
AccountName Account Name |
AccountType Account Type |
GrossAmount Gross Amount |
JournalLineID Journal Line ID |
JournalID Journal ID |
JournalNumber Journal Number |
JournalDate Journal Date |
NetAmount Net Amount |
TaxAmount Tax Amount |
TaxName Tax Name |
TaxType Tax Type |
TrackingCategoryID Tracking Category ID |
TrackingOptionID Tracking Option ID |
TrackingCategoryName Tracking Category Name |
TrackingOption Tracking Option |
SourceID Source ID |
SourceType Source Type |
Reference Reference |
XeroTenantID Xero Tenant Id |
LinkedTransactionID Linked Transaction ID |
SourceTransactionID Source Transaction ID |
SourceLineItemID Source Line Item ID |
ContactID Contact ID |
TargetTransactionID Target Transaction ID |
TargetLineItemID Target Line Item ID |
Status Status |
Type Type |
UpdatedDate Updated Date UTC |
SourceTransactionTypeCode Source Transaction Type Code |
ManualJournalID Manual Journal ID |
XeroTenantID Xero Tenant Id |
Date Date |
Status Status |
LineAmountTypes Line Amount Types |
UpdatedDate Updated Date |
Narration Narration |
HasAttachments Has Attachments |
Name Name |
OrganisationID Organisation ID |
XeroTenantID Xero Tenant Id |
XeroTenantID Xero Tenant Id |
ContactID Contact ID |
ContactName confidencial Contact Name |
Date Date |
Status Status |
LineAmountTypes Line Amount Types |
SubTotal Sub Total |
Total Total |
TotalTax Total Tax |
UpdatedDate Updated Date |
CurrencyCode Currency Code |
Amount Amount |
BankAmount Bank Amount |
Type Type |
OverpaymentID Overpayment ID |
CurrencyRate Currency Rate |
RemainingCredit Remaining Credit |
HasAttachments Has Attachments |
PaymentID Payment ID |
XeroTenantID Xero Tenant Id |
AccountID Account ID |
AccountCode Account Code |
Amount Amount |
BankAmount Bank Amount |
CurrencyRate Currency Rate |
Date Date |
InvoiceNumber Invoice Number |
InvoiceID Invoice ID |
InvoiceContactName Invoice Contact Name |
InvoiceCurrencyCode Invoice Currency Code |
InvoiceIsDiscounted Invoice Is Discounted |
InvoiceType Invoice Type |
PaymentType Payment Type |
Reference Reference |
Status Status |
UpdatedDate Updated Date |
XeroTenantID Xero Tenant Id |
ContactID Contact ID |
ContactName confidencial Contact Name |
Date Date |
Status Status |
LineAmountTypes Line Amount Types |
SubTotal Sub Total |
Total Total |
TotalTax Total Tax |
UpdatedDate Updated Date |
FullyPaidOnDate Fully Paid On Date |
CurrencyCode Currency Code |
Type Type |
CreditNoteID Credit Note ID |
CreditNoteNumber Credit Note Number |
CurrencyRate Currency Rate |
RemainingCredit Remaining Credit |
HasAttachments Has Attachments |
XeroTenantID Xero Tenant Id |
ReportID Report ID |
ReportName Report Name |
Item Item |
Value Value |
DateStart Date Start |
DateStop Date Stop |
ReportDate Report Date |
ReportName Report Name |
ReportTitles Report Titles |
UpdatedDate Updated Date UTC |
AccountName Account Name |
RowLabel Row Label |
RowValue Row Value |
AccountID Account ID |
DateStart Date Start |
DateStop Date Stop |
XeroTenantID Xero Tenant Id |
TrackingCategoryID Tracking Category ID |
TrackingCategoryName Tracking Category Name |
XeroTenantID Xero Tenant Id |
ProjectID Project Id |
ContactID Contact Id |
Name Name |
CurrencyCode Currency Code |
MinutesLogged Minutes Logged |
TotalTaskAmountCurrency Total Task Amount Currency |
TotalTaskAmountValue Total Task Amount Value |
TotalExpenseAmountCurrency Total Expense Amount Currency |
TotalExpenseAmountValue Total Expense Amount Value |
MinutesToBeInvoiced Minutes To Be Invoiced |
TaskAmountToBeInvoicedCurrency Task Amount To Be Invoiced Currency |
TaskAmountToBeInvoicedValue Task Amount To Be Invoiced Value |
TaskAmountInvoicedCurrency Task Amount Invoiced Currency |
TaskAmountInvoicedValue Task Amount Invoiced Value |
ExpenseAmountToBeInvoicedCurrency Expense Amount To Be Invoiced Currency |
ExpenseAmountToBeInvoicedValue Expense Amount To Be Invoiced Value |
ExpenseAmountInvoicedCurrency Expense Amount Invoiced Currency |
ExpenseAmountInvoicedValue Expense Amount Invoiced Value |
ProjectAmountInvoicedCurrency Project Amount Invoiced Currency |
ProjectAmountInvoicedValue Project Amount Invoiced Value |
DepositCurrency Deposit Currency |
DepositValue Deposit Value |
DepositAppliedCurrency Deposit Applied Currency |
DepositAppliedValue Deposit Applied Value |
CreditNoteAmountCurrency Credit Note Amount Currency |
CreditNoteAmountValue Credit Note Amount Value |
TotalInvoicedCurrency Total Invoiced Currency |
TotalInvoicedValue Total Invoiced Value |
TotalToBeInvoicedCurrency Total To Be Invoiced Currency |
TotalToBeInvoicedValue Total To Be Invoiced Value |
Status Status |
EstimateCurrency Etimate Currency |
EstimateValue Etimate Value |
TotalTaskAmountCurrency Total Task Amount Currency |
XeroTenantID Xero Tenant Id |
PurchaseOrderID Purchase Order ID |
PurchaseOrderNumber Purchase Order Number |
Date Date |
DeliveryDate Delivery Date |
AttentionTo confidencial Attention To |
Telephone confidencial Telephone |
Reference Reference |
CurrencyCode Currency Code |
CurrencyRate Currency Rate |
Status Status |
IsDiscounted Is Discounted |
ContactName confidencial Contact Name |
ContactID Contact ID |
SubTotal Sub Total |
Total Total |
TotalTax Total Tax |
Type Type |
QuoteID Quote ID |
QuoteNumber Quote Number |
Reference Reference |
Terms Terms |
ContactID Contact ID |
ContactName confidencial Contact Name |
ContactEmailAddress confidencial Contact Email Address |
ContactFirstName confidencial Contact First Name |
ContactLastName confidencial Contact Last Name |
Date Date |
Status Status |
CurrencyRate Currency Rate |
CurrencyCode Currency Code |
SubTotal Sub Total |
TotalTax Total Tax |
Total Total |
TotalDiscount Total Discount |
Title Title |
Summary Summary |
LineAmountTypes Line Amount Types |
XeroTenantID Xero Tenant Id |
XeroTenantID Xero Tenant Id |
QuoteID Quote ID |
QuoteNumber Quote Number |
Reference Reference |
Terms Terms |
ContactID Contact ID |
ContactName confidencial Contact Name |
ContactEmailAddress confidencial Contact Email Address |
ContactFirstName confidencial Contact First Name |
ContactLastName confidencial Contact Last Name |
Date Date |
Status Status |
CurrencyRate Currency Rate |
CurrencyCode Currency Code |
SubTotal Sub Total |
TotalTax Total Tax |
Total Total |
TotalDiscount Total Discount |
Title Title |
Summary Summary |
LineAmountTypes Line Amount Types |
LineItemID Line Item ID |
LineItemAccountCode Line Item Account Code |
LineItemDescription Line Item Description |
LineItemUnitAmount Line Item Unit Amount |
LineItemDiscountRate Line Item Discount Rate |
LineItemLineAmount Line Item Line Amount |
LineItemItemCode Line Item Item Code |
LineItemQuantity Line Item Quantity |
LineItemTaxAmount Line Item Tax Amount |
LineItemTaxType Line Item Tax Type |
ReportID Report ID |
ReportName Report Name |
Contact Contact |
Date Date |
InvoiceNumber Invoice Number |
DueDate Due Date |
Description Description |
Total Total |
Paid Paid |
Credited Credited |
Due Due |
DateStart Date Start |
DateStop Date Stop |
XeroTenantID Xero Tenant Id |
ReportID Report ID |
ReportName Report Name |
BankAccount Bank Account |
OpeningBalance Opening Balance |
CashReceived Cash Received |
CashSpent Cash Spent |
ClosingBalance Closing Balance |
DateStart Date Start |
DateStop Date Stop |
XeroTenantID Xero Tenant Id |
ReportID Report ID |
ReportName Report Name |
Account Account |
January January |
February February |
March March |
April April |
May May |
June June |
July July |
August August |
September September |
October October |
November November |
December December |
XeroTenantID Xero Tenant Id |
Year Year |
TenantID Tenant ID |
TenantName Tenant Name |
TenantType Tenant Type |
CreatedDate Created Date |
XeroTenantID Xero Tenant Id |
TrackingCategoryID Tracking Category ID |
XeroTenantID Xero Tenant Id |
Name Name |
Status Status |
ReportID Report ID |
ReportName ReportName |
XeroTenantID Xero Tenant Id |
DateStart Date Start |
DateStop Date Stop |
AccountName Account Name |
AccountCode Account Code |
Debit Debit |
Credit Credit |
YTDDebit YTD Debit |
YTDCredit YTD Credit |
Preços
Veja todos os planos do Dataddo
Compare os níveis de preços baseados em fluxos do Dataddo lado a lado e comece seu teste gratuito de 14 dias.
Ver preços
Uma plataforma para conectar todos os seus dados
Veja todos os benefícios da plataforma
Por que Dataddo?
Uma camada de ingestião para SaaS, bancos de dados e arquivos
A maioria das equipes usa várias ferramentas e “código espaguete” para ingestião, dependendo do tipo de fontes e dos padrões de carga. O Dataddo centraliza tudo isso em um único plano de controle e uma estrutura de preços previsível. Mais de 400+ conectores incluídos.
Construído para ambientes cloud e on-premise
Execute o Dataddo tanto na nuvem quanto em configurações híbridas on-premise. O plano de controle permanece na nuvem; seus dados nunca saem do seu perímetro. Suporta redes segmentadas e privadas, além de sistemas legados como DB2, Informix e Sybase.
Controle total via API – sem necessidade de UI
O Dataddo é construído com abordagem API-first. Use a interface quando quiser; ignore completamente quando não precisar e orquestre seus pipelines de forma programática.
Operações de ingestião gerenciadas. Nós garantimos a confiabilidade.
O Dataddo assume a responsabilidade operacional da sua camada de ingestião. Gerenciamos a manutenção dos conectores, lidamos com mudanças de API dos sistemas de origem, monitoramos pipelines proativamente e executamos backfills e recuperação. Sua equipe de engenharia não precisa se preocupar com isso.
Visibilidade completa de cada fluxo de dados
O Dataddo oferece observabilidade total em toda a sua camada de ingestião: logs de pipelines, histórico de execuções, linhagem de dados e trilhas de auditoria. Saiba o que foi movido, quando, o que mudou e por quê. Desenvolvido para ambientes onde explicabilidade e responsabilidade são essenciais.
A base de dados que sua IA precisa
A IA corporativa depende de uma camada de dados governada e segura. O Dataddo consolida dados de SaaS, bancos de dados e arquivos em um pipeline gerenciado unificado, entregando para bancos de dados vetoriais, feature stores e data lakes, com hashing nativo de dados sensíveis.
Estudos de caso
Veja o que outras organizações alcançaram com Dataddo
70%
menos
trabalho de engenharia,
mais tempo analisando dados
37.5%
redução
da conta de
infraestrutura em média
3
semanas de trabalho
economizadas durante a fase
inicial da migração
Como o Livesport ativa dados e economiza recursos de engenharia com BigQuery e Dataddo
Entretenimento
Como a FoodChéri sincroniza o MongoDB com o BigQuery para obter insights mais rápidos, com menos engenharia
Alimentos e bebidas
Como a Sensire acelerou a migração de uma infraestrutura de dados proprietária no local para a nuvem com o Dataddo
Saúde
Depoimentos
Nossos clientes nos amam
Amalia Bornstein
Global Social Content and Marketing Data Analyst
Uber Eats
“A equipe de dados do Uber Eats aprecia a interface amigável do Dataddo, projetada para operação por membros não técnicos da equipe, a fim de minimizar a necessidade de treinamento excessivo para apoiar a entrega eficiente do projeto.”
Andrew Hart
Chief Operations Officer
Sat 7
“Trabalhar com o Dataddo simplificou bastante nossos relatórios e nos deu acesso a dados de tendências e insights que anteriormente não conseguíamos gerar.”
Vahan Petrosayan
Director of IT & Infrastructure
Search Engine Journal
“Com o Dataddo, todas as minhas perguntas são respondidas mais rapidamente…[e é] divertido brincar com dados agora.”
Michael Guntenaar
CTO
ID&T Group
“Dataddo abre portas e elimina os obstáculos de trabalhar com dados.”
Laurent Partouche
CPO
FoodChéri & Seazon
“Escolhemos o Dataddo pela facilidade de uso, pelas transformações automáticas, pela política de preços clara e pela qualidade do relacionamento humano que se estabeleceu desde nossas primeiras trocas.”
Natheer Maloon
Technology Solutions Manager
Boldr
“O suporte da Dataddo provou ser extremamente valioso durante toda a fase de implementação. 9,5 de 10.”
Zdeněk Hejnak
Data Development Team Leader
Livesport
“Economizamos cerca de 70% do tempo que levaria para ingerir todos os nossos dados, ou 3-4 equivalentes em tempo integral, e gastamos muito mais tempo na análise e ativação de dados. Temos apenas um engenheiro de dados em tempo integral, que faz mais do que apenas coletar dados, enquanto nossa equipe de BI é composta por 11 membros.”
Greg Senior
Business Operations Manager
Farm Focus
“Agradecemos toda a ajuda e apoio para nós. Um nível de serviço refrescante de uma empresa de tecnologia! Obrigado!”
