SSIS Components for Certinia

Build 25.0.9434

CreateJob

Initiates a new Salesforce job for processing bulk data operations.

Input

Name Type Description
ObjectName String API name of the Salesforce object the job will operate on, such as Account, Campaign, or a custom object.
Action String Specifies the operation the job will perform, such as insert, update, upsert, delete, or query.
ConcurrencyMode String Defines how batches in the job will be processed. Use 'Parallel' (default) for faster processing or 'Serial' to avoid database contention by processing one batch at a time.

The allowed values are Parallel, Serial.

The default value is Parallel.

ContentType String Format of the job data. Valid values include CSV, XML, ZIP_CSV, and ZIP_XML.

The default value is XML.

ExternalIdColumn String Name of the external ID field used for matching records during an upsert operation.
ChunkSize String Recommended for queries on large datasets. Specifies the number of records per batch when splitting a query job into multiple parts. Used only when Action is set to 'query'.

Result Set Columns

Name Type Description
ID String Unique identifier of the newly created job.
JobID String Alias for the job ID returned after creation.
ObjectName String Name of the object associated with the job, confirming the object used in the request.
Operation String Operation type defined for the job, such as query, insert, delete, or upsert.
ApiVersion String Salesforce API version used when the job was created. Determines which fields and operations are supported.
ApexProcessingTime String Time in milliseconds spent executing Apex triggers and automation during batch processing. Does not include asynchronous Apex. Available from API version 19.0 onward.
ApiActiveProcessingTime String Total time actively spent processing the job, excluding queue and serialization time. Includes Apex processing time. Available from API version 19.0 onward.
AssignmentRuleId String ID of a specific lead or case assignment rule applied during the job's execution.
ConcurrencyMode String Indicates whether the job used 'parallel' or 'serial' batch processing mode.
ContentType String Format of the job content used during submission. Confirmed value from the job setup.
CreatedById String ID of the Salesforce user who created the job.
CreatedDate String Timestamp when the job was created in the Salesforce system (UTC).
ExternalIdFieldName String Name of the external ID field used to identify matching records in an upsert operation.
NumberBatchesCompleted String Total number of batches that have successfully completed processing in the job.
NumberBatchesQueued String Number of batches that are currently in the job's processing queue.
NumberBatchesFailed String Number of batches that failed during processing in the job.
NumberBatchesInProgress String Number of batches actively being processed in the job at the time of the request.
NumberBatchesTotal String Cumulative total of all batches added to the job. Finalized when the job reaches a terminal state such as Closed or Failed.
NumberRecordsFailed String Total number of records that failed to process in the job. Available in API version 19.0 and later.
NumberRecordsProcessed String Total number of records successfully processed in the job so far.
NumberRetries String Number of retry attempts Salesforce made while saving results, usually due to issues like record locking.
State String Current state of the job. Possible values include 'Open', 'Closed', 'Aborted', or 'Failed'.
SystemModStamp String Timestamp (UTC) of the last update or modification made to the job record.
TotalProcessingTime String Total time in milliseconds spent processing all batches in the job. Does not include queue time. Available in API version 19.0 and later.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434