Base64 conversion

[Florian_Verdon2]

Hi everyone !

I am trying to authenticate a request using Basic Auth.
I then need to base64-encode my logins.
(could encode them manually and then insert but would prefer to keep that logic in the code)

I didn’t found how to achieve this “natively” without rewriting the entire encoding function.
btoa() does not seems to work :confused:

Can anyone help me on this ?

Thanks

[Bill_French]

Florian_Verdonck:

I am trying to authenticate a request using Basic Auth. I then need to base64-encode my logins.

Can’t really say what the issue is without seeing the scripting context. Is this in a Script Block? Scrip automation? Custom App? External script accessing via the Airtable API?

If you want to learn more, you have to share the details.

[Florian_Verdon2]

Thank you for your reply.

I am trying to fetch from a Script Block.

Florian

[Bill_French]

Florian_Verdonck:

I am trying to fetch from a Script Block

Okay - that’s helpful, but not likely enough to comment more than generally. Without seeing exactly what you’re trying to run through a base64 encoding process, we’re still in the dark.

Florian_Verdonck:

btoa() does not seems to work

Given that Script Blocks are everyday javascript, btoa() should work just fine unless there are some strange characters in the string being encoded…

btoa() accepts a “string” where each character represents an 8-bit byte – if you pass a string containing characters that can’t be represented in 8 bits, it will probably break. This isn’t a problem if you’re actually treating the string as a byte array, but if you’re trying to do something else then you’ll have to encode it first.

[Florian_Verdon2]

Actually, btoa() function is not found.

Tried window.btoa() as well with no success.
I don’t really know how this function is supposed to work in the context of Airtable Script Block.

It should probably be something else than window but can’t find what.

[kuovonne · Accepted solution]

Even though I get the squiggly underlines under btoa, the code runs just fine when I use it.

There are enough times when squiggly red underlines appear for working code, that if the logic makes sense to me and the code runs, I ignore the squiggly red underlines.

[Bill_French]

Florian_Verdonck:

Actually, btoa() function is not found.

Hmm… works fine for me:

Script…

output.markdown('## BtoA() Test');

output.markdown('### User/Password');
let pw = "bfg:123456";
output.inspect(pw);

output.markdown('### Base64 of User/Password');
let b64 = btoa(pw);
output.inspect(b64);

[Florian_Verdon2]

Ok thank you, I didn’t try to run it…
I am not used to run the code when editor shows an error :grinning_face_with_sweat:

Thank you !

[kuovonne]

Just a followup note, while btoa() works for me in Scripting app (despite the squiggly red underline), it does not work for me in an automation action script.

[Bill_French]

kuovonne:

it does not work for me in an automation action script.

This is why I was so careful to understand the scripting context. This is a possible out on the script action side.

[Olpy_Acaflo]

Florian_Verdonck:

Tried window.btoa() as well with no success.

I need a DELAY method & setTimeout() is undefined (not found Window)

window is globalThis here in the Script-

-App

But it seems well reading this thread that window. prefix is neither necessary nor globalThis. prefix !

oLπ

[jloeser]

When I tried to do this in 2022, I am getting a ReferenceError. Is there an updated recommendation on how to accomplish this? My implementation is similar to the below.

console.log(btoa("STRING_TO_ENCODE"))

[Karlstens]

... and in 2023 btoa() is still not supported within a Scripting Automation? 🤨 Most frustrating!

[apg314]

For Scripting Automation, here's a solution that works well for me.

function getBambooToken(client) {
  let tokenizedString = <API_key> + ":x"
  return btoa(tokenizedString)
}

