Hi @Dazler,
To retrieve subflow input values through a script in ServiceNow, you need to access the sys_flow_context and sys_context tables. The sys_context table holds references to the sys_flow_context and contains the variable values used in the flow or subflow. Here's a script that retrieves these values:
Script Include to handle the retrieval:
var SubflowUtils = Class.create();
SubflowUtils.prototype = {
initialize: function() {},
getSubflowInputs: function(flowContextId) {
var inputs = {};
var contextGR = new GlideRecord('sys_context');
if (contextGR.get(flowContextId)) {
var contextVarGR = new GlideRecord('sys_context_variable');
contextVarGR.addQuery('sys_context', contextGR.sys_id);
contextVarGR.query();
while (contextVarGR.next()) {
inputs[contextVarGR.name] = contextVarGR.value;
}
}
return inputs;
},
type: 'SubflowUtils'
};
2.Scheduled Job:
(function() {
var gr = new GlideRecord('sys_flow_context');
gr.addQuery('state', 'complete'); // Adjust the query as needed
gr.query();
while (gr.next()) {
var subflowUtils = new SubflowUtils();
var inputs = subflowUtils.getSubflowInputs(gr.sys_id);
gs.info('Subflow Inputs for Flow Context ' + gr.sys_id + ': ' + JSON.stringify(inputs));
}
})();
- The SubflowUtils script include has a method getSubflowInputs that takes a flow context ID and retrieves the associated input values from the sys_context_variable table.
- It constructs an object where the keys are the variable names and the values are the variable values.
- This scheduled job queries the sys_flow_context table for completed subflows (adjust the query as needed).
- For each completed subflow, it retrieves the input values using the SubflowUtils script include and logs them.
- Ensure you have proper permissions and roles to access the sys_flow_context, sys_context, and sys_context_variable tables and execute the Script Include.
Thank you, please make helpful if you accept the solution.
