JDBC Driver for Sansan

Build 24.0.9062

AcquireUser

This will acquire users registered in Sansan

Columns

Name Type Description
TempId String This is the temporary identifier used when adding users
UserUuid String This is the identifier to uniquely identify a user in Sansan
DepartmentId String This is the identifier for the department that the user belongs to
UserId String This is the identifier for display that uniquely identifies a user in Sansan
UserName String This is the users name
AlternativeName String This can use be used for alternative names or foreign language names
Email String This is the users email address
SubEmail String This is the users sub-email address
EffectiveDateFrom String This is the date when Sansan usage started
Culture Integer This is the display language when using Sansan
MailFormat Integer This is the format for receiving emails
SamlNameId String This is the identifier for SAML authentication
UserType Integer This is the user type
CanUpdateData Integer This is the permission to update all data
DataDownloadPrivilege Integer This is the permission to download business cards and reports
EmailDeliveryPrivilege Integer This is the permission to use email delivery
SalesforceIntegrationPrivilege Integer This is the permission to link business card data with Salesforce
DealPrivilege Integer This is the permission to use Deal management
ApiIntegrationPrivilege Integer This is the permission to use API linking
UsageStatisticsPrivilege Integer This is the permission to check actual usage of Sansan
OrganizationTreeDownloadPrivilege Integer Input 1 to give this permission
DeleteFlag Integer This is the flag used to delete users

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
Delimiter String Separator in the CSV format response

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