Xero Accounting Endpoint: Items
Overview
The Xero Items endpoint allows you to access the list items that can be included on Invoices.
Note that an alternate endpoint named ItemsTable is available which provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory.
Fields
The following fields are available for the Items endpoint.
- DataFile
- A record field that identifies the source data file for this record.
- ItemID
- A GUID field representing the internal id of an item.
- This field can be used to link to other endpoints.
- Code
- A text field that provides the unique item code.
- This field can be used to link to other endpoints.
- Name
- A text field provides the name of the item.
- IsSold
- A true/false value that indicates if the item can be included on customer invoices.
- IsPurchased
- A true/false value that indicates if the item can be included on supplier invoices.
- Description
- A text field provides the description of the item.
- PurchaseDescription
- A text field provides the purchase description of the item.
- PurchaseDetails
- A record field provides further information for purchases.
- See PurchaseDetails Fields for more information.
- SalesDetails
- A record field provides further information for sales.
- See SalesDetails Fields for more information.
- IsTrackedAsInventory
- A true/false value that indicates if the item is tracked for inventory purposes.
- InventoryAssetAccountCode
- A text field that provides the account code used for inventory management.
- TotalCostPool
- A decimal field that provides total value of items currently in stock.
- QuantityOnHand
- A decimal field that provides total quantity on hand of items currently in stock.
- UpdatedDateUTC
- A date time field that indicates the last time this record was updated.
PurchaseDetails Fields
The PurchaseDetails Fields include the following sub fields.
- UnitPrice
- A decimal field that provides default unit price when purchasing this item.
- AccountCode
- A text field that provides the account code used when purchasing this item.
- COGSAccountCode
- A text field that provides the cost of sales account code used when selling this item.
- TaxType
- A text field that provides the tax type used when purchasing this item.
SalesDetails Fields
The SalesDetails Fields include the following sub fields.
- UnitPrice
- A decimal field that provides default unit price when selling this item.
- AccountCode
- A text field that provides the account code used when selling this item.
- TaxType
- A text field that provides the tax type used when selling this item.
Xero API
For a detailed run through of the endpoint, you can see the Xero API.
Related Fields
Related Endpoints
- Accounts
- BankTransactionsExpanded
- CreditNotesExpanded
- InvoicesExpanded
- ItemsTable
- PurchaseOrders
- Quotes
- RepeatingInvoices
- TaxRates