Skip to main content

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
-1 votes
1 answer
28 views

Using SF Bulk API for Coupon Assignment

I am trying to understand how to use the SF Bulk API for coupon assignment. I am referencing the documentation https://tidbitsforu.com/send-sfmc-sfdc-using-ssjs-bulkapi2/ and want to understand the ...
0 votes
1 answer
2k views

How can I abort all of bulk job at a time

I have a lot of jobs open in Setup -> Bulk Data Load Jobs. How can I abort them all of them at a time.
1 vote
0 answers
47 views

Did the bulk 2.0 query change how it batches over the weekend and how do I fix it?

We have been doing a bulk v2 query for a long time now and suddenly saturday morning (May 25, 2024) it began behaving differently. Prior to saturday each query would create 2 total batches, one with 0 ...
0 votes
1 answer
1k views

Bulk API 2.0 Close Request Failing - Cannot specify query parameters in the resource

I am doing a POC on the BULK API and have run through this trailhead: https://trailhead.salesforce.com/en/content/learn/modules/api_basics/api_basics_bulk where you call the BULK API through WorkBench....
0 votes
0 answers
26 views

Support for order by /limit with Bulk API 2.0 V2

I'm asking a question regarding SFDC Bulk API 2.0. As per the limitations mentioned here - https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/queries.htm#limits, using limit ...
0 votes
1 answer
3k views

Delete records using Bulk API

Can you please tell me how to delete records in Salesforce using Bulk API? The process of deletion itself is known to me. I am interested in how I understand which dependencies should be removed. ...
3 votes
1 answer
1k views

Performance of query job using Bulk API V1 vs Bulk API v2

I am currently using Bulk API v1 query job to extract data out of Salesforce. In this case by using pkChunking, extract job of 150k records completes within 30-40 seconds. However, now when I am ...
4 votes
3 answers
1k views

Is there a *public-facing* list of GACK codes?

While Salesforce's internal processes are somewhat shrouded in mystery, we have been allowed a high-level look at the GACK process. What our team is noticing is that certain GACK IDs are consistent : ...
0 votes
1 answer
986 views

Salesforce SSL Cert imported into java trust store for integration works on the day imported but gives certificate error the next day

I am importing the Salesforce SSL certs for the test.salesforce.com and our sandbox environment using the commands below in a VM server environment. Import test.salesforce.com or login.salesforce.com ...
0 votes
0 answers
36 views

simple_salesforce bulk insert function causing a disconnect error

sf.bulk.object_name.insert(list_of_records,batch_size=100,use_serial=True) I'm using simple_salesforce to bulk insert records but once in a while it causes this error. ConnectionError: ('Connection ...
0 votes
1 answer
1k 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 ...
0 votes
1 answer
22 views

How can we leverage API to bulk upload File Links with relation to parent records

We are trying to leverage Bulk API to upload File Links We create an Bulk API ingest job using the following URL: https://{{Domain}}/services/data/v59.0/jobs/ingest and Body: { "object" : ...
0 votes
0 answers
65 views

Bulk API query - escaping quotes in JSON payload

I am building an app to access and curate data from a salesforce installation. We will be organizing manufacturing companies, but many companies inside the salesforce DB are non manufacturing. In the ...
1 vote
2 answers
2k views

Bulk Query with PK Chunking enabled sometimes does not return all the batches

The requirement is to use Bulk Query API with PK Chunking enabled, and to create CVS files for each batch with the chunk-size For example, in the Account Object if I have 80,000 records, and have the "...
1 vote
1 answer
844 views

Using C#, how can I get a jobId for Bulk Api 2.0?

I am trying to set data from an Azure Service Bus to an instance of Salesforce using the Bulk API 2.0 and and REST (because who really wants to deal with SOAP?). I am currently struggling "simply&...
2 votes
1 answer
40 views

Can I use Bulk API to automate insertion of Knowledge Data Category Assignment?

