Back to TablesContacts Table
Export all contacts (customers and suppliers) from Xero with filtering by type and status.
Parameters
| Parameter | Required | Description |
|---|
| Contact Type | No | All Contacts, Customers Only, or Suppliers Only |
| Include Archived | No | Include archived contacts (default: Active only) |
Columns
| Column | Description |
|---|
| Name | Contact/company name |
| FirstName | First name (if individual) |
| LastName | Last name (if individual) |
| Email | Email address |
| Phone | Phone number (DEFAULT type) |
| Mobile | Mobile number |
| AccountNumber | Your account number for this contact |
| ContactStatus | ACTIVE or ARCHIVED |
| IsSupplier | Whether contact is a supplier (TRUE/FALSE) |
| IsCustomer | Whether contact is a customer (TRUE/FALSE) |
| TaxNumber | Tax/VAT number |
| DefaultCurrency | Default currency code |
| BankAccountDetails | Bank details |
| Website | Website URL |
| SkypeUserName | Skype username |
| ContactID | Xero unique identifier |
Plus OrgID, OrgName, and Timestamp columns.
Type Filters
| Filter | Description |
|---|
| All Contacts | Returns all customers and suppliers (default) |
| Customers Only | Returns only contacts marked as customers |
| Suppliers Only | Returns only contacts marked as suppliers |
Note: A contact can be both a customer and supplier. Use the IsCustomer and IsSupplier columns to identify dual-role contacts.
Tips
- Use Customers Only for customer mailing lists
- Include Archived to find contacts that may have been accidentally archived
- Combine with Invoices table to match contact details with transactions