Mass download attachments?

[Tyson_VanOverhi]

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?

[drassi]

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

Airtable

Airtable: Organize anything you can imagine

Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.

[Moe]

drassi:

you can write a script using the airtable API

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.

[JoshuaUser]

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

[Tamir_Yankevich]

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

[Jose_Alberto_Fu]

This should be a priority in Airtable roadmap…

[erick_osmanto]

Yes this would be really helpful in my current project

[Alexey_Gusev]

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

[Simo_Elalj]

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.

[Hannah_Wiginton]

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

Airtable

On2Air: Backups - Apps - Airtable Marketplace

Automated External Backups of Your Data to Google Drive, Box, or Dropbox on Airtable with the On2Air: Backups app.