Where the Flow Designer's Action inputs are stored?

[kdutta]

Hi Team,

We have a requirement, to fetch the flow, subflow names where any particular group is referenced, i.e., in "Create Catalog Task" activity if Field Value is set as "Assignment Group = ABC". Upon initial investigation, I could navigate to "sys_hub_action_instance" table and apply a filter "Action Type = Create Catalog Task" and preview the record from "i" icon, we can see the sys_id of the group in "Field" field. But, when we open the record, the field is empty and it is not accessible via script as well.

When we check the dictionary, it shows like "sys_hub_action_instance.action_inputs.var__m_sys_hub_action_input_{{sys_id}}.ah_fields". However, this table is not accessible as well. 

Can anyone help me to figure out how to get the required value which is/are used in FD? Please let me know if you need any further clarity. Thanks!!

[Community Alums]

Hi @kdutta ,

Action input are stored in  - sys_hub_action_type_definition table.

[kdutta]

Hello @Community Alums , the "sys_hub_action_type_definition" table contains the list of actions, but I want to get the inputs for this action. e.g., "Create Catalog Task" action is used in any flow and I have provided input like "Assignment group = ABC". Any idea where these values specific to flow's are stored?

[Community Alums]

Hi @kdutta ,

1. The configuration of the input and output variables are stored in sys_hub_step_instance table (make sure Inputs and Outputs fields are added in form layout)
2. The actual value of the input and output variables is stored in sys_hub_action_instance table (make sure Inputs and Action type.Outputs / Action type parent.Outputs / Compiled snapshot.Outputs fields are added in the form layout)
3. The rest of the Flow Designer tables can be found here: https://<instance_name>.service-now.com/sys_db_object_list.do?sysparm_query=sys_update_nameISNOTEMPTY%5EnameSTARTSWITHsys_hub

[kdutta]

I have already went through this article, and if you try to add the prescribed fields mentioned in the article, it will not show you neither the input nor the output values on "sys_hub_action_instance" table. However, on the same table, if you preview any "Create Catalog Task" action, it will show you the value of the action in the "Field" field, but when you open the form, it is not there. 😞