function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
mromanimromani 

Batch Updates

Hi, my company has just joined SF, and we want to migrate our data from our DB to SF.

I already created all the structure (objects / tables) in SF, so now all thats left is to push my data into SF.

I wrote a .NET app which utilizes the salesforce API to add the data, but i just realized that we have a max 5000 api calls per 24hr.

 

So i was just wondering, is there a way i can do batch upserts, that way i dont go over the limit?

 

Sample Code:

 

sforce.UpsertResult[] upResult = binding.upsert("LangID__c", objList);

 

objList is an array, so i was wondering, can i just add a bunch of objects in there and then make the call to do the upsert? Is there a limit to how many i can add in this array of Objects?

 

Whats the best way to go about this?

 

Thanks for the help!

Nick34536345Nick34536345

Yeah you can upsert in batches of 200 through the API.

Also if you still might hit the limit, you could ask support to temporarily increase your limit for your initial upload.