Questions tagged [bulk-api]

Bulk API is based on REST principles and is optimized for loading or deleting large sets of data. You can use it to query, insert, update, upsert, or delete a large number of records asynchronously by submitting batches which are processed in the background by Salesforce.

Filter by
Sorted by
Tagged with
3
votes
1answer
2k views

NUMBER_OUTSIDE_VALID_RANGE: value outside of valid range on numeric field: 100.0

I get this error in the results of a Bulk API upsert: 'NUMBER_OUTSIDE_VALID_RANGE:Normalized Score: value outside of valid range on numeric field: 100.0:normalized_score__c --' The metadata for that ...
0
votes
1answer
677 views

How to get error reason for bulk requests with failed records, via API

After a Bulk API upsert, I can inspect the batch after the fact and see that my 4 records failed. { 'apexProcessingTime': '0', 'apiActiveProcessingTime': '1', 'createdDate': '2017-07-21T15:33:47.000Z'...
2
votes
1answer
313 views

Is it possible to Bulk API upsert with a compound primary key (external ID)

The Bulk API's upsert requires an external ID field name, I presume to act as the unique identifier which says whether a record you're upserting exists or not (determining whether to insert or update)....
0
votes
0answers
140 views

Bulk insert, with a “where not exists” clause

Is there something analogous to SQL's WHERE NOT EXISTS for bulk inserting into Salesforce? (I'm using the Bulk API to insert records into a custom table I've created by inserting a Custom Object ...
0
votes
2answers
45 views

Custom fields that don't have 'required: True' are not appearing in describe call

I create a Custom Object named 'SomeTemplate__c' with the Metadata API, and I have fields: 'created_at__c' 'name__c' 'template_id__c' which are created with required: True set in the parameters. ...
1
vote
2answers
573 views

Workbench: Invalid session id

EDIT: for some reason I'm unable to upload the image, so here is the screen shot of my workbench https://ibb.co/kVbpYQ I get the sessionID from Developer Console annoy window: System.debug(UserInfo....
0
votes
1answer
62 views

How to capture Data Loader error when called from Shell script via SSIS package?

Salesforce Gurus: Thank you in advance for any insights you may have. For years now I have been extracting data from a custom Salesforce object named Branches__c using the following method... ...
1
vote
0answers
17 views

How to best identify the most optimum time to leverage the bulk API for large data volumes?

As per this developer document: As worker threads become available to process your Bulk API jobs, Salesforce assigns them to process specific batches. This point is emphasised further in this ...
0
votes
1answer
35 views

How long should it take thousands of records to insert from Bulk API

I used workbench to insert a mass amount of records, and it said it completed, but nothing is in production. When should I expect them / be concerned if they still aren't there? I understand if it ...
1
vote
1answer
167 views

Can we not change status of Job from Closed to Open?

Can we not change status of Job from Closed to Open? I somehow (unintentionally) change the status of the job, but now I unable to change the status to Open again. Is this not possible to change the ...
0
votes
1answer
226 views

Bulk Query with PK chunking enabled where is the location of the original batch when we read the BatchInfo[] from the Bulk Job Id

For bulk query jobs if the job has PK chunking enabled, will the original batch (that contains the query when the subsequent batches are created) will be created with the id as "0" in an BatchInfo ...
1
vote
1answer
650 views

Is there an API available to query for all in progress bulk api jobs? [duplicate]

I need to programmatically list all the currently in progress bulk api jobs. I don't see any API methods available to do this. The goal here is to be able to wait till there are no in progress bulk ...
0
votes
0answers
94 views

SOQL slow query performance on FieldPermissions

I am running two jobs for Bulk API on FieldPermissions: Job 1: SELECT Id, ParentId, SobjectType, Field, PermissionsEdit, PermissionsRead, SystemModstamp FROM FieldPermissions WHERE SystemModstamp &...
1
vote
2answers
115 views

Importing emails in a specific order using the rest API

In a data migration context from a Salesforce organization to another one, a requirement we have is to transfer the 'EmailMessage' from an organization to another. As they are the main interaction ...
1
vote
0answers
103 views

Bulk API maximum field length measure in Java

I'm using Bulk API on Java to insert EmailTemplate records. Some errors that were caught were: InvalidBatch : Failed to parse CSV. Exceeded max field size: 51112 However, the record in question had ...
0
votes
0answers
19 views

Bulk API contacts not showing up in the sales force interface

I have used bulk API to create contacts and I got confirmation that job has successfully created and and data processed. I also got following information when I try to check result of bulk process, ...
0
votes
1answer
1k views

Bulk Api error InvalidBatch : Field name not found

I have a custom field in Lead as well as contact with same API name. The data in this field is supposed to be populated via integration service layer[written in Java]. the issue is when the data is ...
0
votes
2answers
232 views

Using Bulk API to import leads

We are thinking to integrate salesforce with out existing website. On our website, users have already existing leads created using our lead capture form. We want to import these existing leads to ...
1
vote
1answer
244 views

Any good way to estimate bulk api processing time?

Running some tests right now and it took 16min to process just 2600 accountshare upserts. With a Timeout : Took more than five minutes to process 200 Trying again later. error. Which seems ...
1
vote
0answers
190 views

PKChunking problem when using Content-Type: application/json

I have the following problem when creating a batch to a job in Salesforce and I want to enable PKChunking. I perform a POST request at /services/async/37.0/job and I am creating the job like this: ...
-1
votes
1answer
273 views

Will formula fields update on api / bulk api update?

We're trying to figure out whether we should expect formula fields to behave as if the object in which those fields exist has been manually user-modified when we're updating records in that object, ...
2
votes
0answers
458 views

Why doesn't Dataloader use specified 10k batch size when Bulk API is selected?

I have this sample CSV file containing 10,000 records (with 33 columns) I'd like to import it via Dataloader into Case object at my sandbox environment. I tried using these settings below with Bulk-...
0
votes
1answer
64 views

issue renaming a csv after processing it [closed]

public List<BatchInfo> bulkUpsertAccountShare(obj gsr) throws UnsupportedEncodingException, IOException, AsyncApiException { log.info("BulkUpsertAccountShare!:"); SForceConnector sfc = ...
0
votes
0answers
100 views

How to connect to salesforce instance

I am exploring some option to connect two Sales force Orgs. My requirement is the following: Any update to a record in one org should update the records in another org. Both org has an object with ...
0
votes
1answer
2k views

Bulk Data Load jobs very slow; what's holding up the queue?

Not sure if this is the right place for this, but figured I'd try: Our Bulk Data Load jobs have been taking a really long time to complete recently. The processing time is normal, it's all queue time ...
0
votes
0answers
290 views

PK-chunking alternative for unsupported objects?

I'm trying to do some queries through the Bulk API, and I'd like to use the PK Chunking Header. From the documentation: PK chunking is supported for the following objects: Account, Campaign, ...
0
votes
1answer
460 views

Updating child records using bulk API

Can we create the child record of a parent object using the Bulk API. I am trying to use the bulk API and I want to create all the child record of a parent record. Is it possible through using bulk ...
0
votes
1answer
565 views

How to abort or close bulk API jobs from api?

Salesforce support requested to abort bulk data jobs from API, we tried doing it via UI, but salesforce support said it did not work! looking for ways to do it via rest, soap or any other ways
1
vote
2answers
175 views

Bulk data load job not visible for bulk upload

An external system uses the bulk api to push bulk data into Salesforce. THis external system will only push the data if Salesforce sends a request to push the data. I beleive all the bulk data that is ...
1
vote
2answers
2k views

Bulk API: using Workbench InvalidSessionId (Unable to find session id)

I'm following this (Bulk Api) Trailhead, I have valid SessionId and when I try to authenticate I'm getting the following error: I have created few records using the same SessionId and I know its a ...
1
vote
1answer
585 views

Bulk API client for .NET

I am looking for SalesForce Bulk API client to perform big data load/upload. Currently I am calling api manually building/parsing csv files, building request xml. Looking for more convenient way to ...
1
vote
1answer
1k views

Facing record lock issue on Parent when loading millions records

An external system is pushing data into my org using bulk API. There are about 2 million records. The target object is child__c. The child__c has a lookup to parent__c. When the external system loads ...
1
vote
1answer
158 views

Left join in Bulk API

I need to load all accounts along with their owners' names, was trying next query: SELECT Id, (SELECT FirstName, LastName FROM Owner), LastModifiedDate FROM Account Got next error: InvalidBatch :...
2
votes
1answer
662 views

It is possible to set the concurrency mode for a Data Import Wizard job?

I'm running in to some problems that I believe may be related to parallel processing of an 'Add new record' job by the Data Import Wizard. Is it possible to somehow force the concurrency mode for the ...
1
vote
0answers
903 views

Why do I get "ClientInputError - exceptionMessage='Server error returned in unknown format' while using Bulk Query

I am using Bulk Query, reading one batch at a time, and writing to the standard output. When the records size is small like 100000 records, the job works fine, but when I try to extract records like ...
0
votes
1answer
671 views

Problem loading million records in Salesforce using Bulk API

Hi I am loading some millions of data in Salesforce using Bulk API. Is there any limitation on that? The external system has failed to insert the records. Records is around 1 million. Is there any ...
2
votes
1answer
302 views

Unable Login To Sfdc Org Using Bulk Api Java Code

I am using Bulk Api for data migration from oracle db to Sfdc Org through Java Code. For logging into the Salesforce org i am using the Soap Api by generating the partner jar. I am getting the ...
0
votes
2answers
998 views

Bulk Query with PK Chunking enabled sometimes does not return all the batches

The requirement is to use Bulk Query API with PK Chunking enabled, and to create CVS files for each batch with the chunk-size For example, in the Account Object if I have 80,000 records, and have the "...
2
votes
1answer
727 views

Bulk-API insert with sObject Tree

I am attempting to do an insert of thousands of record using the Bulk-API, which is in itself is not complicated. The thing that I am having trouble with is insert both Record and Child. For example, ...
3
votes
1answer
198 views

How to Interpret Bulk API UpsertResult element?

Below is the Result of the Bulk API job(batch) I submitted : <?xml version="1.0" encoding="UTF-8"?> <results xmlns="http://www.force.com/2009/06/asyncapi/dataload"> <result> ...
2
votes
1answer
562 views

Bulk API - Upload documents (files and URL) through CSV

I have tried uploading files through CSV using Bulk API's createBatchWithFileattachment() call. It basically goes like this: createBatchWithFileAttachments(JobInfo jobInfo, InputStream batchContent, ...
0
votes
1answer
59 views

Pulling million records from Data extension?

We have a list of around 30 data extension with around 2 millions records each and 20 columns each data extension. What is the best way of pulling the data and clearing it? Using the SOAP API it takes ...
1
vote
1answer
748 views

Bulk APIs delete, update, upsert request format

I have created an object for Contact in salesforce. I am trying to delete it using curl command. Please help me with the format of the request. I am using json format [{"Id":"0032800000i6MyTAAU"},{"...
0
votes
1answer
674 views

HTTP 400 Bad Request trying to create a bulk API job using RestTemplate

Am trying to use spring RestTemplate to create a bulk API job. Below is the code HttpHeaders headers= new HttpHeaders(); headers.setContentType(MediaType.APPLICATION_JSON); headers.add("sforce-enable-...
0
votes
1answer
318 views

Bulk API - asynchronous processing

I have a question regarding the Bulk API. It is stated that the Batches are processed asynchronously by Salesforce. I think it is meant that sending multiple batches for one job would be imported ...
1
vote
0answers
64 views

Which tools\techniques are you using to improve performance of mass deletion of custom object records?

We have a custom object with about 40 million records. We have identified about 18 million that we are going to delete forever. All of this data is permanently retained in an Oracle backup so we are ...
1
vote
0answers
74 views

Monitor Import Wizard Job Status?

Is there a way to check Status of 1st Batch job every 5 mins by using 2nd batch job? Here 1st batch job internally uses 'Import Wizard' to load/Delete records and everything handles in Salesforce ...
1
vote
1answer
69 views

Code enhancing to avoid CPU time exceeded issue

How to avoid CPU limit exceeded if the requirement Is to have a map of field names and values of contacts when the trigger fires? Any ideas of how to enhance the code below please : Map<...
2
votes
0answers
40 views

I want to know If I can create a report or alert on Bulk API Jobs whenever a Job has Failed

I want to know If I can create a report or alert on Bulk API Jobs such that whenever a Job has Failed. If we can create a VF page then on which standard controller I can start with.
6
votes
1answer
850 views

Uploading 100,000 binary files as attachments to Case record - best approach

I want to upload files (.doc, .pdf) from external system to the attachments of Case record. There are two approaches I have found from Salesforce Help. 1) Uploading Attachments by data loader ...