The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
16 views

How are number of batches decided while Bulk Query and how to fetch result accordingly

I would like to know how are number of batches decided when we create a batch during Bulk Query in salesforce using createBatchFromStream() of the API. And how to handle multiple batches to fetch ...
0
votes
0answers
17 views

CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY:KT_AccountTriggers: execution of BeforeInsert

I am trying to upsert Account objects as a bulk operation with csv. I get these errors for 90-95% of the entries: "Id","Success","Created","Error" "003D000000Q89kQIAR","true","true","" ...
1
vote
1answer
35 views

Bulk API Query Explaination

So I am new to the Bulk API provided by Salesforce and I was going through their developers guide. I have few questions that need some clarification: Bulk API Query part of the guide says that one ...
0
votes
0answers
23 views

Bulk API: Query millions of records possibly size > 1GB?

Is there any way to QUERY using bulk API to get records possibly more than millon and size > 1GB. Could any one help. Thanks In advance. Rajesh C.
2
votes
2answers
53 views

Bulkd trigger skips some records

I have an object that I upsert using Dataloader, that has a unique external ID but the same ID must be used as a lookup to another object. Sadly, in Dataloader, you cannot assign a value to two ...
-1
votes
0answers
19 views

Bulk read session for version 32 with soql query containing UTF-8 getting corrupted and returning no data when data is present

I am using java api for starting a bulk read. SOQL query is being sent as InputStream. The soql query is - SELECT Account.Id ,Account.IsDeleted ,Account.MasterRecordId ,Account.Name ,Account.Type ...
1
vote
1answer
21 views

What is the best practice method to summarize contact information to leads?

Here's the business case. I want to have a reportable field on a lead that displays the number of contacts for, say, a city field match. This value could be used in reports, dashboards, snapshots, ...
3
votes
4answers
164 views

Salesforce large query conditions: query 20000 contacts by emails and update fields

I have a csv file which has 20000 email addresses in it. I need to update some fields on these contacts. the dataloader is not suitable as I don't have the ID field of these email addresses. query in ...
0
votes
1answer
30 views

Deserialize BulkAPI XML response to QueryResult

Is there anyway to deserialize bulkAPI response(XML) to Standard QueryResult object? I am using C# as backend and PartnerAPI of SFDC. See below XML. I am getting "queryResult ...
1
vote
3answers
70 views

Exporting entire database via API

We use the salesforce dataloader to do occasional exports of our entire database so we can use our local database tools to run analysis and data cleaning that we can't manage via reporting and ...
1
vote
1answer
188 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 ...
0
votes
1answer
19 views

Can't create a Task for a Contact through Bulk API

I noticed that I can create a Task under a Contact manually, through Salesforce UI, but I can't create it through the Bulk API. Can anyone explain me why and if possible, how to overcome this? I ...
1
vote
0answers
41 views

Bulk-API: How to add a batch with both CSV data and a query?

I'm trying to use Salesforce's bulk API to run a query on some CSV data. Here is the desired result: In SF, we have a field product.serial__c. I have a CSV with a bunch of serial numbers that I would ...
1
vote
2answers
114 views

How to retrieve multiple contacts with single REST call

I am getting 20 contact ID from getUpdated.Now I need information for each of these 20 contacts.It seems costly to request each contact through a REST url.Is there any way how I can query multiple ...
1
vote
1answer
35 views

If I connect through multiple users to Salesforce Bulk API, what counts toward API limit?

As stated by the title, I'm not sure if, having a connected app, the API limit is reached based on my license or users (they come from different customers, so each user has his own license with his ...
2
votes
1answer
37 views

Can I use the Bulk API to programmatically retrieve deleted and Archived records?

I am creating an application to query for large volumes of data from salesforce. Most of which are archived and deleted records. It it possible for me to use the Bulk API via C# to complete this task ...
0
votes
1answer
37 views

Convert Lead into Opportunity, what does it do and is possible to do the same through Bulk API?

I need to be able to perform a "convert" operation on multiple leads. Considering I don't know the amount of leads that will be converted, I definitely want to use Bulk API (I can end with a lot of ...
0
votes
2answers
55 views

Want to push lead data from my web app into customer's salesforce accounts - where to get started?

My company wants to integrate its application with Salesforce. Our product will need to publish lead information into the accounts of hundreds or possibly thousands of companies each with their own ...
0
votes
1answer
31 views

Best way to migrate binary attachments from one org to another

Currently I am using apex data loader with bulk api enabled and batch size =1 . But its giving me failed to create batch when i try to import 1000 files with each size around 100kb. I need to ...
1
vote
0answers
38 views

Bulk API queue and REST API actions, any way to ensure sequence?

I have an app that perform some bulk operations but also requires real time updates for single records. I was thinking if there is a way to ensure that once the bulk action has been queued, any REST ...
1
vote
1answer
43 views

Bulk Upsert: How do I know which records have been created/updated?

I read that records are in the same order as they are sent, but what happens if I upsert 5 records and only 3 are fine? For example: Fine Fails Fine Fine Fails Am I going to receive 5 records or ...
0
votes
0answers
26 views

Web service connector - not compiling the partner wsdl file

I am new to the salesforce web api. I am trying to use the web api connector to compile the partner.wsdl file. I am following exact steps mentioned in the link ...
2
votes
1answer
35 views

