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

3
votes
1answer
75 views

How to retrieve compound fields like address using Bulk API?

Attempting to retrieve address fields (such as BillingAddress on Account) via Bulk API gives an error: Failed to process query: FUNCTIONALITY_NOT_ENABLED: Selecting compound data not supported ...
2
votes
0answers
16 views

Upserting objects with many to many relationship using api

I am writing a script to run on a schedule to automatically import data from our accounting software into salesforce using their API. I cannot find a good way to upsert objects with many to many ...
0
votes
0answers
20 views

Methods to delete fields inserted via Bulk API

Is there any method for deleting specific fields when Bulk Api is in process? The specific fields mentioned above is like only the user selected fields with records should be inserted via bulk,The ...
0
votes
0answers
24 views

Abort bulk jobs using callout

I am trying to abort a bulk job String username='username@suer.com'; String pwd='password'; HttpRequest request = new HttpRequest(); request.setEndpoint('https://www.salesforce.com/services/Soap/...
0
votes
0answers
33 views

Bulk API Error => InvalidBatch : Batch not completed

we are trying to retrieve the progress of a Batch using bulkapi (BatchResult) and sometimes, we receive the following error: Root Exception stack trace: [AsyncApiException exceptionCode='...
0
votes
2answers
59 views

Bulk API Data Load taking more than 5 minutes to process Inconsistently

I have an issue in Bulk API Data load jobs which is taking sometimes more than 5 and 10 minutes to process even single record. Basically we are migrating from Siebel to Salesforce and for now, we ...
6
votes
1answer
46 views

Can't I use ALL ROWS in asynchronous Salesforce queries?

I would like to perform asynchronous queries that could retrieve deleted rows as well. However, if I submit a batch with SOQL like select Id, IsDeleted, Name from Account where IsDeleted = true and ...
2
votes
2answers
70 views

How to check records source in Trigger?

The trigger must be developed. Inside I need to check are records came from outside SF via bulk load or they are created internally? I can not change uploading process or modify records before they ...
4
votes
2answers
93 views

Will Trigger and Workflow get fired while using Bulk API

I am trying to upsert records in Account using Bulk API. After upserting records I need to update some of the custom field values to standard field values using trigger or workflow. Is it possible ??? ...
0
votes
1answer
48 views

HTTP Callout from Salesforce to Google Analytics [duplicate]

I want to get some of the data from Google Analytics into Salesforce. I have looked through a series of articles but I couldn't find any step by step guide how to do so, hence I am unsure what ...
0
votes
0answers
13 views

Send data to api and have it display over multiple lines within a textarea field

I need to send some data to the bulk api, in csv format, and have the values for a field displayed on separate lines within the Salesforce UI. Is there a way to disable HTML escaping for individual ...
1
vote
1answer
23 views

What is the name of the Owner Field in csv for Bulk API

We are trying to Upsert records for account using Bulk API.The CSV file contains a field named "OWNER". While performing the operation we get the error as Field name not found:"Owner"
0
votes
1answer
17 views

Bulk API: During update, how to avoid overwriting existing values for certain fields?

I have a C# program that uses the Bulk API to automatically upsert Account records from an external system into Salesforce on a daily basis. I'd like to be able to change this upsert such that for ...
2
votes
0answers
82 views

Salesforce Bulk API upsert - Error: ENTITY_IS_DELETED

I am trying to restore a custom object from my backup where I am trying to upsert the records. Following this example. The external field is Id here. Assuming that there are no records matching, the ...
4
votes
2answers
132 views

Specify large set of IDs in SOQL query

I have an object with around 2 million records and list of IDs that I need to extract. The list is around 20k entries. Surely I can't just chug them into query parameter? What is the best way to do ...
1
vote
1answer
52 views

Insert bulk data in ContentVersion with Bulk API

We are working on a migration application in C# to migrate data from SQL Server to Salesforce and we are using Bulk API and sforceService (Salesforce Enterprise WSDL) for this. We are migrating data ...
0
votes
0answers
55 views

Better way to truncate all entries of a Salesforce Object through API

I want to recreate all entries of a Custom object from external source everyday. Currently I am using BULK API and if I need to do a full refresh, I follow the following steps: Query Id of all ...
2
votes
0answers
17 views

Posting Pdf to chatter via bulk api?

Which object should we use to post data's to chatter?I am trying to post a pdf file to a chatter object using curl. What is the name of the object that we should specify in txt file? <?xml ...
1
vote
1answer
31 views

Bulk Api:Storage limit exceeded

I am performing bulk api operations to load account records into salesforce using curl.I have a separate CSV file to do that job which consist of 5000 records.when I try uploading it, only 3500 ...
4
votes
0answers
77 views

Unsupported Content Type while using curl

We are currently working on with bulk api to load json data's into salesforce.But unfortunately we are not able to load it and getting error as unsupported content type does salesforce ...
5
votes
1answer
40 views

Bulk API Row Lock Root

How to get confirmation that Inserts/Deletes of Contacts using the Bulk API will cause Row Lock errors on the parent Accounts, especially if the # of Contacts is large and there are few parent ...
1
vote
0answers
27 views

Is Salesforce supports or provides Bulk API for SAP? Any experts suggestions please

Bulk API documentation has given sample code in Java. We have a need where we need to load huge volume of data from SAP to Salesforce. Had tried using SOAP and RESTful services but ended with hitting ...
0
votes
1answer
24 views

which api does dataloader uses when bulk api is not checked? What is the default API?

Which api does dataloader uses when bulk api is not checked? What is the default API ? I could see explanation for using BULK API in dataloader, but what to know which api is used in default?
1
vote
1answer
202 views

Loading 1 million records using bulk API: Exceeding batch Limit

Whenever records are inserted in Contacts(usually inserted in 1000's), we have a batch job that checks related customer account in SFDC and populates the contact.accountId field and couple other ...
0
votes
0answers
45 views

Advanced Data Export/Import with Bulk API

I have a task to export data for about 60 Salesforce users then to edit them and import it back again. I am not allowed to use specialised web sites for data export/import where you provide user/pass ...
2
votes
1answer
36 views

OpportunityFieldHistory timestamp and bulk API

I've turned on opportunity field history tracking for a couple of fields and can successfully query for changes using the bulk API. However, it looks like the OpportunityFieldHistory object doesn't ...
3
votes
1answer
44 views

Streaming Comet Client didn't receive events for data added using Bulk API?

I have Streaming comet client with a Pushtopic to an custom object Business__c (the pushtopic is enables with insert,updates and delete events). The comet client doesn't generate events based on ...
1
vote
0answers
133 views

Process Builder Flow fails when using BulkAPI

I have created a simple flow in Process Builder. The flow works fine for all scenarios that I test manually by updating Objects. However, when I use the BulkAPI with a large amount of records (100+) I ...
6
votes
1answer
148 views

A Few API Related Doubts

My first is related to Enterprise WSDL vs Partner WSDL. I know the basic difference between two: tightly coupled vs loosely coupled, one is tied to specific organization while other is used to build ...
0
votes
0answers
30 views

Scheduled data import in Salesforce from a folder/database

My current customer is working on a differen CRM and they upload data in the CRM on daily basis (though an automated scheduled job). To achieve this, there is a middleware in place that exports and ...
1
vote
1answer
50 views

Getting Bulk API details from my.salesforce.com organization

I am trying to query a BULK API Job for its status. My organization's URL ends in my.salesforce.com (e.g. https://.my.salesforce.com) but I cannot figure our the correct URL to get the job status. I ...
0
votes
0answers
54 views

Bulk Api Http 500 Server Error at Login

I am working to implement a Luigi module for connection to and query from Salesforce. I have been following the Salesforce Bulk Api Developer's Guide. The following is a portion of my code (which is ...
0
votes
1answer
82 views

Bulk Retreive: Rest API - SF Marketing Cloud

I need to pull various data from Salesforce Marketing Cloud (ExactTarget) including subscriber information, last open, last click, success rate (opens/total eligible campaigns), first bounce date, and ...
1
vote
1answer
28 views

Object/FieldPermissions objects have field SObjectType, how can values be greater than 40 characters?

I am currently in the process of working on a replication application to pull data down from Salesforce via the Bulk API and push data into an Enterprise Data Warehouse. The schema is pulled for ...
2
votes
1answer
20 views

Package Version Settings for Bulk API?

Is there any way to specify Package Version Settings when uploading data via the Bulk API? I am familiar with the capabilities with the SOAP API but need to find something similar for the Bulk API. ...
0
votes
1answer
79 views

Sporadic Bulk API error with PKChunking - Failed to create batch, since the Job is not Open

Sometime when retrieving the batch results for a Bulk API query job submitted with PK chunking enabled, I get the following error message: PKChunking failed. InvalidJobState : Failed to create ...
2
votes
2answers
269 views

Query Bulk Data Load Jobs once completed

Can some one tell how to query the data which are displayed in " Monitor Bulk Data Load Jobs" Section "Completed last 7 days"
2
votes
2answers
494 views

BulkAPI vs Dataloader?

I have never worked on handling large datasets and reading through the documentation raised the below questions in my mind: 1) If I need to load 10,000,000 (10 million) records into salesforce, Can I ...
3
votes
1answer
379 views

Create OrderItem (Order Product) from Bulk upload Object

I have created a Custom Object called CSVUpload__c that I insert a CSV file into using the Bulk API. I have created a trigger to then insert into the correct sObjects after the insert. However, I ...
1
vote
1answer
41 views

How to update membership object from product after insert?

I am using the bulk api to upload a CSV file to a custom object with the same fields as my CSV file. I then use an 'after insert' trigger to insert the data from the CSV custom object into the proper ...
0
votes
1answer
107 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, ...
2
votes
1answer
60 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
46 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
250 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
36 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
151 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 LOGGER.info("--------...
4
votes
1answer
154 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 ...
2
votes
1answer
100 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
99 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
83 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 ...