SSIS Components for Sansan

Build 24.0.9062

AcquireDepartment

This will acquire departments registered in Sansan

Columns

Name Type Description
TempId String This is the temporary identifier used when adding departments
DepartmentId String This is the department identifier
DepartmentName String This is the departments name
DepartmentNamePhonetic String If the departments name is not written alphabetically, you can enter the phonetic alphabetic reading of the name here
ParentDepartmentId String This is the identifier for a parent department
Order Integer This is the display order of the department
DeleteFlag Integer This is the flag used to delete departments

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