AcquireUser
This will acquire users registered in Sansan
ビュー固有の情報
Select
connector はSansan API を使用して、以下のカラムと演算子で構成されたWHERE 句の条件を処理します。Delimiter フィルタはサーバー側でサポートされており、残りのフィルタはドライバー内のクライアント側で実行されます。例えば、以下のクエリはサーバー側で処理されます。
- Delimiter は'=' 比較をサポートします。
SELECT * FROM AcquireUser SELECT * FROM AcquireUser WHERE Delimiter='comma'
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 |