Here are some of the business-critical workflows that people automate with Zapier. ![]() With Zapier, you can integrate everything from basic data entry to end-to-end processes. Replace 'YOUR_TABLE_NAME' and 'YOUR_FIELD_NAME' with the name of the table and field that contains the image attachmentĬonst table = base.getTable('YOUR_TABLE_NAME') Ĭonst record = await input.recordAsync('Process PSDs', table) Ĭonst attachment = record.getCellValue('YOUR_FIELD_NAME') Ĭonst attachmentName = record.getCellValue('fileName') Ĭonst imageData = await remoteFetchAsync(imageUrl, ).then(response => response. Connect TeamUp and Airtable to integrate crucial parts of your business. Replace 'YOUR_API_GATEWAY_URL' with the URL of your API Gateway endpoint So I can now upload directly from any airtable base straight into S3 with the simple script below (created with help from chat GPT): This allows me to put image attachments to pbposters-images/input using "input**/ name.jpg" becomes "input %2f**name.jpg". It took me a little while to figure out the solution, but the trick is to use the URL encoded form of the backslash in the URL which %2f i.e. ![]() So when you try to put an object with the key including the backslash, the API gateway sees it as a new path, and you get the Missing Token error as that path doesn't exist. The other issue is the API gateway uses the same backslash (/) to split a path up. It simulates a folder in the GUI using the backslash (/) in the key name, but actually all it's doing is creating an object called "input/name.jpg", rather than an object called "name.jpg" in the "input" folder. "The problem with trying to create an item in the S3 "input" folder is S3 doesn't really have folders in the underlying bucket, only objects. However, there was an issue with uploading to a specific bucket and 'folder' which I got some help with. ![]() Permissions and roles are a little tricky but doable as a no/low coder and again well documented. In contrast, Zapier can be more complex to set up and configure due to its automation and integration capabilities. Sync Airtable Data into a Google Sheet - Used for full table. This was actually quite straightforward and well-documented on youtube. You can use updates in your Airtable Automations, Airtable Scripting, Zapier, or a Custom app. The solution I found was creating an AWS API gateway and allowing put requests to an S3 bucket.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |