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.

learn more… | top users | synonyms

0
votes
1answer
11 views

Bulk API - Invalid field 'Revision' on FeedItem

I query FeedItem on all fields using Bulk-API. This is the query: SELECT Id, ParentId, Type, CreatedById, CreatedDate, IsDeleted, LastModifiedDate, SystemModstamp, Revision, LastEditById, ...
1
vote
1answer
28 views

Bulk query CampaignMemper query failed

I am running into the following error while querying CampaignMember: -------------- Failed ----------CampaignMember [BatchInfo id='751c0000001HqUQAA0' jobId='750c0000001Mpg1AAC' state='Failed' ...
0
votes
1answer
19 views

Downloading all lead data through oAuth2 API

Completely new to the Salesforce API. I'd like to simply download all lead and contact information from a connected user's account - that is, anything which has an "Email" field. I've only briefly ...
1
vote
1answer
40 views

Bulk API and load into Multiple Objects from single CSV file

I'm extremely new to salesforce and Bulk API. I've search for a possible solution for a couple of days, but haven't had any luck. I'm using the java examples for the bulk api load that I found here, ...
1
vote
0answers
10 views

Get API URL for BulkConnection

Is there a "right" way to get the correct endpoint for establishing a BulkConnection (force-ws.jar)? I'm calling an external app from a visualforce page (already authenticated, passing session & ...
0
votes
0answers
31 views

Bulk API PK Chunking retrieving batch information issue

I am working on PK Chunking using Bulk APIs. I have added the header but it seems that the process is stuck in a loop. The job state in the Not processed state when printed [Under ...
4
votes
1answer
82 views

Bulk data API: How to Avoid Upserts

I'm working on an daily integration of about 5 million records (file delta's is not an option). Best practices for large data volumes recommends avoiding upserts. The only alternative solution I can ...
1
vote
0answers
45 views

Salesforce Async API not enabled even if enabled on Enterprise edition

I'm facing this issue on a customer enterprise edition. He's a system administrator and I checked his profile both in backend and through salesforce ui, and both are enabled (PermissionsApiEnabled ...
3
votes
1answer
57 views

Force.com CLI bulk query returns nothing

I have submitted a simple query using the Force.com CLI like so: will@mint ~ $ force bulk query CallRecord__c "select Account__c, CallFlow__c from CallRecord__c" Query Submitted To retrieve query ...
0
votes
1answer
57 views

Bulk query help

I am trying to get my bulk query up and running to get data from our salesforce account. I have looked up a lot of examples since salesforce fails to give a java example for a bulk query. None of ...
1
vote
1answer
131 views

bulk api java.net.SocketException: Connection reset

Am trying to read 8 million records with only 1 column (ID) using Bulk API without PK chunking. while reading I am continuously getting Connection reset exception : java.net.SocketException: ...
0
votes
1answer
50 views

Need Sample code to user BULK API with XML format

Can someone share or point me to BULK API JAVA sample code for XML format . I can see the JAVA example for csv format in below link. ...
2
votes
1answer
42 views

Modify Case Date/Time Opened Field on Upload

I'm trying to import some historical case data into our SalesForce account either through Bulk API or through Data Loader tool. I need to have the field "Date/Time Opened" under the new cases I am ...
0
votes
1answer
38 views

login call BULK API

I am bit confused here. I have been going through the BULK API document and got confused on few things. It says All HTTP requests must contain a valid API session ID obtained with the SOAP API ...
1
vote
1answer
98 views

BULK API reader with PK chunking enabled : Multiple batches are created in salesforce side with 0 rows processed

I have object with 100,000 records. And trying to read from Salesforce using PK chunking with 50,000 as chunk size. I expect two batches , each with 50,000 records. but what i noticed is 361 batches ...
0
votes
1answer
50 views

How to get reportType for many reports

I'm currently getting some basic information regarding all of my reports like so: SELECT Id, Name FROM Report I have around 5000 reports. I'd like to be able to get the type of report as well ...
0
votes
0answers
80 views

BULK API -PK Chunking Header Query - job content type : application/xml

Is it possible to use PK Chunking Header for a Query job of type XML. It works with CSV and when i pass it for xml jobs it fails and gives this error InternalServerError : PKChunking failed. ...
2
votes
1answer
46 views

is there a way to be notified or poll for Salesforce API sobject changes?

We've been using v33.0 to download all the data from our Salesforce account. Today, we found out that one of the SObject got deprecated in v34.0 because the API threw HTTP 400 error and we wasted some ...
1
vote
1answer
27 views

How to set “MailingAddress” (address type) field on contact through Bulk API?

I'm having problem setting the "MailingAddress" field on Contact sObject. I'm trying with the following: <?xml version="1.0" encoding="UTF-8"?> <sObjects ...
3
votes
1answer
46 views

Identify salesforce schema changes

I am backing up Account, Leads, Opportunities and Document objects. Initial level backup is full where I download using BULK API and then incremental subsequently. If there is a change in the schema ...
0
votes
0answers
46 views

What API/SDK to use for querying Exact Target data?

I have a requirement to query and extract the Exact Target data in bulk. I want to be able to get this data in chunks for large volumes of data. There is also a requirement to limit the number of rows ...
2
votes
1answer
71 views

Bulk data update in Salesforce from External System

I have got a requirement to update 6k records in Salesforce from external system in every 4 hours. Can you please suggest what would be best way for this . 1) Should I use the standard Bulk API ? ...
1
vote
1answer
95 views

Bulk Querying AccountFeed results in Binary field not supported error

While running the Bulk export in Java in CSV format, I get an error while the XML does not return error. I tried documentation which does not yield any results. Can I get specific error that relates ...
4
votes
1answer
97 views

How many batches can be created in a JOB via Bulk API?

I went through limitations about Bulk API but could not get explanation on the limit of Batches created per job in Salesforce. I can read Batch limitation but no limitation in Job. Your help is ...
2
votes
2answers
111 views

INVALID_ID_FIELD when upserting an attachment through Bulk API

The situation is as follows: In my Salesforce org, I have a contact, let's call it Humpty Dumpty, and I'd like to attach a file to it, let's call it cooking.txt, but there are some rules: If there ...
2
votes
2answers
93 views

Bulk Import Leads From SQL Table and store leads id back into table

I need to bulk import leads from sql server table, get back the newly created leadid and store them back on sql table. I read documentation on salesforce bulk api. Salesforce returns a response with ...
1
vote
1answer
143 views

Import CSV into Salesforce (Group Edition) automatically

I'd like to import CSV file into Salesforce automatically, e.g. once a day. I can't use Data Loader (Bulk API), because I don't have the needed edition. Is there any other, simple way?
0
votes
1answer
48 views

Find objects that are supported through Bulk API

I am querying through a list of objects through salesforce and some of the objects are not supported through bulk api. For example, AcceptedEventRelation. Is there a way to check if the objects are ...
0
votes
2answers
93 views

BulkAPI error while uploading multiple attachments

I am trying to upload multiple attachments using Bulk API. I am using createBatchFromDir( ) for creating the Batch & using the sample code provided in the sfdc documentation at the link:- ...
0
votes
0answers
59 views

Bulk Query Questions

I have gone through the Bulk API guide. And I have come to know that we create only one batch when doing a bulk query and salesforce may return single or multiple result ids. Is my understanding of ...
0
votes
0answers
39 views

How are number of batches decided while Bulk Query and how to fetch result accordingly

I would like to know how are number of batches decided when we create a batch during Bulk Query in salesforce using createBatchFromStream() of the API. And how to handle multiple batches to fetch ...
0
votes
0answers
79 views

CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY:KT_AccountTriggers: execution of BeforeInsert

I am trying to upsert Account objects as a bulk operation with csv. I get these errors for 90-95% of the entries: "Id","Success","Created","Error" "003D000000Q89kQIAR","true","true","" ...
1
vote
1answer
175 views

Bulk API Query Explaination

So I am new to the Bulk API provided by Salesforce and I was going through their developers guide. I have few questions that need some clarification: Bulk API Query part of the guide says that one ...
0
votes
0answers
54 views

Bulk API: Query millions of records possibly size > 1GB?

Is there any way to QUERY using bulk API to get records possibly more than millon and size > 1GB. Could any one help. Thanks In advance. Rajesh C.
2
votes
2answers
65 views

Bulkd trigger skips some records

I have an object that I upsert using Dataloader, that has a unique external ID but the same ID must be used as a lookup to another object. Sadly, in Dataloader, you cannot assign a value to two ...
1
vote
1answer
33 views

What is the best practice method to summarize contact information to leads?

Here's the business case. I want to have a reportable field on a lead that displays the number of contacts for, say, a city field match. This value could be used in reports, dashboards, snapshots, ...
3
votes
4answers
219 views

Salesforce large query conditions: query 20000 contacts by emails and update fields

I have a csv file which has 20000 email addresses in it. I need to update some fields on these contacts. the dataloader is not suitable as I don't have the ID field of these email addresses. query in ...
0
votes
1answer
132 views

Deserialize BulkAPI XML response to QueryResult

Is there anyway to deserialize bulkAPI response(XML) to Standard QueryResult object? I am using C# as backend and PartnerAPI of SFDC. See below XML. I am getting "queryResult ...
1
vote
3answers
195 views

Exporting entire database via API

We use the salesforce dataloader to do occasional exports of our entire database so we can use our local database tools to run analysis and data cleaning that we can't manage via reporting and ...
1
vote
1answer
776 views

Process Builder Error with Bulk API

I set up a process to update the owner of a custom object (Program), When Formula evaluates to true: [Program__c].OwnerId <>[Program__c].Franchise__c.OwnerId Allow process to evaluate a record ...
0
votes
1answer
43 views

Can't create a Task for a Contact through Bulk API

I noticed that I can create a Task under a Contact manually, through Salesforce UI, but I can't create it through the Bulk API. Can anyone explain me why and if possible, how to overcome this? I ...
1
vote
1answer
79 views

Bulk-API: How to add a batch with both CSV data and a query?

I'm trying to use Salesforce's bulk API to run a query on some CSV data. Here is the desired result: In SF, we have a field product.serial__c. I have a CSV with a bunch of serial numbers that I would ...
1
vote
2answers
183 views

How to retrieve multiple contacts with single REST call

I am getting 20 contact ID from getUpdated.Now I need information for each of these 20 contacts.It seems costly to request each contact through a REST url.Is there any way how I can query multiple ...
1
vote
1answer
65 views

If I connect through multiple users to Salesforce Bulk API, what counts toward API limit?

As stated by the title, I'm not sure if, having a connected app, the API limit is reached based on my license or users (they come from different customers, so each user has his own license with his ...
2
votes
1answer
134 views

Can I use the Bulk API to programmatically retrieve deleted and Archived records?

I am creating an application to query for large volumes of data from salesforce. Most of which are archived and deleted records. It it possible for me to use the Bulk API via C# to complete this task ...
0
votes
1answer
48 views

Convert Lead into Opportunity, what does it do and is possible to do the same through Bulk API?

I need to be able to perform a "convert" operation on multiple leads. Considering I don't know the amount of leads that will be converted, I definitely want to use Bulk API (I can end with a lot of ...
1
vote
3answers
214 views

Want to push lead data from my web app into customer's salesforce accounts - where to get started?

My company wants to integrate its application with Salesforce. Our product will need to publish lead information into the accounts of hundreds or possibly thousands of companies each with their own ...
0
votes
1answer
45 views

Best way to migrate binary attachments from one org to another

Currently I am using apex data loader with bulk api enabled and batch size =1 . But its giving me failed to create batch when i try to import 1000 files with each size around 100kb. I need to ...
1
vote
0answers
62 views

Bulk API queue and REST API actions, any way to ensure sequence?

I have an app that perform some bulk operations but also requires real time updates for single records. I was thinking if there is a way to ensure that once the bulk action has been queued, any REST ...
1
vote
1answer
63 views

Bulk Upsert: How do I know which records have been created/updated?

I read that records are in the same order as they are sent, but what happens if I upsert 5 records and only 3 are fine? For example: Fine Fails Fine Fine Fails Am I going to receive 5 records or ...