The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
0answers
20 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
34 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
18 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
18 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
27 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
23 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 ...
1
vote
0answers
44 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
40 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
60 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
75 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
50 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
70 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
118 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
61 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 ...
4
votes
1answer
249 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
55 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
117 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
28 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
81 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
65 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 ...
1
vote
1answer
159 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
167 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 ...
4
votes
1answer
306 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
71 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: ...
3
votes
2answers
414 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
107 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 ...
3
votes
1answer
2k views

Exporting Data to CSV file via Bulk API

I am having trouble with my Bulk API code. What I want is to take the records in the Opportunity object, and a few of their fields, and export them to a csv file for reading. The code is currently as ...
1
vote
2answers
159 views

Cannot close job with Salesforce Bulk API

Though I can create jobs and add batches with the Bulk API, when I try to close a job Salesforce tells me that it can't parse by doing a POST request to ...
3
votes
1answer
124 views

Bulk API - Records in different parallel batches not visible in trigger

We're loading thousands of records into a custom object (Address__c) over the Bulk API, in parallel mode. It has a Master-Detail relationship with Contact There's a checkbox field on the object ...
9
votes
1answer
521 views

How to convert Person (consumer) Account to Business Account and keep the same URL

The backstory: The org I am working in allows Person (consumer) and Business records to be created by users and a host data push process in Account. As a result, today we have a large number of each ...
6
votes
1answer
149 views

Recommended architecture for bulk-refreshing Salesforce?

We would like to keep Salesforce synced with data from our organization's back-end. The organizational data gets updated by nightly batch processes, so "real-time" syncing to Salesforce isn't in view. ...
3
votes
1answer
283 views

SOQL query to load all documents in a content library

I am trying to query for all the documents in a library using the BULK API. The SOQL query I use is SELECT ...
-1
votes
1answer
229 views

Bulk Api SAlesforce in C# to insert data to salesforce from csv file

Hie, In reference to the code provided here on the above link: Unexpected Error while trying to perform simple Upsert This code inserts static data to salesforce using bulk api,But i want some sample ...
3
votes
1answer
303 views

Disable Data Loader by Profile

Is it possible to disable the data loader based on profile (or role)? We have some non-tech users who like to use the data loader for bulk updates, unfortunately, they are also making mistakes when ...
2
votes
0answers
740 views

Why we get “input stream can not be null” error while implementing Bulk API

i tried implementing an example of bulk api provided at link : http://code.google.com/p/sfdc-bulkapi-demo/source/browse/trunk/demo/src/com/jeffdouglas/BulkLoader.java At run time, i am getting ...
1
vote
1answer
191 views

Got ConnectionException while implementing bulk api

i tried implementing an example of bulk api provided at below link : http://code.google.com/p/sfdc-bulkapi-demo/source/browse/trunk/demo/src/com/jeffdouglas/BulkLoader.java At run time, i am getting ...
1
vote
1answer
1k views

Need sample code on bulk api, for beginners [closed]

Can any one plz help me in understanding and implementing Bulk API. Can i get a small sample code which clearly demonstrates how bulk API works. I am totally new to this. (I have initially worked ...
2
votes
1answer
188 views

APATAR - MySQL Data Integration to Salesforce

We are trying to migrate data from MySql to Salesforce through APATAR. I created transformation and the complete data (For Example:1,00,000 Records) was available up to transformation level, But in ...
3
votes
3answers
570 views

Integrating SQL Table Data into SalesForce Custom Object

Does anyone know whether it is possible to migrate SQL Table data into Salesforce custom object? Thanks in Advance.
3
votes
0answers
186 views

SalesForce Bulk API: query relation on another custom object external id

I want to run a simple select query on a table, and include externalids of entities rather than salesforce ids... This is my soql query normally works to select external id of User object : select ...
2
votes
1answer
307 views

How to perform upsert in SalesForce Bulk API with Multiple Update Key?

I created some classes in Java, which integrate my existing system with SalesForce via Bulk API. The component runs smoothly when inserting new objects. I was wondering how it would be possible to ...
2
votes
1answer
386 views

Unexpected Error while trying to perform simple Upsert

When sending the following XML and CSV, I get this error on the Bulk Data Load Job Detail screen: Got an unexpected error while processing BULK-API. Contact support with error ID: ...
2
votes
1answer
480 views

Confused about the API options to

Problem: I'm looking for the REST API that would retrieve on-demand a large number of records in bulk from the Salesforce accounts and other tables. This is to faciliate integration of Salesforce ...
1
vote
0answers
184 views

Bulk API getUpdated contacts

Is there a way to get updated contacts from salesforce with Bulk API. With SOAP API I can write it like this: SforceService binding; // login .... binding.getUpdated("Contact", startDate, ...
6
votes
4answers
870 views

Bulk API & Foreign Key Resolution on Lookup Fields

We are designing an Integration leveraging Bulk API & Enterprise WSDL (The client code is handled by the source system). The target Force.com Object has few Lookup Fields. Wanted to understand how ...
5
votes
1answer
314 views

SalesForce Batch Compression Unexpected Error

In SalesForce' Bulk API, on page 60 of their documentation: Compression The only valid compression value is gzip. Compression is optional, but strongly recommended. Note that compression ...
2
votes
2answers
2k views

How to perform upsert in SalesForce Bulk API in C#

I have created a class with which I can insert, update and delete records from SalesForce using their bulk API. I have searched the web and have come across various resources; but I cannot seem to ...
3
votes
1answer
318 views

Inserting 'Log a Call' task using REST API

I am currently trying to insert a new 'Log a Call' task for accounts / contacts using the REST API. I have the information I require from the calls in an SQL database table including the ...
7
votes
1answer
297 views

Bulk API Query - Splitting large query into batches

I'm currently using the bulk-api to return all records for a given sObject. I can make it work via one very large batch, but I think it would be more efficient if I could split it into multiple ...
3
votes
1answer
788 views

How do I perform a query to the salesforce bulk API with the salesforce_bulk_api gem?

I'm trying to perform a bulk query to salesforce with the salesforce_bulk_api gem. I am connecting successfully and doing the query with no problems but I can't get the actual results. This is what I ...