Questions tagged [bulk-api-v2]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
40 views

Bulk query job not returning all results

I've been running the Bulk API v2 Query in my sandbox for a month now and it's been working great. I went to move things into production and I started encountering a terrible error. It seems my query ...
0 votes
0 answers
24 views

salesforce bulk load giving Union error when we use V2

When we use same data with V1 - loaded fine but with V2 it's giving Union error Union can only be performed on tables with the compatible column types. string <> boolean at the 13th column of ...
0 votes
0 answers
172 views

Json Deserialization failed on token and has left off in the middle of parsing a row

I am trying to bulk load a csv file with 11000 records using Python with the simple-salesforce API. The error that I am running into is that when I try to load the file, I get this message: {'created':...
  • 121
2 votes
1 answer
392 views

Unable to Obtain Failed Bulk API Records

I am trying to pull the failed records from a bulk job that I have using this API call: https://COMPANYNAME.my.salesforce.com/services/data/v56.0/jobs/ingest/{jobId}/failedResults This API call is ...
  • 121
0 votes
1 answer
157 views

Apex Bulk API order of processing for CSV records

I am currently working on an existing integration for syncing price-book entries from an external system to Salesforce. The system is using Apex Bulk API.I already know that in Salesforce it is ...
  • 125
1 vote
0 answers
31 views

Does Bulk 2.0 real ignores the Line Ending Header (Ignored)

According to the offical document, the line ending header is ingored in Bulk API 2.0 https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/bulk_api_2_0_line_ending_header.htm ...
  • 98
1 vote
1 answer
263 views

Error using postman calling Bulk API 2.0 to upload file

I am following the salesforce offical guide on Bulk2.0. I am able to create a job but when I try to upload a csv file, it shows the error. here is the call. however, I can use workbench to upload the ...
  • 98
0 votes
1 answer
390 views

Bulk Api 2.0 - Get Information About All Query Jobs

I'm using Postman to test the Bulk Api 2.0 Query endpoints. I can create a job, retrieve information on a single job, retrieve the job results, and delete a job. I cannot retrieve information on all ...
0 votes
0 answers
488 views

Bulk API v2 - retrieving results of a query job

Looking at migrating jobs to Bulk API v2 we are seeing an issue: With Bulk API v1 after submitting a query job we can get the Ids of remaining batches. With these batch Ids we can download the results ...
0 votes
0 answers
177 views

Getting 204 and no response on Bulk API v2 query

I am trying to get the result for query 'SELECT Id, Name FROM Account' using bulk API v2. I am getting the job id and state as UploadComplete but when I am trying to get the results for the job I am ...
user avatar
2 votes
1 answer
785 views

Batches under Bulk API jobs salesforce

In Salesforce Bulk API, let's say I want to insert 1K Opportunity records. So, I created a job, and added all 1K records to the one single request body and all these records got generated successfully....
  • 534
-1 votes
1 answer
629 views

Bulk API 2.0 v52.0 Query select *

I'm trying to post the following json body to the Bulk Api endpoint but am getting an error. { "operation": "query", "query": "SELECT * FROM Account" } ...
  • 13
1 vote
1 answer
271 views

BulkAPI 2.0 Import PricebookEntries via Postman getting this error:STANDARD_PRICE_NOT_DEFINED:Before creating a custom price, create a standard price

I have setup the Postman requests to talk to the salesforce BulkAPI 2.0 because the dataLoader doesn't work (MacBook M1). The import of the pricebookentries fail at a point because when I import the ...
  • 301
1 vote
1 answer
93 views

Reschedule queries after upgrading from Bulk API V1 to Bulk API V2

I checked the Bulk Data Load Jobs page and there are queries running in Bulk V1 and currently org does not have Bulk V2. So, if Bulk Version is upgraded to V2, will these queries automatically run in ...
  • 1,477
0 votes
0 answers
436 views

bulk api v2.0 Bad Request

I am trying to make a simple call to create a bulk job, but I am getting 400 bad request errors. It works fine with the postman. String objectName = 'Asset'; String operation = 'update'; ...
  • 1,509
0 votes
1 answer
622 views

Postman Bulk API 2.0 Delete: Error "The 'delete' batch must contain only ids"

trying to test Bulk API delete functionality in Postman desktop. I created a Job like so { "object": "et4ae5__IndividualEmailResult__c", "operation": "delete&...
  • 191
2 votes
0 answers
124 views

Determining case of a Bulk API *query* Failure

For a particular query: I am initiating a query via the Bulk API v2 at /services/data/v47.0/jobs/query. I use the job id to query the status via /services/data/v47.0/jobs/query/jobId, repeatedly once ...
2 votes
1 answer
637 views

Bulk API v2 Query job not returning results in same order as that of SOQL

I am using Bulk API v2 Query job to query on data from Salesforce. For example my SOQL is - select id, firstname, lastname, city, state, country from account In the response I am expecting columns to ...
  • 77
1 vote
1 answer
662 views

Is there a Salesforce data-loading/ETL tool that uses Bulk API V2.0? [closed]

Is there a data-loading/ETL tool that uses Salesforce's Bulk API v2.0? I see that both Data Loader and dataloader.io, in Bulk mode, still only use Bulk API v1.0. And please do NOT say "Workbench&...
3 votes
0 answers
547 views

Performance of query job using Bulk API V1 vs Bulk API v2

I am currently using Bulk API v1 query job to extract data out of Salesforce. In this case by using pkChunking, extract job of 150k records completes within 30-40 seconds. However, now when I am ...
  • 77
1 vote
1 answer
459 views

Is it possible to make a single API request which deletes multiple records using external id without creating a custom rest resource?

Let's say I have an external identifier field Account.External_Id__c. I have a web application which has the values for this field and needs to delete multiple records, (e.g. "Abc123", "...
2 votes
0 answers
273 views

How to interpret bulk API processing times

According to the docs apexProcessingTime is The number of milliseconds taken to process triggers and other processes related to the job data apiActiveProcessingTime is The number of milliseconds ...
1 vote
1 answer
951 views

Create a bulk job using JSforce

I am trying to create a bulk api query job using jsforce and nodejs. Below is the method i am calling after getting the access token. But it is not creating the job. Is the below way correct to create ...
1 vote
1 answer
117 views

Get specific fields in Bulk API success file

How to retrieve only sf_id and externalID from below uri. services/data/v41.0/jobs/ingest/{jobid}/successfulResults/ I created a batch job, uploaded data, completed job and got results and I got all ...
  • 11
1 vote
1 answer
271 views

salesforce bulk query 2.0 OR operator

I am trying to use Bulk query 2.0 and trying to submit a job via workbench for the following query, "query" : "select id, name from Account where name like 'Microsoft%' OR name like '...
0 votes
1 answer
782 views

Bulk Api V2: How to correlate success/failed records with source records

Bulk Api v2 provides successful and failed records in two different files. This means if there are some records failed in between a batch, then we will not be able to correlate those failed records ...
  • 1,692