Salesforce Developer Community

Chatter

Feed
0

Best Answers
0

Likes Received
0

Likes Given
3

Questions
1

Replies

How to use Bulk Api to upsert opportunities related to a contact?

Surely someone must have done this. Please help.

I am using the Nonprofit starter pack with contact settings set to "individual", and am able to bulk load the contacts into Salesforce, just need some pointers how to upsert/insert donations and relate these back to the contact.

thanks,

d_lam
March 25, 2011
Like
0

1 replies

Bulk API upsert help

Hi there,

I tried doing a Bulk API upsert, I have the below job definition:

<?xml version="1.0" encoding="UTF-8" ?>

- <jobInfo xmlns="http://www.force.com/2009/06/asyncapi/dataload">

<operation>upsert</operation>

<externalIdFieldName>External_Id__c</externalIdFieldName>

</jobInfo>

This works fine except when there are duplicate external ids in the data, in which case it simply ignores subsequent entries, and I get this error:

...

- <errors>

<fields>External_Id__c</fields>

<message>Duplicate external id specified: test@test.com </message>

<statusCode>DUPLICATE_VALUE</statusCode>

</errors>

<success>false</success>

<created>false</created>

</result>

The External_Id__c field is set to unique, required and external id.

I thought the first record would be treated as an insert (which it does), and subsequent records as an update but is ignored. How can I get the subsequent records in the batch to update the inserted contact?

thanks,

Dan.