BulkImportLeads
Imports the lead records from the provided file, waits for the job to finish and returns the job completion details.
Execute
Sample EXECUTE BulkImportLeads LocalPath='C:/users/cdata/file.csv'
EXECUTE BulkImportLeads LocalPath='/tmp/file.csv'
EXECUTE BulkImportLeads LookupField='testCustomfieldEmail', ListId=1570, PartitionName='testPartition', LocalPath='/tmp/file.csv'
EXECUTE BulkImportLeads 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. |
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. |