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
2
votes
1answer
635 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
62 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
888 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
737 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
351 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
67 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
76 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
71 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
42 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
941 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 ...
0
votes
2answers
372 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 ...
2
votes
2answers
451 views

Get all Salesforce's users

I'm writing a software in C# that need to pull all the information about the users in Salesforce (Id, Username, all other attributes). I want to use the Bulk API and think my query should be: SELECT ...
3
votes
0answers
676 views

BULK Api - Invalid Session ID for Valid oAuth2 Token

Hi I am building Salesforce app which authenticate users using oAuth2. When user complete authentication I am receiving access_token. When I use this token with REST API it works perfectly fine. When ...
5
votes
2answers
1k views

Rollback/Fail Entire Data Load on Error Instead of Partial Load

we have a process where we are loading events in via the Data Loader and have a before insert trigger on the event/activity to handle these records as they are being processed. We'd like that if one ...
1
vote
3answers
699 views

Bulk API Rejects Seemingly Valid Session ID

I am working with a sandbox account trying to make calls to the Bulk API. This code has worked before but right now I am getting this error back when I attempt to create a new Job. <?xml version="...
1
vote
1answer
121 views

Unable to deploy relationship field records (JSON format) using Bulk Api

I am trying to deploy contacts from source org. to target org. using Bulk Api. I am able to deploy the records in the xml format but my requirement is to use the JSON with the relationship field ...
2
votes
1answer
50 views

How to query values of Accountid in results file of Bulk API?

I am just finding out ways on how to retrieve the "Accountid" of results obtained from bulk CSV file.Will it be possible to retrieve using job id?If so Can you please explain on how to acquire it?
4
votes
2answers
492 views

What is the maximum time limit whithin which we can add batches to the Bulk data load using Bulk API

I am wondering will there be any time limit for the batches to added to a Bulk API job once after the job has been initiated and before it can be closed? To be short, how long will a Bulk API job ...
0
votes
1answer
667 views

Why I can't change OwnerId to null or empty?

I'm trying via Bulk API update Opportunity field OwnerId to empty (or null) value. But it impossible. If I set a "" (empty value string) to field OwnerId - update has success but nothing to change. If ...
1
vote
1answer
248 views

Execute apex code after Bulk Data Load job is completed. Is that possible?

I want to run apex code after Bulk Data Load job is completed. Is that possible? I know we have a place to verify Bulk Data Load jobs and their statuses. The thing is i have run an batch job on the ...
0
votes
1answer
241 views

Case bulk delete error

I am trying to bulk delete cases where for some case I am getting this error "UNKNOWN_EXCEPTION:An unknown exception has occurred.:--" I checked for all dependancies and found only CaseHistory ...
8
votes
2answers
2k 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 in ...
4
votes
0answers
168 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
2answers
234 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 ...
8
votes
1answer
1k 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
130 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 ...
6
votes
2answers
3k 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 ??? ...
1
vote
1answer
834 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 ...
1
vote
1answer
106 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
105 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 ...
4
votes
0answers
2k 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
656 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
572 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 ...
1
vote
0answers
359 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
33 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
121 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
550 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 currently ...
5
votes
1answer
166 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
55 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
83 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?
2
votes
1answer
3k 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 ...
2
votes
1answer
120 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 ...
2
votes
1answer
132 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
408 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 ...
5
votes
1answer
221 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 ...
1
vote
1answer
124 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 ...
1
vote
1answer
800 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
52 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
40 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
719 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 ...