|
Until today, there is no way to modify the value of catalog variables in Flow Designer using an Action. But with the help of a small self-developed Flow Action this functionality can be implemented quickly, and this article shows how to do that.
At Flow Designer create a new Action "Update Catalog Variable" and then configure it as follows.
|
|
Inputs
We need mandatory 3 input variables for this Action: the Requested Item, which holds all catalog variables and the name, as well as the new value.
Script Step
Insert a script step with the following parts:
Input
Script
Enter the following code into the script field:
(function execute(inputs, outputs) {
try {
var variables = inputs.requested_item.variables.getElements();
for (var i = 0; i < variables.length; i++) {
var question = variables[i].getQuestion();
if (question.getName() == inputs.variable_name) {
question.setValue(inputs.variable_value);
}
}
inputs.requested_item.update();
outputs.state = 'success';
}
catch (e) {
gs.error(e);
outputs.state = 'error';
}
})(inputs, outputs);
As you can see, there is a try-catch block to protect the flow from unexpected errors. Furthermore, the script returns an output variable "state", which helps the calling Flow to react on the respective behavior.
Outputs
The mentioned "state" output has to be configured at this section:
Testing and Publishing
You can easily test that Action with a given Requested Item. And then don't forget to publish your new Action!
Integration into a Flow
After setting the "Service Catalog" trigger you can configure the new Action:
Note:
It is not necessary to insert a "Get Catalog Variables" action, as the new Action updates the Requested Item directly
Optionally, you can query the status after executing the Action and branch accordingly:
Hi,
Thank you for this description, it's working on existing RITM's created from Service catalog.
But my issue is to create a RITM in Flow and set some Catalog Item variables.
The RITM created in flow is without any variables and, no matter how much I try, I am not able to set any variables. The Flow reports success, but the log says undefined variable.
The variable section of the RITM created is empty. Is this impossible via Flow?
I have tried several options, with and without step 3 with no effect.
I know your post is old but I have been able to use/re-use most of it.
I would like to be able to update date values as well as string values and are stuggling a bit with it (I am rather new to javascript - sorry)
Here is what I have so far in the action:
Example of input from ticket:
When I look in the logs I see the following error: "Unparseable date: "01.01.1900": java.text.ParseException: Unparseable date: "01.01.1900": java.base/java.text.DateFormat.parse(DateFormat.java:395)
com.snc.commons.datetime.SNCSimpleDateFormatEx.parse(SNCSimpleDateFormatEx.java:131)"
Not really sure what it means and how to get around it.
Any help will be appreciated 🙂
Regards
Søren
Thanks for the post, however, I could not make the script part work so I wrote my own.
Here is the script:
(function execute(inputs, outputs) {
try {
outputs.state = 'fail';
var recordFound = false;
var grRitm = new GlideRecord('sc_req_item');
grRitm.get(inputs.ritm);
var grItemOptionNew = new GlideRecord('item_option_new');
grItemOptionNew.addQuery('name', inputs.cat_var);
grItemOptionNew.addQuery('cat_item', grRitm.cat_item);
grItemOptionNew.query();
if (grItemOptionNew.next()) {
var grItemOptionMtom = new GlideRecord('sc_item_option_mtom');
grItemOptionMtom.addQuery('request_item', grRitm.sys_id);
grItemOptionMtom.query();
while (grItemOptionMtom.next() && !recordFound) {
var grItemOption = new GlideRecord('sc_item_option');
grItemOption.addQuery('item_option_new', grItemOptionNew.sys_id);
grItemOption.addQuery('sys_id', grItemOptionMtom.sc_item_option);
grItemOption.query();
if (grItemOption.next()) {
grItemOption.value = inputs.var_value;
grItemOption.update();
recordFound = true;
outputs.state = 'success';
}
}
}
outputs.state = 'success';
}
catch (e) {
gs.error(e);
outputs.state = 'error';
}
})(inputs, outputs);
Looks like the catalog variables cannot be reached on RITM. Change code to use a reference to sc_task and it works. I changed code to use the syntax from Shane's post:
inputs.catalog_task.variables[inputs.variable_name] = inputs.variable_value;
inputs.catalog_task.update();
