The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
12 views

Call BULK API with node.js [on hold]

And without any specific salesforce node package (nforce or jsforce). Any example? For example insert a CSV into Account with Bulk API.
1
vote
1answer
11 views

How to set “MailingAddress” (address type) field on contact through Bulk API?

I'm having problem setting the "MailingAddress" field on Contact sObject. I'm trying with the following: <?xml version="1.0" encoding="UTF-8"?> <sObjects ...
2
votes
1answer
15 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 ...
-1
votes
0answers
10 views

How to check if user is authorised to get status of BULK JOB?

I am facing an issue while getting status of Bulk job. It throws error "Bad Request - 400" for a particular user Can this be checked before hitting a call for the Job Status? How I can acertain ...
-1
votes
0answers
15 views

Filter Data for REST API based objects like Campaings and Assets for Fuel SDK

My requirement is to retrieve all the data for Exact Target objects. The fuel sdk and soap api support controlling the number of rows/columns returned using Properties and Filter. Is there a way to ...
0
votes
0answers
20 views

What API/SDK to use for querying Exact Target data?

I have a requirement to query and extract the Exact Target data in bulk. I want to be able to get this data in chunks for large volumes of data. There is also a requirement to limit the number of rows ...
2
votes
1answer
40 views

Bulk data update in Salesforce from External System

I have got a requirement to update 6k records in Salesforce from external system in every 4 hours. Can you please suggest what would be best way for this . 1) Should I use the standard Bulk API ? ...
1
vote
1answer
30 views

Bulk Querying AccountFeed results in Binary field not supported error

While running the Bulk export in Java in CSV format, I get an error while the XML does not return error. I tried documentation which does not yield any results. Can I get specific error that relates ...
4
votes
1answer
41 views

How many batches can be created in a JOB via Bulk API?

I went through limitations about Bulk API but could not get explanation on the limit of Batches created per job in Salesforce. I can read Batch limitation but no limitation in Job. Your help is ...
2
votes
2answers
65 views

INVALID_ID_FIELD when upserting an attachment through Bulk API

The situation is as follows: In my Salesforce org, I have a contact, let's call it Humpty Dumpty, and I'd like to attach a file to it, let's call it cooking.txt, but there are some rules: If there ...
2
votes
0answers
29 views

Bulk Import Leads From SQL Table and store leads id back into table

I need to bulk import leads from sql server table, get back the newly created leadid and store them back on sql table. I read documentation on salesforce bulk api. Salesforce returns a response with ...
1
vote
1answer
64 views

Import CSV into Salesforce (Group Edition) automatically

I'd like to import CSV file into Salesforce automatically, e.g. once a day. I can't use Data Loader (Bulk API), because I don't have the needed edition. Is there any other, simple way?
0
votes
1answer
24 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
0answers
59 views

Bulk API : Querying multiple objects in parallel

I am working on retrieving all the records for a few set of objects such as Accounts, Contacts, Account Partner, and a few custom objects, etc. I have obtained all the fields through the describe() ...
0
votes
2answers
55 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:- ...
0
votes
0answers
27 views

Bulk Query Questions

I have gone through the Bulk API guide. And I have come to know that we create only one batch when doing a bulk query and salesforce may return single or multiple result ids. Is my understanding of ...
0
votes
0answers
26 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
34 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
67 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
38 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
61 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
vote
1answer
23 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
183 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
49 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
104 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
404 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
28 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
48 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
139 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
40 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
56 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
42 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
80 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
36 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
46 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
58 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
28 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
38 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
82 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
95 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
75 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
83 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
40 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
44 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
48 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
149 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
84 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
121 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
145 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
72 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 ...