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
11
votes
4answers
2k views

Bulk API and Static Variable State

Our trigger logic has some recursion detection built in. Essentially, we have some static variables that act as counters for trigger executions. When our set "max" gets hit, our triggers quit to avoid ...
2
votes
3answers
655 views

What to use for performing operations on multiple records at once, Apex REST class or Bulk API?

I need to insert/update/delete a variable number of records at a time from a webapp (so from javascript), are there reasons to choose the Salesforce Bulk API over writing a custom Apex REST class to ...
9
votes
1answer
7k views

How to handle NULL values when inserting with the Dataloader(.io)

I'm uploading records with the amazing dataloader.io and have a hard time to upload some records with NO value for optional fields. What do I have to put in those fields? #N/A 'null' NULL '' "" 0 Is ...
6
votes
2answers
3k views

How to query archived Tasks using Bulk Api

I'm trying to retrieve all Tasks in our Salesforce instance, including those that were archived more than 12 months ago. Since we have over 3 million records, I decided to try the bulk api. It ...
4
votes
2answers
5k 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
3answers
391 views

Prevent duplicates: Trigger - Workflow Field Update- Trigger w/ Callout - AllOrNone = false

Looking for a generalized solution (for all sobjects/ all trigger-driven services) to this use case: After update trigger invoked; decides a callout via future is needed (could be related record DML ...
3
votes
1answer
329 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 ...
2
votes
2answers
3k 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 ...
3
votes
1answer
1k views

Unexpected Error while trying to perform simple Upsert

When sending the following XML and CSV, I get this error on the Bulk Data Load Job Detail screen: Got an unexpected error while processing BULK-API. Contact support with error ID: 1070223644-7484 ...
7
votes
1answer
2k views

Unable to upload an Attachment - Bulk API

I'm using Bulk API to upload attachments and getting an error: InvalidBatch : Failed to parse CSV header. Number of Records Processed: 0 While I'm getting following error at the Salesforce ...
8
votes
3answers
3k views

Bulk API Query - Splitting large query into batches

I'm currently using the bulk-api to return all records for a given sObject. I can make it work via one very large batch, but I think it would be more efficient if I could split it into multiple ...
3
votes
1answer
10k views

Exporting Data to CSV file via Bulk API

I am having trouble with my Bulk API code. What I want is to take the records in the Opportunity object, and a few of their fields, and export them to a csv file for reading. The code is currently as ...
5
votes
3answers
7k views

Setting field value to Null when using Bulk API

I am trying to create a Data Load Tool similar to Data Loader which will upload the data from a CSV file to Salesforce. This tool is built using java and using "Bulk API". While this tool works fine, ...
3
votes
2answers
774 views

is it possible to execute QueryAll() using Bulk API

We are trying to get deleted records via bulk API, is it possible. I am already aware that with SOAP API this is possible, but if we need to handle large volume of data Bulk should have this option.
3
votes
1answer
149 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' ...
1
vote
1answer
4k views

How to get the profile name and role name from User object

We already have a soql query to retrieve the User object (which returns the role id and profile id) was wondering if we could retrieve the RoleName and ProfileName from within the same query instead ...
1
vote
1answer
951 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
2answers
140 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 ...
0
votes
2answers
390 views

Query 100,000 users from Salesforce

I'm writing a software in C# that need to pull all the information about 100,000 users in Salesforce (Id, Username, all other attributes). I think to use Bulk API for that, it's the best option for ...
0
votes
2answers
405 views

How can I communicate a trigger exception to user in a bulk upsert for each record?

I am performing a bulk upsert with a large batch (sometimes as much as 3000 records at one time). I am splitting the list of 3000 into 5 batches and performing an upsert using the Bulk API. When I ...