Users
Lists user data based on the search criteria.
Table Specific Information
Select
The adapter uses the SAP Concur APIs to process filters that refer either to LoginId or to any combination of PrimaryEmail, EmployeeID, LastName, and Active. The adapter processes other filters client-side within the adapter.
For example, the following queries are processed server side:
SELECT * FROM Users WHERE LoginId='user@user.com' SELECT * FROM Users WHERE PrimaryEmail='userEmail@user.com' AND EmployeeID = 'sampleEmployeeID' AND LastName='sampleLastName' AND Active = 'true'
Columns
| Name | Type | References | Description |
| ID [KEY] | String | The unique identifier of the resource. | |
| EmployeeID | String | The employee ID of the user. | |
| LoginId | String | The login ID of the user. | |
| MiddleName | String | The middle name of the user. | |
| Active | Bool | Indicates whether the user is currently active or not. | |
| CellPhoneNumber | String | The cell phone number of the user. | |
| FirstName | String | The first name of the user. | |
| LastName | String | The last name of the user. | |
| OrganizationUnit | String | The organization unit of the user. | |
| PrimaryEmail | String | The primary email of the user. | |
| URI | String | The URI to the resource. |