Back to Tables
Contacts 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
Name
FirstName
LastName
Email
Phone
Mobile
AccountNumber
ContactStatus
IsSupplier
IsCustomer
TaxNumber
DefaultCurrency
Website
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