Re: Hashing Md5 using scripting
0
5488
3
Okay, and is the purpose to encode the URL to avoid all of the issues with a URL parameter that is unruly and unable to meet the requirements of HTTP addresses? If so, why not simply encode the parameter?
In any case, computing an MD5 can be done with a script action, although not recommended because MD5’s are pretty intensive. The better approach might be to use a Script Block like this:
/*
***********************************************************
ScriptBloqs - MD5
Copyright (c) 2021 by Global Technologies Corporation
ALL RIGHTS RESERVED
***********************************************************
*/
output.markdown('# MD5 Example');
// load the md5 library
// not included because of space limitations...
// get the name of the table
let table = base.getTable("Airdrop");
// get the records from this table
let records = await table.selectRecordsAsync();
// Update the records
for (let record of records.records) {
if (record.getCellValue("MD5 Source"))
{
output.inspect(record.getCellValue("MD5 Source"));
// compute the md5 value
thisMD5 = MD5(record.getCellValue("MD5 Source"));
output.markdown("MD5: " + thisMD5);
await table.updateRecordAsync(record, {
"MD5 Target" : thisMD5,
});
}
}
Note that this code is not functional until you include this library at the top of the script itself. Note - if you obfuscate the library with a tool like this, the performance will double.
When this block is executed on this example data, you will get the MD5 values as desired.