When I try to execute command sf bulk upsert for Knowledge__DataCategorySelection I receive an error No create/update access for object:Knowledge__DataCategorySelection. sf data upsert bulk -s ...
4 votes
2 answers
863 views

Retrieve ActivityHistory via Bulk API?

I'm trying to download all of the ActivityHistories from our SFDC account. I would like to use the Bulk API to avoid hitting the API rate limit for the day. I'm using the following query to do so: ...
0 votes
0 answers
77 views

simple_salesforce bulk query - timed out

I'm encountering timeout errors when fetching records from Salesforce via the simple_salesforce library and executing a SOQL query, particularly during bulk updates for a specific date. Currently, the ...
0 votes
3 answers
3k 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
1 answer
1k views

PK-chunking alternative for unsupported objects?

I'm trying to do some queries through the Bulk API, and I'd like to use the PK Chunking Header. From the documentation: PK chunking is supported for the following objects: Account, Campaign, ...
0 votes
1 answer
81 views

Bulk API to query all data too slow

I am trying to write a function in Python that can query all Salesforce Object data. I'm utilizing the salesforce_bulk Python Library. This is an overview of what I've written: def ...
0 votes
1 answer
64 views

How to set a date field in salesforce to empty through salesforce bulk api from python

How can I use the Salesforce Bulk API from Python to set a date field in Salesforce to be empty/null for multiple records in a bulk operation? I have tried with following None - request accepted and ...
2 votes
1 answer
979 views

Bulk query from SFDX CLI - How to get all results

I'm querying a large (1+ million) number of records from the SFDX CLI: sfdx force:data:soql:query \ --targetusername '[email protected]' \ --soqlqueryfile "my_query.soql" \ --...
9 votes
2 answers
5k views

Problem creating Job in Bulk API

I have been successfully able to use REST API for my application but I found that Bulk API will be better for my application. So, now I am trying to switch to Bulk API but I am stuck at the first step....
-1 votes
1 answer
439 views

How to get all the Bulk Data Load Jobs submitted by a particular user?

Want to find out if an integration user has submitted any bulk data load jobs in the org. https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/get_all_jobs.htm doesn't provide ...
2 votes
1 answer
110 views

Bulk API V1 Query showing a batch size of only 1 for 144717 records. Why?

From Salesforce documentation and questions such as Bulk api query batch size limit is 10,000 records, it appears that the batch size limit is 10,000 records for V1 bulk API. Also listed here: https://...
0 votes
0 answers
38 views

Bulk API 2.0 and Attachments Upload [duplicate]

Does Bulk API 2.0 support Attachment upload related to Account (for example)? I checked the documentation and it shows Binary attachment upload using Bulk API and not V2.0. Reference link - https://...
0 votes
0 answers
688 views

LWC: upload and process a CSV

I am developing a Lightning Web Component that uses the Bulk API 2.0 to insert a large amount of data to Salesforce, exposing the functionality to non-technical users without access to the Setup. So ...
0 votes
1 answer
58 views

Extended Response Time with simple_salesforce Library's upsert method

Problem Statement: I'm encountering prolonged response times exceeding 30 seconds while using the simple_salesforce library to perform upsert operations in batches using the bulk functionality. The ...
4 votes
1 answer
795 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. ...
0 votes
0 answers
117 views

Recommended way to retrieve large number of records using record IDs returned by getUpdated() call?

I'll start off by describing how I understand the intended use of the getUpdated method. The Salesforce docs recommend using the getUpdated() method from their data replication API to retrieve records ...
0 votes
1 answer
784 views

How to investigate an InvalidBatch?

Forgive me, I'm the messenger: Our devs have copied our Demo data to their Local, and when sending to the Bulk Data API, it goes through fine. When our Demo sends the data automatically, we're getting ...
0 votes
0 answers
96 views

Trying to find objects that are capturing the row lock, bulk data load jobs, failed flows, etc

I'm trying to monitor the below issues. Could someone please help us to get insights on which object the below information gets captured. Row lock errors/issues Bulk Data load Jos errors/issues Audit ...
0 votes
1 answer
390 views

