Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Mass download attachments?

11234 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Tyson_VanOverhi
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a records with attachments that I have filtered down to just what I want to download. Is there a way to download all the attachments of the filtered records? Or do I have to walk through each record downloading each individually?

17 Replies 17
drassi
6 - Interface Innovator
6 - Interface Innovator

Just through the airtable website, no I don’t think there’s any mass download option.

If you are going to do it often, or if you have a huge number of downloads, you can write a script using the airtable API. The API lets you specify a particular view to list, and contains attachment URLs that you can fetch from your script

Moe
10 - Mercury
10 - Mercury

For those who are not technical, we built a tool that allows anyone to Bulk Download Attachments from Airtable instead of downloading each record individually. You can also limit it to only export attachments from a specific Airtable view.

Screen Shot 2020-01-10 at 1.38.13 AM

Please just integrate a function to allow bulk downloading… it’s been YEARS without any such function. Second-rate.

^ bump. this would be really great and save tons of time.

Jose_Alberto_Fu
6 - Interface Innovator
6 - Interface Innovator

This should be a priority in Airtable roadmap…

erick_osmanto
5 - Automation Enthusiast
5 - Automation Enthusiast

Yes this would be really helpful in my current project

Hi,

insert new field with formula (set your field name)

IF({Attachments},
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(
'curl -o "' &{Attachments},
'(https:','" https:'
),')',''),
',',' & curl -o "')
)

copy whole column. paste it to cmd window
may be a bit bugged if filename contains round brackets or comma

Here’s a cleaner formula.
(limitation: it only gets the first attachment).

IF(
  {Attachment},
  'curl -o "' &
  SUBSTITUTE(
    SUBSTITUTE(
      REGEX_REPLACE(
        SUBSTITUTE({Attachment}, '"', ''),
        '(.*?) \\(https(.*?)\\)',
        '$1" "https$2"'
      ),
      '(',
      ''
    ),
    ')',
    ''
  )
)

Copy then the content of the formula column, paste it on a file batch_dl.sh and then run it sh ./batch_dl.sh.

You can do this with our On2Air Backups extension. It exports all table data and attachments to Google Drive, Dropbox, or Box.

______________________________________
Hannah - On2Air.com - Automated Backups for Airtable