SalesforceBulkV2 Connector Reference¶ The following operations allow you to work with the Salesforce Bulk V2 Connector. Click an operation name to see parameter details and samples on how to use it. Salesforce Bulk API uses the OAuth protocol to allow application users to securely access data without having to reveal their user credentials. For more information on how authentication is done in Salesforce, see Understanding Authentication. Bulk API 2.0 Connector Connector Configuration¶ Connection configurationIn the 'Properties' section of each operation, users can configure connection-related information. Once the configuration is created, it can be reused in other operations. Parameter Name Description Required Salesforce Configuration Name Name of the configuration. Yes Instance URL Salesforce instance url. Yes Client ID Salesforce connected app's client id. No. Connector will renew the access token if it gets 4xx response and clientId, clientSecret, refreshToken are configured. Client Secret Salesforce connected app's client secret. No. Connector will renew the access token if it gets 4xx response and clientId, clientSecret, refreshToken are configured. Refresh Token Salesforce connected app's refresh token. No. Connector will renew the access token if it gets 4xx response and clientId, clientSecret, refreshToken are configured. Access Token Salesforce connected app's access token. Optional if clientId, clientSecret, refreshToken are configured. Required otherwise. Note: It is recommended to use the OAuth client credentials (Client ID and Client Secret) along with the Refresh Token instead of Access Token. Bulk API 2.0 Ingest¶ salesforce_bulkapi_v2.abortJobThe salesforce_bulkapi_v2.abortJob operation aborts a bulk ingest job in Salesforce using Salesforce Bulk API v2. See the related API documentation for more information. Parameter Name Description Required Salesforce configuration The Salesforce configuration to store OAuth related data. Yes Job ID Bulk job ID Yes salesforce_bulkapi_v2.createJobThe salesforce_bulkapi_v2.createJob operation creates a bulk ingest job in Salesforce using Salesforce Bulk API v2. See the related API documentation for more information. Parameter Name Description Required Salesforce configuration The Salesforce configuration to store OAuth related data. Yes Operation The ID of an assignment rule to run for a Case or a Lead. The assignment rule can be active or inactive. The ID can be retrieved by using the Lightning Platform SOAP API or the Lightning Platform REST API to query the AssignmentRule object. Yes Object The object type for the data being processed. Use only a single object type per job. Yes Column Delimeter The column delimiter used for CSV job data. The default value is COMMA. Valid values are: BACKQUOTE—backquote character (``) CARET—caret character (^) COMMA—comma character (,) which is the default delimiter PIPE—pipe character (|) SEMICOLON—semicolon character (;) TAB—tab character Yes Line Ending The line ending used for CSV job data, marking the end of a data row. The default is LF. Valid values are: LF—linefeed character CRLF—carriage return character followed by a linefeed character Yes Assignment Rule ID The ID of an assignment rule to run for a Case or a Lead. The assignment rule can be active or inactive. The ID can be retrieved by using the Lightning Platform SOAP API or the Lightning Platform REST API to query the AssignmentRule object. No External ID Field Name The external ID field in the object being updated. Only needed for upsert operations. Field values must also exist in CSV job data. No salesforce_bulkapi_v2.closeJobThe salesforce_bulkapi_v2.closeJob operation closes a bulk ingest job in Salesforce using Salesforce Bulk API v2. See the related API documentation for more information. Parameter Name Description Required Salesforce configuration The Salesforce configuration to store OAuth related data. Yes Job ID Bulk job ID Yes salesforce_bulkapi_v2.deleteJobThe salesforce_bulkapi_v2.deleteJob operation deletes a bulk ingest job in Salesforce using Salesforce Bulk API v2. See the related API documentation for more information. Parameter Name Description Required Salesforce configuration The Salesforce configuration to store OAuth related data. Yes Job ID Bulk job ID Yes salesforce_bulkapi_v2.getAllJobInfoThe salesforce_bulkapi_v2.getJobInfo operation retrieve all the bulk ingest job information from Salesforce using Salesforce Bulk API v2. See the related API documentation for more information. Parameter Name Description Required Salesforce configuration The Salesforce configuration to store OAuth related data. Yes IsPKChunkingEnabled If set to true, the request only returns information about jobs where PK Chunking is enabled. This only applies to Bulk API (not Bulk API 2.0) jobs. No Job Type Gets information only about jobs matching the specified job type. Possible values are: Classic—Bulk API jobs. This includes both query jobs and ingest jobs. BigObjectIngest. V2Ingest—Bulk API 2.0 ingest (upload and upsert) jobs. All-Gets information about all job types. No Query Locator Gets information about jobs starting with that locator value. No salesforce_bulkapi_v2.getFailedResultsThe salesforce_bulkapi_v2.getFailedResults operation retrieves failed records of a specific bulk job from Salesforce using the Salesforce Bulk API v2. See the related API documentation for more information. Parameter Name Description Required Salesforce configuration The Salesforce configuration to store OAuth related data. Yes Job ID Bulk job ID Yes Output Type The response content type Yes Add Results To Store the result in FILE or BODY Yes File Path The file path to store results If selected FILE in Add Results To salesforce_bulkapi_v2.getJobInfoThe salesforce_bulkapi_v2.getJobInfo operation retrieve bulk ingest job information from Salesforce using Salesforce Bulk API v2. See the related API documentation for more information. Parameter Name Description Required Salesforce configuration The Salesforce configuration to store OAuth related data. Yes Job ID Bulk job ID Yes salesforce_bulkapi_v2.getSuccessfulResultsThe salesforce_bulkapi_v2.getSuccessfulResults operation retrieves successful records of a specific bulk job from Salesforce using the Salesforce Bulk API v2. See the related API documentation for more information. Parameter Name Description Required Salesforce configuration The Salesforce configuration to store OAuth related data. Yes Job ID Bulk job ID Yes Output Type The response content type Yes Add Results To Store the result in FILE or BODY Yes File Path The file path to store results If selected FILE in Add Results To salesforce_bulkapi_v2.getUnprocessedResultsThe salesforce_bulkapi_v2.getUnprocessedResults operation retrieves unprocessed records of a specific bulk job from Salesforce using the Salesforce Bulk API v2. See the related API documentation for more information. Parameter Name Description Required Salesforce configuration The Salesforce configuration to store OAuth related data. Yes Job ID Bulk job ID Yes Output Type The response content type Yes Add Results To Store the result in FILE or BODY Yes File Path The file path to store results If selected FILE in Add Results To salesforce_bulkapi_v2.uploadJobDataThe salesforce_bulkapi_v2.uploadJobData operation upload the csv records to a bulk job in Salesforce using the Salesforce Bulk API v2. See the related API documentation for more information. Parameter Name Description Required Salesforce configuration The Salesforce configuration to store OAuth related data. Yes Job ID Bulk job ID Yes Input Data The CSV content that needs to be uploaded. Required Bulk API 2.0 Query¶ salesforce_bulkapi_v2.createQueryJobThe salesforce_bulkapi_v2.createQueryJob operation creates a bulk query job in Salesforce using Salesforce Bulk API v2. See the related API documentation for more information. Parameter Name Description Required Salesforce configuration The Salesforce configuration to store OAuth related data. Yes Operation The type of query. Possible values are: QUERY, QUERY_ALL Yes Column Delimiter The column delimiter used for CSV job data. The default value is COMMA. Valid values are: BACKQUOTE—backquote character (``) CARET—caret character (^) COMMA—comma character (,) which is the default delimiter PIPE—pipe character (|) SEMICOLON—semicolon character (;) TAB—tab character Yes Line Ending The line ending used for CSV job data, marking the end of a data row. The default is LF. Valid values are: LF—linefeed character, CRLF—carriage return character followed by a linefeed character Yes salesforce_bulkapi_v2.abortQueryJobThe salesforce_bulkapi_v2.abortQueryJob operation aborts a bulk query job in Salesforce using Salesforce Bulk API v2. See the related API documentation for more information. Parameter Name Description Required Salesforce configuration The Salesforce configuration to store OAuth related data. Yes Query Job ID Bulk Query job ID Yes salesforce_bulkapi_v2.deleteQueryJobThe salesforce_bulkapi_v2.deleteQueryJob operation deletes a bulk query job in Salesforce using Salesforce Bulk API v2. See the related API documentation for more information. Parameter Name Description Required Salesforce configuration The Salesforce configuration to store OAuth related data. Yes Query Job ID Bulk Query job ID Yes salesforce_bulkapi_v2.getQueryJobInfoThe salesforce_bulkapi_v2.getQueryJobInfo operation retrieve bulk query job information from Salesforce using Salesforce Bulk API v2. See the related API documentation for more information. Parameter Name Description Required Salesforce configuration The Salesforce configuration to store OAuth related data. Yes Job ID Query job ID Yes salesforce_bulkapi_v2.getAllQueryJobInfoThe salesforce_bulkapi_v2.getAllQueryJobInfo operation retrieve all the bulk query job information from Salesforce using Salesforce Bulk API v2. See the related API documentation for more information. Parameter Name Description Required Salesforce configuration The Salesforce configuration to store OAuth related data. Yes IsPKChunkingEnabled If set to true, the request only returns information about jobs where PK Chunking is enabled. This only applies to Bulk API (not Bulk API 2.0) jobs. No Job Type Gets information only about jobs matching the specified job type. Possible values are: Classic—Bulk API jobs. This includes both query jobs and ingest jobs. V2Query—Bulk API 2.0 query jobs. V2Ingest—Bulk API 2.0 ingest (upload and upsert) jobs. All-Gets information about all job types. No Query Locator Gets information about jobs starting with that locator value. No salesforce_bulkapi_v2.getQueryJobResultsThe salesforce_bulkapi_v2.getQueryJobResults operation retrieves the results of a specified bulk query job from Salesforce using the Salesforce Bulk API v2. See the related API documentation for more information. Parameter Name Description Required Salesforce configuration The Salesforce configuration to store OAuth related data. Yes Job ID The ID of the bulk query job. Yes Locator A string that identifies a specific set of query results. Providing a value for this parameter returns only that set of results. Optional Max Records The maximum number of records to retrieve per set of results for the query. Optional Output Type The response content type Yes Add Results To Store the result in FILE or BODY Yes File Path The file path to store results If selected FILE in Add Results To