Xero Accounting Endpoint: ContactsExpanded: Difference between revisions
No edit summary |
No edit summary |
||
| (6 intermediate revisions by 2 users not shown) | |||
| Line 6: | Line 6: | ||
In most situations, it is recommended to use this endpoint instead of the [[Xero Accounting Endpoint: Contacts|Contacts]] endpoint. | In most situations, it is recommended to use this endpoint instead of the [[Xero Accounting Endpoint: Contacts|Contacts]] endpoint. | ||
Note an alternate endpoint named [[Xero Accounting Endpoint: ContactsExpandedTable|ContactsExpandedTable]] is available which provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory. | |||
| Line 11: | Line 13: | ||
The following fields are available for the Accounts endpoint. | The following fields are available for the Accounts endpoint. | ||
;DataFile | |||
:A [[Field Type: Record|record field]] that identifies the [[Field: DataFiles|source data file]] for this record. | |||
;ContactID | ;ContactID | ||
| Line 44: | Line 49: | ||
;SkypeUserName | ;SkypeUserName | ||
:A [[Field Type: Text|text field]] that provides the skype user name of the contact. | :A [[Field Type: Text|text field]] that provides the skype user name of the contact. | ||
;Website | |||
:A [[Field Type: Text|text field]] that provides the website url of the contact. | |||
;BankAccountDetails | ;BankAccountDetails | ||
:A [[Field Type: Text|text field]] that provides the bank account number of the contact. | :A [[Field Type: Text|text field]] that provides the bank account number of the contact. | ||
;CompanyNumber | |||
:A [[Field Type: Text|text field]] that provides the business registration number of the contact. | |||
:This could either be: | |||
:* '''ACN''' (for Australia) | |||
:* '''NZBN''' (for New Zealand) | |||
:* '''Business Registration Number''' (for UK) | |||
:* '''Business Registration Number''' (for all other regions) | |||
;TaxNumber | ;TaxNumber | ||
:A [[Field Type: Text|text field]] that provides the tax number of the contact. | :A [[Field Type: Text|text field]] that provides the tax number of the contact. | ||
:This could | :This could either be: | ||
:* '''ABN''' (for Australia) | :* '''ABN''' (for Australia) | ||
:* '''GST Number''' (for New Zealand) | :* '''GST Number''' (for New Zealand) | ||
:* '''VAT Number''' (for UK) | :* '''VAT Number''' (for UK) | ||
:* '''Tax ID | :* '''Tax ID Number''' (for all other regions) | ||
;AccountsReceivableTaxType | ;AccountsReceivableTaxType | ||
| Line 76: | Line 92: | ||
;IsCustomer | ;IsCustomer | ||
:A [[Field Type: Boolean|true/false value]] that indicates if this contact can be used on sales. | :A [[Field Type: Boolean|true/false value]] that indicates if this contact can be used on sales. | ||
;DefaultCurrency | ;DefaultCurrency | ||
| Line 254: | Line 267: | ||
== Related Endpoints == | == Related Endpoints == | ||
:[[Xero Accounting Endpoint: Contacts|Contacts]] | |||
:[[Xero Accounting Endpoint: Accounts|Accounts]] | :[[Xero Accounting Endpoint: Accounts|Accounts]] | ||
:[[Xero Accounting Endpoint: BankTransactions|BankTransactions]] | :[[Xero Accounting Endpoint: BankTransactions|BankTransactions]] | ||
| Line 271: | Line 285: | ||
:[[Xero Accounting Endpoint: RepeatingInvoices|RepeatingInvoices]] | :[[Xero Accounting Endpoint: RepeatingInvoices|RepeatingInvoices]] | ||
:[[Xero Accounting Endpoint: TaxRates|TaxRates]] | :[[Xero Accounting Endpoint: TaxRates|TaxRates]] | ||
== Related Topics == | == Related Topics == | ||