Users
Allows querying the list of users in a Xero organization. It includes user details like name, role, and access permissions, which are crucial for managing user access to financial data.
Table Specific Information
The Users table allows you to SELECT users for a Xero organization.
SELECT
The Xero API allows extensive filtering and ordering. You can define WHERE and ORDER BY clauses in a query to filter and order the results using any non-line-item column.
Note: The Xero API does not support filtering on line items or journal lines.
Columns
| Name | Type | Description |
| UserId [KEY] | String | The unique identifier for the user within Xero. |
| FirstName | String | The user's first name. |
| LastName | String | The user's last name. |
| EmailAddress | String | The user's email address, used for communication and login. |
| UpdatedDateUTC | Datetime | Timestamp indicating when the user record was last updated in UTC format. |
| IsSubscriber | Boolean | Indicates whether the user is the primary subscriber of the Xero organisation. |
| OrganisationRole | String | The role of the user within the organisation. Possible values include: 'READONLY', 'INVOICEONLY', 'STANDARD', 'FINANCIALADVISER', 'MANAGEDCLIENT', and 'CASHBOOKCLIENT'. |
| TenantId | String | The ID of the tenant to query instead of the default connection tenant, if different. |