The CreatorCon Call for Content is officially open! Get started here.

Flow designer - Data pill values not available in script mode

Go to solution
AEterni
Mega Guru

‎01-27-2022 05:08 AM

Hello All,

I have recently discovered that it is not possible to drag and drop data from the data pill values of the flow inside a script.

I hope you can help me with the following requirement.

This is the script we are using

/*
**Access Flow/Action data using the fd_data object. Script must return a value.
**example: var shortDesc = fd_data.trigger.current.short_description;
**return shortDesc;
*/

var pwvalue = new GlideappMaskedQuestion().decode(new GlideEncrypter().decrypt(fd_data._1__get_catalog_variables.password));

var encodedpw = new GlideappMaskedQuestion().decode(new GlideEncrypter("xxx").encrypt(pwvalue));

var output = {"FirmId":46,"EncryptedPassword":encodedpw,"AttachmentId":"b16829cd87d541903c1da6c73cbb350d"};

return output;

 

I would like to get

  • the "FirmId" from the company table and
  • the sysID of the attachment

For the "FirmId" we usually dot.walk using the data pill values (see image below), but it is not possible when are in script mode.

find_real_file.png


For the sysID of the attachment, do you know how I can get it?

The final script should look like this one.

/*
**Access Flow/Action data using the fd_data object. Script must return a value.
**example: var shortDesc = fd_data.trigger.current.short_description;
**return shortDesc;
*/

var pwvalue = new GlideappMaskedQuestion().decode(new GlideEncrypter().decrypt(fd_data._1__get_catalog_variables.password));

var encodedpw = new GlideappMaskedQuestion().decode(new GlideEncrypter("xxx").encrypt(pwvalue));

var FirmId = xxx

var AttachmentId = xxx

var output = {"FirmId":46,"EncryptedPassword":encodedpw,"AttachmentId":"b16829cd87d541903c1da6c73cbb350d"};

return output;

Thank you.

 

 

Labels:
Preview file
10 KB
0 Helpfuls
  • 5,856 Views
1 ACCEPTED SOLUTION

Go to solution
Ankur Bawiskar
Tera Patron
Tera Patron
In response to AEterni

‎01-28-2022 01:05 AM

Hi,

you want attachment sys_id for the RITM record?

if yes then you need to query sys_attachment with current ritm sys_id

like this

var ritmSysId = fd_data.trigger.request_item.sys_id;
var attachmentID;
var gr = new GlideRecord("sys_attachment");
gr.addQuery("table_sys_id", ritmSysId);
gr.query();
if (gr.next()) {
	attachmentID = gr.getUniqueValue();
}
return attachmentID;

So your final code when I combined above script is this

var pwvalue = new GlideappMaskedQuestion().decode(new GlideEncrypter().decrypt(fd_data._1__get_catalog_variables.password));

var encodedpw = new GlideappMaskedQuestion().decode(new GlideEncrypter("xxx").encrypt(pwvalue));

var companyID = fd_data.trigger.request_item.company.u_id;

var output = {};

var ritmSysId = fd_data.trigger.request_item.sys_id;
var attachmentID;
var gr = new GlideRecord("sys_attachment");
gr.addQuery("table_sys_id", ritmSysId);
gr.query();
if (gr.next()) {
	attachmentID = gr.getUniqueValue();
}

output["FirmId"] = companyID.toString();
output["EncryptedPassword"] = encodedpw.toString();
output["AttachmentId"] = attachmentID.toString();

return output;

Please mark my response as correct and close the thread

Regards
Ankur

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

View solution in original post

16 REPLIES 16

Go to solution
sandeeprawat
Tera Expert

‎01-27-2022 05:33 AM

Hi,

I have sometimes encountered similar issue where I am not sure why a certain variable is not accessible in certain variables or loops in flow designer.

If nothing else works, try using flow variable.

It has recently been added to flow designer functionality. Consider it a global variable which you can set and use throughout the flow.

1. Define variable.

 find_real_file.png

2. Set it 

 find_real_file.png

 

Hope it helps.

Preview file
36 KB
Preview file
9 KB
0 Helpfuls

Go to solution
AEterni
Mega Guru
In response to sandeeprawat

‎01-27-2022 07:59 AM

That's very interesting, but unfortunately it doesn't work.

You can't drag and drop variables and values from the data pill into a script

0 Helpfuls