6

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 Aug 17 '16 at 23:15
9
+50

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

Why?

  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 – Santanu Boral Aug 21 '16 at 22:31
  • Sure, Testing in sandbox before actual data load in production is best practice! – AtulRajguru9 Aug 22 '16 at 4:13
  • your approach seems to be correct and we are doing some testing in sandbox. – Santanu Boral Aug 23 '16 at 16:02
  • in the csv file how many records can we have and what is the file size limit of csv file? – Santanu Boral Sep 6 '16 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. – AtulRajguru9 Sep 7 '16 at 3:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.