Is it possible to get Query AsyncApiBatch in salesforce (in SOQL)

Is it possible to get Query AsyncApiBatch in salesforce (in SOQL), I am trying to get this information so that external app could understand how many batches are consumed in last 24 hours and how many ...
0
votes
1answer
74 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 ...
2
votes
0answers
90 views

Best approach for creating Junction object with millions of records

I have two objects Object1 and Object2 in Salesforce. These two objects doesn't have Master-Detail relationship. But they are related through a Text column X. I want to create many to many junction ...
1
vote
2answers
71 views

Design Query for implementing high volume periodic imports

We plan to implement periodic bulk import of records into our Salesforce. If implemented, then we would be importing around 2-2.5 Million Records into a custom object per day. Since this is a ...
0
votes
0answers
67 views

Bulk API Query - Universal way for splitting large query into batches

I am working on way how to use the BULK API for downloading large amounts of data from Salesforce. I am currently thinking about the way how to make the automatic splitting of any kind of query. ...
0
votes
0answers
36 views

Batch Aborting on XML Query via SOAP Api

Our .net code has been working without issue for a few years now. Ever since Summer 14, the Delete batch job will abort on the Select Query. I do not have a lot of specifics but this is what I know: ...
1
vote
2answers
38 views

Bulk data load job isgetting aborted frequently

I have bulk data load job. I have job for record deletion, I use ETL tool. In tool i get error request time out and in salesforce UI i see job aborted and time taken as 1 minute 56 seconds. This job ...
0
votes
0answers
40 views

Bulk Data Load Job Has No Batches

We're running a number of jobs using the Bulk API to import data into Salesforce from our back-end platform. When the jobs are submitted, the go to the In Progress queue but do not have any ...
6
votes
2answers
140 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 ...
1
vote
1answer
76 views

Order of Bulk API result rows

I am performing multiple batch upserts using the Bulk API using an external ID field from my system. In order to determine which record ids from my system failed, I'd need the results rows to ...
4
votes
1answer
92 views

How to reliably detect whether BULK API is enabled for an org

We have a managed package which loads data into customer Salesforce orgs. We attempt to use the BULK API first and fall back to the REST API if necessary. So we need to be able to detect if the BULK ...
2
votes
2answers
135 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 ...
3
votes
1answer
68 views

Reduce size of result sets in Salesforce Bulk API

Is it possible to reduce the size of the retrieved files in the Salesforce Bulk API. Currently it creates multiple files with a maximum size of 1Gb. I would like to reduce that limit to ~100Mb. The ...
1
vote
2answers
79 views

Bulkify Apex Trigger that searches LongText for words

I have a trigger that checks a longtext field on the account for about 60 different words. It works fine on a few, but when I do a mass-update, it fails. What can I do to fix this? Below is my ...
2
votes
2answers
256 views

REST OAuth connection for Bulk API queries

Is it possible to authenticate an OAuth app for the user and then make Bulk API queries on their behalf? The results are easily going to be more than 20k records each authenticated user. When I have ...
1
vote
0answers
82 views

Using Bulk API on iOS, any library or sample project?

I decide to use bulk api to push all data on my iOS application to salesforce periodically. I have read throw the Bulk API document. It provides some sample code in java using salesforce libraries. I ...
5
votes
1answer
486 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 ...
1
vote
1answer
73 views

Is there a way to query all JobIds or BatchIds from the Bulk Data Load Jobs?

I've been writing a program that utilizes the Async API to create bulk data load jobs. I've run into issue with some jobs being left open, after completion, due to Salesforce closing the connection ...
2
votes
1answer
297 views

Bulk API Hard Delete seems to be unavailable in our org

We have Enterprise addition and I've followed the following KB article and am unable to find this checkbox option anywhere. Has anyone else experienced this issue and is this something that needs to ...
0
votes
0answers
41 views

how to send multiple records of events at once to salesforce thorugh Rest API of IOS Sdk

I have a requirement of creation of multiple events for salesforce in my application in Offline.When it comes to online, I need to insert all records at once. Is it possible to do through IOS SDK.
3
votes
2answers
122 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.
0
votes
0answers
100 views

Sending multiple attachments using BULK API

I want to send multiple attachments to SalesForce using Bulk API. please tell me what should be the endpoint in this case,what should be my CSV format ,what all headers I'll be including and other ...
2
votes
1answer
264 views

How to remove extra column from csv of bulk api in JAVA

I am importing the data in to the salesforce using Bulk API. But I am facing this issues. I am replacing the column header with the salesforce API name. But some of the heade which is not releted to ...
3
votes
3answers
403 views

Java BulkAPI exception: Field name provided does not match an External ID

This posting is in reference to this webinar and it's associated Java code regarding use of the Bulk API. Salesforce API Series: Fast Parallel Data Loading with the Bulk API ...
5
votes
1answer
388 views

Query API Limits

Is there a way to programmatically query how many API calls an organization has made for the 24-hour period? We have a program that imports data from external databases to SFDC in a fancy way, and we ...
4
votes
2answers
108 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: ...
4
votes
2answers
692 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
1answer
174 views

AllOrNoneHeader for Bulk API

I am trying to switch off Autocommit feature by using AllOrNoneHeader in Bulk API implementation through JAVA. I have searched over internet but see only example of implementing it for SOAP based ...