Retrieve subflow input values through script
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-29-2024 06:16 PM - edited 06-29-2024 06:16 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-17-2025 07:02 AM
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:
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