Users
Query users for a Xero organisation.
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 Xero identifier of the user. |
| FirstName | String | First name of the user. |
| LastName | String | Last name of the user. |
| EmailAddress | String | Email address of the user. |
| UpdatedDateUTC | Datetime | Timestamp of the last change to the user record. |
| IsSubscriber | Boolean | Indicates if the user is the subscriber. |
| OrganisationRole | String | Organisation role of the user, values include READONLY, INVOICEONLY, STANDARD, FINANCIALADVISER, MANAGEDCLIENT, and CASHBOOKCLIENT. |
| TenantId | String | The ID of the tenant to query instead of the connection tenant |