BulkImportProgramMembers
Imports the program member records from the provided file, waits for the job to finish and returns the job completion details.
Execute
Sample EXECUTE BulkImportProgramMembers ProgramId=6145, ProgramMemberStatus='Influenced', LocalPath='C:/users/cdata/file.csv'
EXECUTE BulkImportProgramMembers ProgramId=6145, ProgramMemberStatus='Influenced', LocalPath='/tmp/file.csv'
EXECUTE BulkImportProgramMembers ProgramId=6145, ProgramMemberStatus='Influenced', FileData='Zmlyc3ROYW1lLGxhc3ROYW1lLGVtYWlsLHRpdGxlLGNvbXBhbnksbGVhZFNjb3JlCkpvYW5uYSxMYW5uaXN0ZXIsSm9hbm5hQExhbm5pc3Rlci5jb20sTGFubmlzdGVyLEhvdXNlIExhbm5pc3RlciwwClR5d2luLExhbm5pc3RlcixUeXdpbkBMYW5uaXN0ZXIuY29tLExhbm5pc3RlcixIb3VzZSBMYW5uaXN0ZXIsMA=='
Input
| Name | Type | Required | Description |
| ProgramId | Integer | True | Id of the program to add members to. |
| ProgramMemberStatus | String | True | Program member status for members being added. |
| Format | String | False | Format of the import file. Available values are: CSV, TSV, SSV
使用できる値は次のとおりです。CSV, TSV, SSV デフォルト値はCSVです。 |
| LocalPath | String | False | The absolute path of the file to import. |
| FileData | String | False | Base64 string representation of the CSV content. Only used if LocalPath and InputStream are not set. |
Result Set Columns
| Name | Type | Description |
| Id | String | The Id of the import job. |
| Status | String | The status of the import process. |
| RowsProcessed | Integer | The number of rows processed so far. |
| RowsFailed | Integer | The number of rows failed so far. |
| RowsWithWarning | Integer | The number of rows with a warning so far. |
| Message | String | The status message of the batch. |
| Success | Boolean | Boolean indicating if the procedure was executed successfully. If false, the output parameter 'Details' will contain the failure details. |
| Details | String | Details of execution failure. NULL if success=true. |