ODBC Driver for Marketo

Build 23.0.8839

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839