CreateLeadsImportJob
Imports the lead records from the provided file.
Execute
Sample EXECUTE CreateLeadsImportJob LocalPath='C:/users/cdata/file.csv'
EXECUTE CreateLeadsImportJob LocalPath='/tmp/file.csv'
EXECUTE CreateLeadsImportJob LookupField='testCustomfieldEmail', ListId=1570, PartitionName='testPartition', LocalPath='/tmp/file.csv'
EXECUTE CreateLeadsImportJob FileData='ZW1haWwsZmlyc3ROYW1lLGxhc3ROYW1lLHRlc3RDdXN0b21maWVsZEVtYWlsCnRlc3RAZXhhbXBsZS5jb20sSm9obixEb2UsdGVzdEB0ZXN0Q3VzdG9tZmllbGRFbWFpbC5jZGF0YS5jb20KdGVzdDEyMzFAZXhhbXBsZS5jb20sSm9obixEb2UsdGVzdDFAdGVzdEN1c3RvbWZpZWxkRW1haWwuY2RhdGEuY29t'
Input
| Name | Type | Required | Description |
| LookupField | String | False | Field to use for deduplication. Custom fields (string, email, integer), and the following field types are supported: id, cookies, email, twitterId, facebookId, linkedInId, sfdcAccountId, sfdcContactId, sfdcLeadId, sfdcLeadOwnerId, sfdcOpptyId. Default is email. You can use id for update only operations. |
| PartitionName | String | False | Name of the lead partition to import to. |
| ListId | Integer | False | Id of the static list to import into. |
| Format | String | False | Format of the import file. Available values are: CSV, TSV, SSV
The allowed values are CSV, TSV, SSV. The default value is 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. |
| PollingInterval | Integer | 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. |