is it possible to send attachment through transform map?

jobin1 · ‎02-08-2022

Hi All

My requirement is business will be encoding the attachment and sending that encoded value in excel format and the same we need to decode and transfer to ritm form via transform map.

So is it possible to do so? if yes how?. what transform script we need to use to achieve this functionality

Ankur Bawiskar · ‎03-02-2022

Hi,

So you can use this in global scope

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {
	// Add your code here
	var fileName = source.u_file_name;
	var fileContentType = source.u_content_type; // such as image/jpeg or application/pdf
	var fileData = source.u_base64_data;

	var ecc = new GlideRecord('ecc_queue');
	ecc.initialize();
	ecc.agent = "AttachmentCreator";
	ecc.topic = "AttachmentCreator";
	ecc.name = fileName + ":" + fileContentType;
	ecc.source = target.sys_class_name + ":" + target.sys_id;
	ecc.payload = fileData;
	ecc.insert();

})(source, map, log, target);

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Ankur Bawiskar · ‎03-02-2022

it should work if the base64 data is correctly encoded one.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

jobin1 · ‎03-02-2022

@Ankur Bawiskar

When i use ->sa.writeBase64(target, fileName, fileContentType, fileData);

even file is not getting attached.Also i used https://www.base64encode.org/ online tool for encoding

my script.

onafter

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

var fileName = source.u_file_name;
var fileContentType = source.u_content_type; // such as image/jpeg or application/pdf
var fileData = source.u_base64_data;
var sa = new GlideSysAttachment();
sa.writeBase64(target, fileName, fileContentType, fileData);
//sa.write(target, fileName, fileContentType, fileData);

})(source, map, log, target);

Ankur Bawiskar · ‎03-02-2022

Hi,

are you in scoped app or global scope?

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

jobin1 · ‎03-02-2022

No I am in specific domain.

Loaded excel is below

Ankur Bawiskar · ‎03-02-2022

How did it get attached earlier then when you added the reply?

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader