CreateProgramMembersImportJob
Imports the program member records from the provided file.
Execute
Sample EXECUTE CreateProgramMembersImportJob ProgramId=6145, ProgramMemberStatus='Influenced', LocalPath='C:/users/cdata/file.csv'
EXECUTE CreateProgramMembersImportJob ProgramId=6145, ProgramMemberStatus='Influenced', LocalPath='/tmp/file.csv'
EXECUTE CreateProgramMembersImportJob ProgramId=6145, ProgramMemberStatus='Influenced', FileData='Zmlyc3ROYW1lLGxhc3ROYW1lLGVtYWlsLHRpdGxlLGNvbXBhbnksbGVhZFNjb3JlCkpvYW5uYSxMYW5uaXN0ZXIsSm9hbm5hQExhbm5pc3Rlci5jb20sTGFubmlzdGVyLEhvdXNlIExhbm5pc3RlciwwClR5d2luLExhbm5pc3RlcixUeXdpbkBMYW5uaXN0ZXIuY29tLExhbm5pc3RlcixIb3VzZSBMYW5uaXN0ZXIsMA=='
Input
| Name | Type | Required | Accepts Input Streams | Description |
| ProgramId | Integer | True | False | Id of the program to add members to. |
| ProgramMemberStatus | String | True | False | Program member status for members being added. |
| Format | String | False | False | Format of the import file. Available values are: CSV, TSV, SSV
使用できる値は次のとおりです。CSV, TSV, SSV デフォルト値はCSVです。 |
| LocalPath | String | False | False | The absolute path of the file to import. |
| InputStream | Binary | False | True | An instance of an input stream where file data is read from. Only used if LocalPath is not set. |
| FileData | String | False | False | Base64 string representation of the CSV content. Only used if LocalPath and InputStream are not set. |
| PollingInterval | Integer | False | False | In case the job queue is full Marketo will throw an error. We will keep trying to enqueue the job until the queue is freed. This value specifies the time in milliseconds between each poll. Set to -1 to simply throw the error instead of retrying. If not specified the value provided in the connection string will be used. See JobPollingInterval connection property for more information and the default value. |
Result Set Columns
| Name | Type | Description |
| Id | String | The Id of the import job. |
| Status | String | The status of the import process. |
| 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. |