Airtable URL expiring - what is the solution? (Zapier x Airtable x Ghost)
Hi everybody,
as you can see I try to connect my airtable with my ghost CMS and I click “yes” on the field where it says “include file content, because it seems an existing problemn with Airtable.
But whatever I do in zapier, it still an outdated URL. Is there any workaroudn to fix this?
Page 1 / 1
Hmm, as a data point, I just tested this and it worked fine for me. Specifically, I sent myself an email with the all of the attachment URLs and they all loaded up fine:
The attachment in question was uploaded in February and here’s the Zap setup:
What are you trying to do with the URL? What error message are you getting and from where?
Thank you for your response.
The point is, I dont get an error. I just basically upload blog posts that are hosted in Airtable and attach a image, which I upload in my Airtable. The first 2 hours everything is perfectly fine, but after a while the picture disappear and just show a “expired” thumbnail.
You’ll need to either host the images on Ghost or find a general image host for this I’m afraid
@EK7
Unfortunately, you cannot use Airtable's attachment fields for permanently hosting images, because the attachment URLs are temporary URLs which will expire after 2 hours of accessing them for the first time.
However, you can temporarily use the attachment URLs when running your automation to download & upload the attachments somewhere else for permanent hosting.
(Or, you can just start off by hosting your images elsewhere, and reference those images in a URL field in Airtable.)
Your 2 options for hosting images are:
Hosting the image directly with your blogging platform. (In your case, this is Ghost.)
Hosting the image with a cloud storage provider, such as Google Drive.
By the way, if you’re not too heavily invested in Zapier, you may want to consider switching to Make for these reasons:
Thanks for your responses, guys. If I use make, is there any function with Make that uploads my files on Ghost by itself? I dont want to manually upload every picture manually by hand in Ghost
Similar to Zapier’s Ghost modules, whenever you are creating or updating a post with Make’s Ghost modules, you are required to use a URL of an image that is already hosted somewhere before creating/updating the post.
If you want to automate the process of uploading the images directly to Ghost before creating/updating the post, you might be able to do that by writing your own custom API calls to Ghost’s API using the “Ghost - Make An API Call” module in Make, but I don’t know enough about Ghost’s API to know if that is possible or not. You may want to ask Ghost if their API supports that.
It might be easier to just automate the process of moving your image from Airtable to Google Drive, and then you can reference the image there.
Check out the Make screenshot below for an example of how you could download a single attachment out of Airtable then upload it to Google Drive… and then create your post on Ghost.