Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Auto download image URL on trigger then delete after action taken...possible?

Topic Labels: API Scripting
1568 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Edward1976
6 - Interface Innovator
6 - Interface Innovator

I will be processing a very large number of social media posts in both image and video format. Due to this I will inevitably run into storage issues very quickly. I have image URLs set up like this within my table:

https://ik.imagekit.io/sq64zigvs7/tr:w-2700,h-2025,fo-auto/recNzujaQVsEqCSGr_anotherTestMarathon_140...https://ik.imagekit.io/sq64zigvs7/tr:w-1500,h-1000,fo-auto/recNzujaQVsEqCSGr_anotherTestMarathon_140...https://ik.imagekit.io/sq64zigvs7/tr:w-1200,h-630,fo-auto/recNzujaQVsEqCSGr_anotherTestMarathon_1402...https://ik.imagekit.io/sq64zigvs7/tr:w-1080,h-1080,fo-auto/recNzujaQVsEqCSGr_anotherTestMarathon_140...https://ik.imagekit.io/sq64zigvs7/tr:w-1600,h-900,/recNzujaQVsEqCSGr_anotherTestMarathon_140223_pb_1...https://ik.imagekit.io/sq64zigvs7/tr:w-1080,h-1920,fo-auto/recNzujaQVsEqCSGr_anotherTestMarathon_140...

Is there a way to automatically download these as an attachment (like if time to scheduled post is say less than 2 hours or something), then once posted, delete the attachment retaining the URL for reference?

 

1 Reply 1
kuovonne
18 - Pluto
18 - Pluto

I don’t think this will work. 

Deleted attachments that are still within your revision history (and thus could be restored in a snapshot or restored from the trash) still count towards your attachment limit.

If you use only native Airtable automations, triggering an automation based on a specific time stored in the record is very difficult and imprecise. 

Why do you need the file to be an actual attachment in Airtable?

Are you open to using a third party integration service like Make.com that can better handle time-based triggers and also have that service retrieve the file so the file doesn’t have to be an Airtable attachment?