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
2answers
350 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
409 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
626 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
973 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
669 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
116 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
397 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
547 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
227 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
219 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 ...
7
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
158 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
201 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
896 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
127 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 ...
5
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
755 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
95 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
93 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
1k 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
563 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
496 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
347 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
31 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
110 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
519 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
148 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
53 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
76 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
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
111 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
125 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
404 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
220 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
114 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
620 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
50 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
630 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 ...
3
votes
2answers
3k views

Query Bulk Data Load Jobs once completed

Can someone tell me how to query the data which is displayed in " Monitor Bulk Data Load Jobs" Section "Completed last 7 days"
4
votes
2answers
4k 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
2k 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
58 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
313 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, ...
3
votes
1answer
142 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
105 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
1k 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
71 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 & ...
5
votes
1answer
788 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 ...