ODBC Driver for SAP Concur

Build 23.0.8791

Users

Lists user data based on the search criteria.

テーブル固有の情報

Select

本製品 はSAP Concur API を使用して、LoginId を参照するフィルタ、またはPrimaryEmail、EmployeeID、LastName、Active の任意の組み合わせのいずれかを参照するフィルタを処理します。本製品 はクライアント側で本製品 内で他のフィルタを処理します。 例えば、次のクエリはサーバー側で処理されます。

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.

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