Thanks! It’s a lot better when you share all the requirements. :winking_face:
First you must fetch the binary value of the image from Airtable’s URL location. Then you must convert that image to a base64 string. Since you cannot use btoa() in the script automation, you must write a custom base64 function which is a lot of work and complex. Then you must post the payload containing the base64 string.
One alternative is to use a script block to always keep a base64 version of the image in a text field. This has some issues if the image is large. Another alternative is to create a web service using something like AutoCode that converts images into base64 strings that you can call in the website upload process. Another approach is to simply move all of this logic to the web server and have it fetch the images and perform the conversion/upload process.
This function may actually work in an automation script -
function base64_encode (s)
{
// the result/encoded string, the padding string, and the pad count
var base64chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/";
var r = "";
var p = "";
var c = s.length % 3;
// add a right zero pad to make this string a multiple of 3 characters
if (c > 0) {
for (; c < 3; c++) {
p += '=';
s += "\0";
}
}
// increment over the length of the string, three characters at a time
for (c = 0; c < s.length; c += 3) {
// we add newlines after every 76 output characters, according to the MIME specs
if (c > 0 && (c / 3 * 4) % 76 == 0) {
r += "\r\n";
}
// these three 8-bit (ASCII) characters become one 24-bit number
var n = (s.charCodeAt(c) << 16) + (s.charCodeAt(c+1) << 8) + s.charCodeAt(c+2);
// this 24-bit number gets separated into four 6-bit numbers
n = [(n >>> 18) & 63, (n >>> 12) & 63, (n >>> 6) & 63, n & 63];
// those four 6-bit numbers are used as indices into the base64 character list
r += base64chars[n[0]] + base64chars[n[1]] + base64chars[n[2]] + base64chars[n[3]];
}
// add the actual padding string, after removing the zero pad
return r.substring(0, r.length - p.length) + p;
}
