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
0
votes
1answer
236 views

Need help with Bulk API

I know that Bulk API is an asynchronous API. I understood Bulk API, going through the developer guide, but have a question unanswered. When a job completes or a batch completes, is there a ...
0
votes
1answer
130 views

using BULK API to download AccountContactRelation

Is it possible to do so? using BULK API to download AccountContactRelation I have a code already working and can download custom and standard objects, however when I try to download ...
0
votes
1answer
220 views

How to avoid duplication in Bulk API

I have 3 million records(Accounts and contacts) in my product.I wanted to push all the data into salesforce. I use Bulk API Pk chunking to do this.How can I avoid duplicate record creation(in Accounts ...
2
votes
1answer
531 views

SOAP method of authentication

I came across SOAP method of authentication described in the below link: https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_calls_login.htm?search_text=login Using the ...
1
vote
0answers
65 views

Bulk API Batch Query

I have 10 lakhs records in my salesforce contacts. Iam going to use Bulk Api to fetch all these records.How can I write a SOQL query to fetch records so I can feed the queries into the batches? And ...
-1
votes
1answer
213 views

Bulk API vs Dataloader

I have a requirement to send 10 million records to Salesforce from a Mediation System. I can write the records in CSV in the system. Should I upload these files using DataLoader with Bulk API on , or ...
0
votes
1answer
197 views

Insert using Bulk API throws error MISSING_ARGUMENT:fiedXXX__c not specified:--

An external system is using bulk api to insert records in Salesforce. Salesforce throws an error saying - MISSING_ARGUMENT:fiedXXX__c not specified:-- where XXX is external Id of Parent of the ...
0
votes
0answers
30 views

checking if an attachment already exist given custom object

I am using python code with the SalesforceBulkpy API to upload an image to a custom object. I want to make sure I only upload the image once so I thought on adding a check if an image exists before ...
0
votes
1answer
490 views

Update Lookup Relationship using Bulk API and CSV

I'm trying to perform an update on our users using Python's Salesforce Bulk interface. Each account has a User ID field (UserID__c, External ID, Unique Case Insensitive) and a Parent ID field (...
0
votes
1answer
219 views

Error desearlizing JSON of type BatchInfo - Bulk API

I am trying to get the status,# record processed etc details by hitting the bulk API endpoint - /services/async/39.0/job/75037000003BXtw/batch In response I got the below JSON structure: {"batchInfo"...
4
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
926 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
376 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
158 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
50 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
638 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
71 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
42 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
178 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
249 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
777 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
111 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
126 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
128 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
268 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
285 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
193 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
320 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
502 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
65 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 ...
1
vote
1answer
3k 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
312 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
535 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
689 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
212 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
621 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
174 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
763 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
1k 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
812 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
323 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
1k 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
791 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
224 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> ...