Help

Attachments uploaded via API vanish within seconds

Topic Labels: ImportingExporting
4322 14
cancel
Showing results for 
Search instead for 
Did you mean: 
Sales_Asian_Dri
4 - Data Explorer
4 - Data Explorer

Hi,
I am having a problem using Integromat to upload my email attachments to Airtable.
My process is to save attachments in Drive > Generate a direct download link (double checked that it works without requiring any login) > save all attachments in an array (multiple attachments) > upload the entire array to Airtable.

I also get the files uploaded to Airtable as seen on my Airtable base. But within seconds, all the files vanish. I am at the end of my wits trying to figure out the problem. My email is a Google Workspace account, and I am currently trying out the Pro plan of Airtable.

Also, the first few records uploaded using Zapier are still there. But Integromat uploads keep on disappearing.

2020-12-09 01_12_37-Email tracker_ Table 1 - Airtable and 23 more pages - Personal - Microsoft​ Edge

Please help!

14 Replies 14

Hi @Sales_Asian_Drive_Sh, and welcome to the community!

Yep - this “bug” has been discussed …

And most recently, this thread.

Despite the many claims [by Airtable] that this issue has been fixed, there is a preponderance of evidence to the contrary.

Sales_Asian_Dri
4 - Data Explorer
4 - Data Explorer

@Jason, In another thread, you mentioned that this issue was resolved. Could you check this issue again and see where it keeps failing?
This issue is pretty recurring, as Bill mentions.

Theo_Field
6 - Interface Innovator
6 - Interface Innovator

I am having the exact same issues, it has been driving me nuts. I don’t have anything to add solution wise, but hope to hear of a fix!

My workflow is also from google drive to airtable via integromat and I have checked the regular issues (privacy of the files/folders) and everything appears to be working correctly.

I have also tried substituting google drive with Dropbox and whilst the attachments are not being deleted they are not viewable within airtable (they can be downloaded from airtable and viewed).

I know that people are having these problems. However, I am continually NOT having this issue, so I’m wondering if this problem is only affecting certain accounts?? Very bizarre situation.

I just tried this again on my end right now… I successfully uploaded 25 files to Airtable from Google Drive via Integromat, including large .mp4 movie files and large .jpg images.

Everyone has their Integromat scenarios setup like this, yes?

Scenario overview:
image

Get a Share Link:
image

Create New Record:
image

Sales_Asian_Dri
4 - Data Explorer
4 - Data Explorer

Tried again just now. It worked. I guess it is an intermittent issue with Airtable.

This is not a valid assessment. Successfully uploading 25 files is anecdotal data; see my first referenced assessment in this thread - I tested with thousands of files to isolate the likelihood that this is related to the Airtable API. And the size or type of the attachment is irrelevant in all tests where failures occurred.

Precisely.

If you look back at all the threads, you will see a pattern of on- and off-again outcomes. It will work fine for many weeks and for hundreds – perhaps thousands – of processes, and then it will begin to skip a few, and sometimes many dozens for a single table.

For a long time I thought Integromat and Zapier were impervious to this issue, but this is not the case; various instances have emerged when even these tools have exhibited failures that appear to align with this observed unreliability.

Sales_Asian_Dri
4 - Data Explorer
4 - Data Explorer

You’re right.
I’ve had to resort to use two different Integrations to solve this issue: One to save the mail (without Attachments) to Airtable making sure there is a column for saving the message ID. And the second to run the Attachment import using the message ID if a checkbox is checked. That increases the manual work, but allows me to repeat the import in case attachment fails to show up in Airtable.

I’m sorry you’re having an issue! Resolving issues and bugs is best done directly with our support team, so please reach out (via our in-app help menu) and our team can work with you to help get things resolved.

I don’t think this is the best approach, but certainly, support needs to be in the loop.

By suggesting this one user mount the challenge alone with support requires him/her to be apprised in all facets of this ongoing issue that is well-documented by many users and across at least 8 threads.

In my view, there is enough evidence to suggest Airtable has a dysfunction and a product manager should be all over this acting as the liaison with support. Sort’a like a class-action lawsuit - there are many parties being injured by this issue and no single support ticket or person can adequately represent the interests of all users to (a) verifying the failures and (b) testing the possible remedy.

Just sayin’ …

This is the understatement of the year.

Theo_Field
6 - Interface Innovator
6 - Interface Innovator

Looks like my vanishing PDFs are back… All was working as expected for about 2 weeks and now I am having the same issues, it is extremely frustrating.

I have reached out to Support @Jason, however I agree with Bill, this must be sorted - it is clearly a bug with the API as it works perfectly for periods of times and then has issues.

As predicted and experienced by countless users including @JN_tp.

Robert_Andrews
6 - Interface Innovator
6 - Interface Innovator

I'm finding this now via Integromat/Make - uploads from Google Drive create a proto-file that has no content and immediately disappears.

I've used the same Google Drive actions as @ScottWorld - ie to generate an openly-available web share link. I've confirmed that this link does download the file.

But, when inserted to Airtable, it basically doesn't get added.

@Robert_Andrews It should work. You have to set the permissions properly when uploading the file. Please post your problem in my forums at TableForums.com, and the Make.com experts will help you out!