Download multiple attachments to local disk
Downloads all attachments for a parent (task, project, or project brief) to a folder. Specify the parent ID and the folder path; saved file names include the attachment ID and original file name. You can choose whether to overwrite existing files. For tasks, this includes inline images in the description; for projects, files in the Key resources section; for project briefs, inline files in the brief.
SELECT * FROM download_attachments
WITH (
ParentId='1206673375982078' --Id of Task , Project or ProjectBrief
, SaveFolder='c:\temp'
, OverwriteFile=1
)