My users have requested that I export all files that they have attached to Cases so that they can place them in a repository for non SalesForce users to access.
In the past when I want to export actual files in previous Orgs, I have exported the Attachments object via dataloader.io and received a Zip file of all actual files. Unfortunately, I don't believe these Files/Attachments are stored in the Attachments objects because when I Query that object, I get zero results (there should be thousands). I believe that is because in the new SalesForce file system they are stored using Content Documents and Content Versions. However, when I try to export these a) I am unable to limit the query to those attached to only Cases and b) I do not actually get a zip of the files, just a CSV with the fields related to the records and some gibberish (file compression blob in csv form?) mixed in.
Users are attaching these files via the "Attachments" related list on Cases. What is the best way that you can recommend for me to export the actual files that are attached to all cases?
My first solution was to enable the "Query all Files" permission on my profile. This allowed me to see the full spectrum of files, however I am still unable to get actual files downloaded.
Thank you very much for your time.