Xero Accounting Endpoint: ContactsExpanded - Revision history

Nic at 23:35, 27 March 2025

2025-03-27T23:35:17Z

← Older revision		Revision as of 18:35, 27 March 2025
Line 13:		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

Nic at 23:35, 27 March 2025

2025-03-27T23:35:00Z

← Older revision		Revision as of 18:35, 27 March 2025
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.

Nic at 23:35, 14 December 2023

2023-12-14T23:35:06Z

← Older revision		Revision as of 18:35, 14 December 2023
Line 56:		Line 56:
	:* '''ACN''' (for Australia)		:* '''ACN''' (for Australia)
	:* '''NZBN''' (for New Zealand)		:* '''NZBN''' (for New Zealand)
	:* '''Business Registration Number'' (for UK)		:* '''Business Registration Number''' (for UK)
	:* '''Business Registration Number''' (for all other regions)		:* '''Business Registration Number''' (for all other regions)

Nic at 23:34, 14 December 2023

2023-12-14T23:34:26Z

← Older revision		Revision as of 18:34, 14 December 2023
Line 53:		Line 53:
	;CompanyNumber		;CompanyNumber
	:A [[Field Type: Text\|text field]] that provides the business registration number of the contact.		:A [[Field Type: Text\|text field]] that provides the business registration number of the contact.
	:This could ~~eithe~~ be:		:This could either be:
	:* '''ACN''' (for Australia)		:* '''ACN''' (for Australia)
	:* '''NZBN''' (for New Zealand)		:* '''NZBN''' (for New Zealand)
Line 61:		Line 61:
	;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 ~~eithe~~ be:		:This could either be:
	:* '''ABN''' (for Australia)		:* '''ABN''' (for Australia)
	:* '''GST Number''' (for New Zealand)		:* '''GST Number''' (for New Zealand)

Nic at 23:34, 14 December 2023

2023-12-14T23:34:12Z

← Older revision		Revision as of 18:34, 14 December 2023
Line 50:		Line 50:
	;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 eithe be:
			:* '''ACN''' (for Australia)
			:* '''NZBN''' (for New Zealand)
			:* '''Business Registration Number'' (for UK)
			:* '''Business Registration Number''' (for all other regions)

	;TaxNumber		;TaxNumber
Line 57:		Line 65:
	:* '''GST Number''' (for New Zealand)		:* '''GST Number''' (for New Zealand)
	:* '''VAT Number''' (for UK)		:* '''VAT Number''' (for UK)
	:* '''Tax ID ~~Nuber~~''' (for all other regions)		:* '''Tax ID Number''' (for all other regions)

	;AccountsReceivableTaxType		;AccountsReceivableTaxType

Jeff: /* Related Endpoints */

2023-01-16T02:08:07Z

Related Endpoints

← Older revision		Revision as of 21:08, 15 January 2023
Line 254:		Line 254:
	== 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 272:
	:[[Xero Accounting Endpoint: RepeatingInvoices\|RepeatingInvoices]]		:[[Xero Accounting Endpoint: RepeatingInvoices\|RepeatingInvoices]]
	:[[Xero Accounting Endpoint: TaxRates\|TaxRates]]		:[[Xero Accounting Endpoint: TaxRates\|TaxRates]]


	== Related Topics ==		== Related Topics ==

Nic at 02:27, 14 October 2021

2021-10-14T02:27:58Z

← Older revision		Revision as of 21:27, 13 October 2021
Line 44:		Line 44:
	;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
Line 76:		Line 79:
	;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.

	~~;Website~~
	~~:A [[Field Type: Text\|text field]] that provides the website url of the contact.~~

	;DefaultCurrency		;DefaultCurrency

Nic at 05:15, 22 September 2021

2021-09-22T05:15:44Z

← Older revision		Revision as of 00:15, 22 September 2021
Line 1:		Line 1:
	== Overview ==		== Overview ==

	The Xero '''Contacts''' [[Endpoints\|endpoint]] allows you to access the complete list of contacts (both customers and suppliers) present within Xero.		The Xero '''Contacts''' [[Xero Accounting Endpoints\|endpoint]] allows you to access the complete list of contacts (both customers and suppliers) present within Xero.

	This endpoints provides access to all fields and details. It is also optimised for larger data files.		This endpoints provides access to all fields and details. It is also optimised for larger data files.
