Retrieve subflow input values through script

Dazler
Mega Sage

Hi,

 

I am trying to create a script that will return the input values from a subflow that has completed.  I don't have a reason for this, I just am playing around and wanted to see if it could be done.

 

If anyone has any ideas, any help would be appreciated.

10 REPLIES 10

Diogo Ramos
Tera Sage

Hello Dazler, I will leave my answer here as I had the same question. 

If you want to find all flows that had a specific input value at runtime you first need the reporting property for flows to enabled (com.snc.process_flow.reporting.level) (ONLY DO THIS IN NONPROD ENVIRONMENTS) and then you can use the table sys_flow_value table.

Note that to read the values, you need to update the READ ACL on that table, to allow admin to read the data.

Once you can read the data, use the following query: "nameSTARTSWITHin"

This will give you a list of inputs for all flow contexts, now you just have to filter on the flow you want via the context name or just use name of your input field (with underscores instead of spaces) you can use that as well:

DiogoRamos_1-1737125838653.png

Then you will see the values that were used if you check the value column, it has the content stored in JSON.

I tested this for subflows in XANADU, but I assume flows will be similar.

Cheers
Diogo