BulkImportCustomObjects
Imports the custom object records from the provided file, waits for the job to finish and returns the job completion details.
Execute
Sample EXECUTE BulkImportCustomObjects Table='CustomObject_customObject_cdatajp', LocalPath='C:/users/cdata/file.csv'
EXECUTE BulkImportCustomObjects Table='CustomObject_customObject_cdatajp', LocalPath='/tmp/file.csv'
EXECUTE BulkImportCustomObjects Table='CustomObject_customObject_cdatajp', FileData='bWFpbEFkZHJlc3MsbmFtZQpzdXBwb3J0X2NkYXRhLmNvLmpwMUBjZHRhLmNvbSxjZGF0YTE3CnN1cHBvcnRfY2RhdGEuY28uanAyQGNkdGEuY29tLGNkYXRhMTg='
Input
Name | Type | Required | Description |
Table | String | True | The custom object table name. |
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. |