Airtable / Xano CDN automation

automation.js

const xanoBaseUrl = 'https://xc0b-vcze-d4we.n7.xano.io' // Edit this variable to match your Xano instance subdomain
let table = base.getTable('property')

let config = input.config()
let recordId = config.updatedRecordId

let record = await table.selectRecordAsync(recordId, {fields: table.fields})

let images = record.getCellValue('images') // Update this value to match your image/file attachment column
let imagesUrlCdn = []

for (let image of images) {
    let imageUrl = image.url
    let result = await fetch(xanoBaseUrl + '/api:SJOHbPGi/upload/image', { // Update this path to match your Xano upload file endpoint
        method: 'POST',
        headers: {
            'Accept': 'application/json',
            'Content-Type': 'application/json'
        },
        body: JSON.stringify({'content': imageUrl})
    })
    let response = await result.json()
    let imageUrlCdn = xanoBaseUrl + response.path
    imagesUrlCdn.push(imageUrlCdn)
}

await table.updateRecordAsync(record, {
    'images_urls': imagesUrlCdn.join() // Update the key to match your newsly created URL column
})