Attachment encoding

[peterfischer]

Happy new year!

I want to add a header to a scheduled report (csv). I built an onAfter BR on sys_email table to read the attachment and create a new one:

var tableName = current.getTableName();

var sysId = current.sys_id;

StringUtil = GlideStringUtil;

var sa = new GlideSysAttachment();

var bytesContent = sa.getBytes(tableName, sysId);

var strData = String(Packages.java.lang.String(bytesContent));

...

var newData = header + '\n' + strData;

var att = new Attachment();

var msg = att.write(tableName, sysId, file, type, newData);

This is functioning well except the (German) special characters like ä, ö, ü - it will be displayed as something like this: í¯ ¿ ½ or a replacement character.

By the way: the original attachment correctly displays all the special characters.

Any help to correctly decode/encode would be appreciated.

Peter

[VaranAwesomenow]

This solution from https://john-james-andersen.com/blog/service-now/easy-base64-encoding-in-servicenow.html blog worked in utah

// var encoded = global.JSUtil.btoa(text);

var base64string = GlideStringUtil.base64Encode("^.^ JOHN ANDERSEN!");

gs.info(base64string);

//yields: Xi5eIEpPSE4gQU5ERVJTRU4h

orig = GlideStringUtil.base64Decode(base64string);

//yields: ^.^ JOHN ANDERSEN!

gs.info(orig);