Feb 19, 2024 02:17 PM - edited Feb 19, 2024 02:25 PM
I have an automation that uploads attachments to OneDrive, then adds them to Airtable with their publically accessible URL. This has worked for for well over 2 years, and a few months ago, randomly stopped with no changes on my end. No errors get thrown anywhere, and we can actually see an attachment pop in for a second in Airtable and then clear out. The revision log appears to show me adding the attachment, then deleting it.
After weeks of forking around and thinking I was going crazy, I stumbled upon another form post and Lo! 'tis apparently a known issue. By even posting this thread, I'm probably going to make one of the veterans of this forum lose their **bleep** mind, but there isn't a solution on any of the many many many existing threads other than "use a different provider" which is clearly not, like, a viable solution.
Sooooo..... does anybody have any updates on this? I'd really like to not switch to a different platform as we already pay for OneDrive, and given as this has happened to folks using Google Drive as well I don't even know what to switch to 🙃
Feb 19, 2024 05:27 PM - edited May 24, 2024 08:34 AM
What is the URL of the attachment?
— ScottWorld, Expert Airtable Consultant
May 24, 2024 08:04 AM
Same here, with google Docs and Make.
It works correctly in another base... 😅
May 24, 2024 08:34 AM
This is a common problem that usually indicates that the file is not publicly accessible at the URL that you are providing Airtable.
— ScottWorld, Expert Airtable Consultant
Aug 21, 2024 03:42 PM
If your still working on it I was able to make this work with a very small script function with AWS blobs. As Scott says above it needs to be publicly accessible. With AWS you can create a presigned link that expires quickly which is what I am doing and once you post the link it uploads. Very easy and although I am using a lambda function in aws it costs only less than next to nothing a month for many thousands of transactions. If its more than a dollar I'd be surprised