CreateJobV2
Creates a new job for asynchronous data processing in Salesforce, supporting bulk API operations.
Input
| Name | Type | Description |
| ObjectName | String | API name of the Salesforce object the job will operate on, such as Account, Lead, or Opportunity. |
| Query | String | Salesforce Object Query Language (SOQL) query string to execute for data retrieval. Required only when Action is set to 'query'. |
| Action | String | Specifies the type of operation the job will perform. Valid values are 'insert', 'delete', 'update', 'upsert', or 'query'. |
| ExternalIdColumn | String | API name of the external ID field used to match records for upsert operations. Required for 'upsert' jobs only. |
| ColumnDelimiter | String | Defines the character used to separate columns in the CSV file. Default is 'COMMA'. Other valid values: 'BACKQUOTE', 'CARET', 'PIPE', 'SEMICOLON', 'TAB'. |
| LineEnding | String | Specifies the line break format used in the CSV file. Valid values are 'LF' (Line Feed) and 'CRLF' (Carriage Return + Line Feed). Default is 'LF'. |
| MultiPartRequest | Boolean | Set to 'true' when uploading CSV data in a multi-part request. This is only valid when the data is under 20,000 characters and a file path is provided. |
| CSVFilePath | String | Full file path to the CSV file containing job data. Required when using a multi-part request. |
Result Set Columns
| Name | Type | Description |
| ID | String | Unique identifier for the job created in Salesforce. |
| State | String | Current state of the job. Possible values include 'Open', 'Closed', 'Aborted', or 'Failed'. |
| JobType | String | Indicates the job type. Options include 'BigObjectIngest', 'Classic', or 'V2Ingest'. |
| ContentUrl | String | URL to use for uploading job data. Only available while the job is in 'Open' state. |
| ContentType | String | Format of the job data. Only 'CSV' is supported for V2 jobs. |
| CreatedDate | String | Timestamp in UTC when the job was created. |
| CreatedById | String | Salesforce user ID of the person who created the job. |
| ConcurrencyMode | String | Specifies whether the job uses 'parallel' or 'serial' processing for data batches. |
| SystemModStamp | String | UTC timestamp of the last system update to the job, typically when it finished processing. |