function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
FDC_CraigFDC_Craig 

Chatter Attachments

Hello,

 

I've been stuck on this one for a little while.

 

Given a list of Case Ids, Does anybody have any clue how I could go about downloading the files posted to the chatter feeds (of the cases) via data loader or otherwise.

 

Please note: I am not looking to download everything through data export, but the chatter attachments of my list of cases (aprox 150)

 

Thanks!

Scott_VSScott_VS

The binary for the file will be located in the ContentData field CaseFeed, so you can query it by:

 

SELECT ContentData FROM CaseFeed WHERE ParentId =: <Case Id>

 

The problem is that you can only query one file at a time, so 150 cases will require 150 queries. You will also have to decode the base64 encoding in order to translate the field into binary.
Jia HuJia Hu
Then, you can use Dataloader to download multiple files at one time.