Line 271:		Line 271:
	:[[Xero Accounting Endpoint: RepeatingInvoices\|RepeatingInvoices]]		:[[Xero Accounting Endpoint: RepeatingInvoices\|RepeatingInvoices]]
	:[[Xero Accounting Endpoint: TaxRates\|TaxRates]]		:[[Xero Accounting Endpoint: TaxRates\|TaxRates]]


			== Related Topics ==

			:[[Xero Accounting Models]]
			:[[Xero Accounting Endpoints]]

Nic at 04:19, 22 September 2021

2021-09-22T04:19:50Z

← Older revision		Revision as of 23:19, 21 September 2021
Line 85:		Line 85:

	;Discount		;Discount
	:A [[Field Type: Decimal\|decimal ~~value~~]] that provides the default discount rate provided to this contact.		:A [[Field Type: Decimal\|decimal field]] that provides the default discount rate provided to this contact.

	;BrandingTheme		;BrandingTheme
Line 203:		Line 203:

	;Outstanding		;Outstanding
	:A [[Field Type: Decimal\|decimal ~~value~~]] that provides the total outstanding balance this customer owes.		:A [[Field Type: Decimal\|decimal field]] that provides the total outstanding balance this customer owes.

	;Overdue		;Overdue
	:A [[Field Type: Decimal\|decimal ~~value~~]] that provides the portion of ouststanding balance this customer owes that is overdue.		:A [[Field Type: Decimal\|decimal field]] that provides the portion of ouststanding balance this customer owes that is overdue.


Line 214:		Line 214:

	;Outstanding		;Outstanding
	:A [[Field Type: Decimal\|decimal ~~value~~]] that provides the total outstanding balance owed to this supplier.		:A [[Field Type: Decimal\|decimal field]] that provides the total outstanding balance owed to this supplier.

	;Overdue		;Overdue
	:A [[Field Type: Decimal\|decimal ~~value~~]] that provides the portion of ouststanding balance owed to this supplier that is overdue		:A [[Field Type: Decimal\|decimal field]] that provides the portion of ouststanding balance owed to this supplier that is overdue

Nic at 03:54, 22 September 2021

2021-09-22T03:54:43Z

← Older revision		Revision as of 22:54, 21 September 2021
Line 266:		Line 266:
	:[[Xero Accounting Endpoint: Prepayments\|Prepayments]]		:[[Xero Accounting Endpoint: Prepayments\|Prepayments]]
	:[[Xero Accounting Endpoint: PrepaymentsExpanded\|PrepaymentsExpanded]]		:[[Xero Accounting Endpoint: PrepaymentsExpanded\|PrepaymentsExpanded]]
			:[[Xero Projects Endpoint: Projects\|Projects]]
	:[[Xero Accounting Endpoint: PurchaseOrders\|PurchaseOrders]]		:[[Xero Accounting Endpoint: PurchaseOrders\|PurchaseOrders]]
	:[[Xero Accounting Endpoint: Quotes\|Quotes]]		:[[Xero Accounting Endpoint: Quotes\|Quotes]]
	:[[Xero Accounting Endpoint: RepeatingInvoices\|RepeatingInvoices]]		:[[Xero Accounting Endpoint: RepeatingInvoices\|RepeatingInvoices]]
	:[[Xero Accounting Endpoint: TaxRates\|TaxRates]]		:[[Xero Accounting Endpoint: TaxRates\|TaxRates]]

← Older revision		Revision as of 22:54, 21 September 2021
Line 266:		Line 266:
	:[[Xero Accounting Endpoint: Prepayments\|Prepayments]]		:[[Xero Accounting Endpoint: Prepayments\|Prepayments]]
	:[[Xero Accounting Endpoint: PrepaymentsExpanded\|PrepaymentsExpanded]]		:[[Xero Accounting Endpoint: PrepaymentsExpanded\|PrepaymentsExpanded]]
			:[[Xero Projects Endpoint: Projects\|Projects]]
	:[[Xero Accounting Endpoint: PurchaseOrders\|PurchaseOrders]]		:[[Xero Accounting Endpoint: PurchaseOrders\|PurchaseOrders]]
	:[[Xero Accounting Endpoint: Quotes\|Quotes]]		:[[Xero Accounting Endpoint: Quotes\|Quotes]]
	:[[Xero Accounting Endpoint: RepeatingInvoices\|RepeatingInvoices]]		:[[Xero Accounting Endpoint: RepeatingInvoices\|RepeatingInvoices]]
	:[[Xero Accounting Endpoint: TaxRates\|TaxRates]]		:[[Xero Accounting Endpoint: TaxRates\|TaxRates]]