ImportProgramMembersFromFile
Imports program members from a file into Marketo.
Stored Procedure Specific Information
The 'File' parameter must be a path to a file formatted as specified in the 'Format' parameter.
The first row in the file will be the columns, which are the Marketo API field names and map directly to the column names for the Leads table. The remaining rows will be the Program Members data you want to import into Marketo.
The maximum file size is 10 MB and all the processing is performed on the Marketo back-end which creates faster performance and less work for the local machine.
GetImportProgramMembersFailures, GetImportProgramMembersStatus, and GetImportProgramMembersWarnings are related stored procedures that provide information on the import process.
EXECUTE ImportProgramMembersFromFile ProgramId = '1089', ProgramMemberStatus = 'Member', File = 'C:\Dev\tests\v20\ProviderMarketo\importprogrammembers.csv'
Input
| Name | Type | Required | Description |
| File | String | False | The path to the file containing program members to be imported into Marketo, i.e. 'C:\temp\importprogrammembers.csv'. |
| ProgramId | String | True | The Id of the program |
| ProgramMemberStatus | String | True | Program member status for members being added. |
| Format | String | False | The format of the file that will be used to import program members into Marketo.
The allowed values are csv, tsv, ssv. |
Result Set Columns
| Name | Type | Description |
| BatchId | String | The Id of the import program members batch. |
| ImportId | String | The Id of the import job. |
| Status | String | The status of the import process. |