I want to upload files (.doc, .pdf) from external system to the attachments of Case record.

There are two approaches I have found from Salesforce Help.

1) Uploading Attachments by data loader where I can upload attachments with or without Bulk Api option.

2) Loading Binary Attachments where I can upload attachments with Bulk Api

My question is, if some cases attachment size is more than 10MB per file and I need to upload more that 100,000 records as Case attachments then what will be best option I will choose?

  • 3
    Two favorites yet no upvotes. That is very strange behavior indeed.
    – Adrian Larson
    Commented Aug 17, 2016 at 23:15

1 Answer 1


I would suggest you to go with data loader using SOAP API, which is by default (not Bulk API).


  1. You do not need to write any code to use Data loader
  2. It is tested solution, so no bugs
  3. With SOAP API you will need around 500+ API (100000 records / 200 batch size = 500 API required) which is not too much (we have 100k API limit per 24 HRS for enterprise org).
  4. Also depending on your data and schema you may face locking issue with Bulk API.
  5. Bulk API does not allow zip file size more than 10 MB Ref: https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/asynch_api_concepts_limits.htm
  • I will investigate and let you know Commented Aug 21, 2016 at 22:31
  • Sure, Testing in sandbox before actual data load in production is best practice! Commented Aug 22, 2016 at 4:13
  • your approach seems to be correct and we are doing some testing in sandbox. Commented Aug 23, 2016 at 16:02
  • in the csv file how many records can we have and what is the file size limit of csv file? Commented Sep 6, 2016 at 14:33
  • With SOAP API there is no limit as such on rows or file size. As your csv file will be on local pc always and only 200 records (whatever batch side you define) will be posted with SOAP api. Commented Sep 7, 2016 at 3:47

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .