Questions tagged [bulk-api-v2]
The bulk-api-v2 tag has no usage guidance.
26
questions
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 ...
- 225
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 ...
user93617
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 ...
- 121
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&...
- 117
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", "...
- 4,478
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,630
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