UploadJobDataV2
Uploads a CSV file as job data for processing within Salesforce bulk operations.
Stored Procedure-Specific Information
This stored procedure uploads data to a Bulk API V2 job in Salesforce. Use this after creating a job with CreateJobV2 to add the records to be processed.Upload CSV data from a file
To upload data from a CSV file:
EXEC UploadJobDataV2 ContentUrl = 'services/data/v43.0/jobs/ingest/7507a00000HHOZiAAP/batches', FullPath = 'C:\\data\\records.csv'
Upload CSV data directly
To upload CSV data as a string:
EXEC UploadJobDataV2 ContentUrl = 'services/data/v43.0/jobs/ingest/7507a00000HHOZiAAP/batches', CSVData = 'Id,Name\n001xx000003DGb2,Test Account'
Note: You must specify either FullPath or CSVData to provide the data to upload. The ContentUrl is obtained from the CreateJobV2 stored procedure response.
Input
| Name | Type | Description |
| ContentUrl | String | The Salesforce-generated URL used to upload job data for a bulk job. This URL is provided when the job is created and must be used while the job remains in Open state. |
| CSVFilePath | String | The full file path to the local CSV file containing the data to be uploaded to the job. Required if Content is not specified. |
Result Set Columns
| Name | Type | Description |
| Uploaded | String | Returns 'true' if the job data was successfully uploaded to Salesforce for processing. |