function btoa(token) {
  var Base64={_keyStr:"ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/=",encode:function(e){var t="";var n,r,i,s,o,u,a;var f=0;e=Base64._utf8_encode(e);while(f<e.length){n=e.charCodeAt(f++);r=e.charCodeAt(f++);i=e.charCodeAt(f++);s=n>>2;o=(n&3)<<4|r>>4;u=(r&15)<<2|i>>6;a=i&63;if(isNaN(r)){u=a=64}else if(isNaN(i)){a=64}t=t+this._keyStr.charAt(s)+this._keyStr.charAt(o)+this._keyStr.charAt(u)+this._keyStr.charAt(a)}return t},decode:function(e){var t="";var n,r,i;var s,o,u,a;var f=0;e=e.replace(/[^A-Za-z0-9\+\/\=]/g,"");while(f<e.length){s=this._keyStr.indexOf(e.charAt(f++));o=this._keyStr.indexOf(e.charAt(f++));u=this._keyStr.indexOf(e.charAt(f++));a=this._keyStr.indexOf(e.charAt(f++));n=s<<2|o>>4;r=(o&15)<<4|u>>2;i=(u&3)<<6|a;t=t+String.fromCharCode(n);if(u!=64){t=t+String.fromCharCode(r)}if(a!=64){t=t+String.fromCharCode(i)}}t=Base64._utf8_decode(t);return t},_utf8_encode:function(e){e=e.replace(/\r\n/g,"\n");var t="";for(var n=0;n<e.length;n++){var r=e.charCodeAt(n);if(r<128){t+=String.fromCharCode(r)}else if(r>127&&r<2048){t+=String.fromCharCode(r>>6|192);t+=String.fromCharCode(r&63|128)}else{t+=String.fromCharCode(r>>12|224);t+=String.fromCharCode(r>>6&63|128);t+=String.fromCharCode(r&63|128)}}return t},_utf8_decode:function(e){var t="";var n=0;var r=c1=c2=0;while(n<e.length){r=e.charCodeAt(n);if(r<128){t+=String.fromCharCode(r);n++}else if(r>191&&r<224){c2=e.charCodeAt(n+1);t+=String.fromCharCode((r&31)<<6|c2&63);n+=2}else{c2=e.charCodeAt(n+1);c3=e.charCodeAt(n+2);t+=String.fromCharCode((r&15)<<12|(c2&63)<<6|c3&63);n+=3}}return t}}
  return Base64.encode(token)
}

[Yourapp · Accepted solution]

Hi All!

Based on @apg314 i came up with this automated scrip that copy one value and past it i othe place in Base 64:

function btoa(token) {

  var Base64={_keyStr:"ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/=",encode:function(e){var t="";var n,r,i,s,o,u,a;var f=0;e=Base64._utf8_encode(e);while(f<e.length){n=e.charCodeAt(f++);r=e.charCodeAt(f++);i=e.charCodeAt(f++);s=n>>2;o=(n&3)<<4|r>>4;u=(r&15)<<2|i>>6;a=i&63;if(isNaN(r)){u=a=64}else if(isNaN(i)){a=64}t=t+this._keyStr.charAt(s)+this._keyStr.charAt(o)+this._keyStr.charAt(u)+this._keyStr.charAt(a)}return t},decode:function(e){var t="";var n,r,i;var s,o,u,a;var f=0;e=e.replace(/[^A-Za-z0-9\+\/\=]/g,"");while(f<e.length){s=this._keyStr.indexOf(e.charAt(f++));o=this._keyStr.indexOf(e.charAt(f++));u=this._keyStr.indexOf(e.charAt(f++));a=this._keyStr.indexOf(e.charAt(f++));n=s<<2|o>>4;r=(o&15)<<4|u>>2;i=(u&3)<<6|a;t=t+String.fromCharCode(n);if(u!=64){t=t+String.fromCharCode(r)}if(a!=64){t=t+String.fromCharCode(i)}}t=Base64._utf8_decode(t);return t},_utf8_encode:function(e){e=e.replace(/\r\n/g,"\n");var t="";for(var n=0;n<e.length;n++){var r=e.charCodeAt(n);if(r<128){t+=String.fromCharCode(r)}else if(r>127&&r<2048){t+=String.fromCharCode(r>>6|192);t+=String.fromCharCode(r&63|128)}else{t+=String.fromCharCode(r>>12|224);t+=String.fromCharCode(r>>6&63|128);t+=String.fromCharCode(r&63|128)}}return t},_utf8_decode:function(e){var t="";var n=0;var r=c1=c2=0;while(n<e.length){r=e.charCodeAt(n);if(r<128){t+=String.fromCharCode(r);n++}else if(r>191&&r<224){c2=e.charCodeAt(n+1);t+=String.fromCharCode((r&31)<<6|c2&63);n+=2}else{c2=e.charCodeAt(n+1);c3=e.charCodeAt(n+2);t+=String.fromCharCode((r&15)<<12|(c2&63)<<6|c3&63);n+=3}}return t}}

  return Base64.encode(token)

}

// Query for every record in "table1" field1copy

let table = base.getTable("table1");

let tableQuery = await table.selectRecordsAsync();

for(let tableRec of tableQuery.records) {

    b64 = btoa(tableRec.getCellValue("Field1copy"));

        // Insert records in "field2paste" table1

await table.updateRecordAsync(tableRec, {

            "Field2paste" : b64,

        });

}

Hope it is useful for someone.

[Jeffrey_A]

This is exactly what I've been trying to solve.  This solution works brilliantly!

It does timeout before it gets to the end of my record set however. 😞

Script exceeded execution time limit of 30 seconds

[Yourapp]

Hi @Jeffrey_A! Does your record set have more then 50 record?

If so, it is need to implement a 50 run limit.

I did not do that on the script because i only run one line on each time the automatation runs.

I have that limit in others automatations, so it should work on this too.