Converting base64 to URL to upload to airtable

Hi,
I am stuck on an issue. I took in a video and wanted to compress the video to upload it to airtable. I used the attached post How to use ffmpeg in a workflow. I got it to work as expected. I was able to change it to base64 using Fs. I am now looking to upload that to airtable via airtable api. After doing a bit of research I found airtable api only accepts URL and no base64. Could someone help me out and tell me how I can upload this base64 to airtable api as an attachment or convert base64 to URL.

Thanks
Micheal

Hi @michealdunne14,

Awesome, glad you were able to get this far and you’re just on the last step of building the connection.

To pass a URL to Airtable containing your video, we’ll need to host it publicly somewhere temporarily so Airtable can download the video to their own file storage.

Maybe you can try using the built in upload to Google Drive action? That should return a URL for you to pass to Airtable for processing.

The only caveat is making sure the uploaded file is public so Pipedream can download it.

I hope this helps!

Hi @pierce

Thank you for the response. I have tried to get this working with google drive and airtable. I can get the file to airtable but airtable wants me to log in to google to access the file. This is not really what I wanted. I just want the raw URL that will give the Image. Any other ideas would be appericated.
Thanks
Micheal

Hi @michealdunne14 , I see - I was hoping that the result of the uploading a new file to Google Drive would return a public URL for you to pass to Airtable’s API.

The other alternative is to use our built in upload to S3 destination: Amazon S3

After uploading to S3 you’ll be able to send those links to Airtable so they can download the files. Just make sure that the S3 bucket’s permissions are public so Airtable can download them.