Upsert multiple records into salesforce with external ids

Asked May 22 '15 at 12:18

Active May 24 '15 at 21:09

Viewed 299 times

I am upserting records using php tool kit into salesforce. Salesforce have limit of 28000 inserts in a day. So to avoid this what i want to do is to insert 150 recors into one array and then inseet into salesforce. I this way 150 records will hit only once and i can upload more data into salesforce. Please help that who can i do it using php.

$this->SFLinks[$i] = new SObject();
$this->SFLinks[$i]->fields = array(
    'Name' => $fileName,
    'CanaryAMS' => $sfPolicyId,
    'Canary123AMS' => $url,
    'Description__c' => $description,
    'DocExternalId__c' => $documentKey
);
$this->SFLinks[$i]->type = 'CanaryAMS__Documents__c';
$checkreturn = $SforceConnection->upsert('CanaryAMS__DocExternalId__c',$this->SFLinks);

edited May 24 '15 at 21:09

Halvor Holsten Strand

19,829
17
83
99

asked May 22 '15 at 12:18

Shalini Vashist

What do you mean by Upsert? – chandresh_cool May 22 '15 at 13:24
Upsert filename and urls for accountids – Shalini Vashist May 22 '15 at 13:38
So your problem is how to insert at one shot? – chandresh_cool May 22 '15 at 13:44
Yes. I want to insert array of 150 records in one shot using upsert – Shalini Vashist May 22 '15 at 13:52
Yes this is doable. You can concatenate your values you want to insert and then insert at one time. Recently have done in one of the project since there was a performance concern. – chandresh_cool May 22 '15 at 13:53
Can you please provide me some piece of code as i am using above code – Shalini Vashist May 22 '15 at 14:02

Upsert multiple records into salesforce with external ids

0 Answers0