Bulk Api 2.0 max 2 retries instead of 10

I recently started huge PricebookEntry bulk update, around 40 mln records in one of sandboxes where locks are unavoidable. I am relying on the documentation that 10 retries are guaranteed per batch: ...
5 votes
3 answers
12k views

bulk api text/csv CRLF error

So I recently completed trailheads API trail and for practice, I am trying to insert Product using bulk API For Creating Job, I've sent following json as the request body { "operation" : "insert", ...
1 vote
3 answers
1k 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:- https://...
2 votes
1 answer
4k views

REST api to upload multiple notes and attachments at once

I am working on an app that allows customers to upload images, video, (even gif) into my app. Once the case is processed on my app, I want to place those media files into Salesforce. I have a case ...
-1 votes
1 answer
26 views

Parent Field Lookup Via Text (No External id)

Just curious how dataloader.io allows the functionality to lookup parent record via text field , email field etc. https://prnt.sc/wb50K_LtH3mP Does dataloader.io queries all the parent id via these ...
1 vote
1 answer
135 views

Where are Bulk API queries to MetadataComponentDependency supported

The documentation suggests that you can query MetadataComponentDependency using the Bulk API. It seems to work fine in my scratch org sandboxes, but not in a DE org. Does anyone know if this is this a ...
0 votes
0 answers
114 views

Why is Account name exportable in bulk api but not billingaddress?

From what I read online compound fields are not exportable using bulk export. services/data/v58.0/query/?q=SELECT DurableId, IsCompound FROM FieldDefinition where EntityDefinitionId='Account' AND ...
4 votes
3 answers
381 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 ...
1 vote
0 answers
685 views

Record with duplicate external id was inserted through bulk API upsert

I have Account with user id as external id. I have a record of Account with user id 123 created 2 months ago. I have an upsert job created through bulk API yesterday with user id as ...
1 vote
2 answers
410 views

Bulk API Query Job in Apex with big response

I have a task to query a million records from one org and then upsert them in another org. I use a Bulk API query job to get all records. HttpRequest request = new HttpRequest(); request.setEndpoint('...
1 vote
1 answer
1k views

Bulk API v2.0 Failed records are confused

I'm developing code in java for upload data to Salesforce. All did fine but I've a problem with failed records with bulk API 2.0 with upsert action I have the next file csv for upload data for ...
2 votes
1 answer
2k views

Unable to Obtain Failed Bulk API Records

I am trying to pull the failed records from a bulk job that I have using this API call: https://COMPANYNAME.my.salesforce.com/services/data/v56.0/jobs/ingest/{jobId}/failedResults This API call is ...
0 votes
1 answer
444 views

Postman API - Attachment is not a supported object

When running this Bulk V2 query in Postman I get the following error. Query: SELECT Id FROM Attachment WHERE ParentId = XXX Error: "errorCode": "INVALIDJOB", "message": &...
0 votes
1 answer
272 views

Prevent CPU Time Exceeded Governor limit

I have a very small flow. It simply calls an apex action, then an update records element. This is set to run on create or update on the account object. Here's a picture: Although this flow is pretty ...
1 vote
1 answer
567 views

How does Record Locking work in bulk uploads?

I am uploading about 800 records into salesforce using the salesforce inspector extension with the data import option. Per normal bulkification standards, the batches run in increments of 200 records ...
4 votes
3 answers
2k views

Execution order of multiple Duplicates rules on an Object

I have two active duplicate rules on Account object. Is there a particular order in which they are executed? or is it random? If a record is marked as "duplicated" by a Duplicate Rule, this record ...
-1 votes
2 answers
164 views

Bulk update of custom field value in salesforce object failing due to custom validations and triggers

I added a custom field to opportunity salesforce object. It's name is externalId__c. The field is added to the object. However when I am trying to update the value of externalId__c for all the records,...

1
2 3 4 5
9