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

jobin1 · ‎03-07-2022

@Ankur Bawiskar Great you're code is working. But having issue when I am trying to decode 2 ritms in single load that means decoding is happening only for 1 RITM in excel.

Ending with 06 decoded correctly but for 74 noting attached in RITM

Ankur Bawiskar · ‎03-07-2022

Hi,

if it worked for 1 row then it should work for other as well

try to debug for that RITM in sys_attachment any file is present or not

Regards
Ankur

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

jobin1 · ‎03-07-2022

@Ankur Bawiskar Sorry i missed to give file type and content type now its working .Thanks Ankur

RAJU MANGA · ‎06-01-2023

Hi ankur

I used your code in transform script.

But After opening the attachment, I am not seeing the data in any pdf,word,excel file and I am seeing the data in text files.

After downloading the pdf file, I am seeing the empty content

Original file

Can you give me the solution for this, please.

Thanks

Regards

Raju Manga

Ankur Bawiskar · ‎06-01-2023

@RAJU MANGA

it has worked for other member earlier.

are you sure you are sending correct base64 data?

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