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?

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

1 Answer 1

Reset to default
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
Improve this answer
7
  • I will investigate and let you know
    – Santanu Boral
    Commented Aug 21, 2016 at 22:31
  • Sure, Testing in sandbox before actual data load in production is best practice!
    – AtulRajguru9
    Commented Aug 22, 2016 at 4:13
  • your approach seems to be correct and we are doing some testing in sandbox.
    – Santanu Boral
    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?
    – Santanu Boral
    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.
    – AtulRajguru9
    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 .