+ Start a Discussion
Nitin ParandeNitin Parande 

General Design/Approach Question - Storing Files/Attachments for Users


Want to get feedback on best way to design following :
Our legacy(non-salesforce)  system currently sends users daily emails with attachments, Our requirements is to send the emails to Salesforce and store the attachments in Salesforce where users can access. We plan to use email API. Currently checking limitations of it like attachment size, no of emails, frequency  etc.
1. Users should not be able to access attachments of other users
2. The Role-Hierarchy should apply. Meaning the users manager in the role-hierarchy setup should be able to see the attachments of his subbordinates.
3. When user leaves the company the attachments needs to be visible to other user who replaces him
4. The attachments should be able to be downloaded  from salesforce using REST API for other systems to pull it down.

There are various ways you can store files/attachments for users - in personal library/folders, attachments to objects, documents etc.

What is the best way to store the files which will satisfy all others requirements. We have to use the email-API method for capturing the files as we don't want to change out external system.

Any ideas ?

Thanks