+ Start a Discussion
Alex Waddell 12Alex Waddell 12 

Export all attachments for individual accounts... Dataloader missing files

Hello everyone,

I recently started using DataLoader.io and it seemed at first to be exactly what i needed to get files out of individual accounts.

Here is the issue, below is a photo of all of the attachments i would like to export from the account named "Dorothy". As you can see there are probably 30+ records that i would have to download individually and then send to the intended recipient. 

User-added image

When i use data loader,I select attachment as the object, and Parent -> account name -> "Dorothy" as the field. 

User-added image

Then when i press next, i get prompted that there will be 0 records to export.
User-added image
Does anyone know why this is the case? Is the problem with the file type? 

Akhil AnilAkhil Anil
Hi Alex,

Ideally you should always filter out the Attachment query using the ParentId field and NOT the Name. Try with a query like this wherein you filter it using the Id of the Account which maps to the ParentId field in Attachment
Select Id, BodyLength from Attachment where ParentId = 'ID of the Account record here'

You should then be able to fetch all the attachments associated with this record.

Kindly mark it as an answer if that resolves your issue.