Users
Retrieve all users in an account.
Table Specific Information
Select
The User view gathers a comprehensive list of all users associated with a specific account.
The connector uses the Quickbase API to process filters on EmailAddress, AccountId, or AppIds. Other filters are processed client-side.
For example, the following queries are processed server side:
SELECT * FROM [Users]
SELECT * FROM [Users] WHERE [EmailAddress] IN ('[email protected]', '[email protected]')
SELECT * FROM [Users] WHERE [AccountId] = 1
SELECT * FROM [Users] WHERE [AppIds] IN ('bu99sj2wn', 'bvadwmxrn')
Columns
| Name | Type | References | SupportedOperators | Description |
| HashId [KEY] | String | The hashId of the user. | ||
| UserName | String | The username of the user. | ||
| FirstName | String | The first name of the user. | ||
| LastName | String | The last name of the user. | ||
| EmailAddress | String | =,IN | The email address of the user. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| AccountId | Int64 | The account id being used to get users. If no value is specified, the first account associated with the requesting user token is chosen. | |
| AppIds | String | When provided, the returned users will be narrowed down only to the users assigned to the app id's provided in this list. The provided app id's should belong to the same account. |