Excel Add-In for SAP Concur

Build 24.0.9060

Users

Lists user data based on the search criteria.

Table Specific Information

Select

The add-in uses the SAP Concur APIs to process filters that refer either to LoginId or to any combination of PrimaryEmail, EmployeeID, LastName, and Active. The add-in processes other filters client-side within the add-in. For example, the following queries are processed server side:

SELECT * FROM Users WHERE LoginId = '[email protected]'  
SELECT * FROM Users WHERE PrimaryEmail = '[email protected]' AND EmployeeID = 'sampleEmployeeID' AND LastName = 'sampleLastName' AND Active = 'true'

Columns

Name Type 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 Boolean 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060