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 |
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 |