Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Not able to fetch the data from the table (sys_hub_action_instance)

Mallise
Tera Contributor

I want to fetch the data in this table using script,  but I am not able to fetch the data. On the list view when i click on preview icon I am able to see the data but when I was trying to fetch the data I am getting null value

 

snapshot of  when I click on info icon
Mallise_1-1701521370217.png

Snapshot of FORM view

Mallise_2-1701521411533.png
 
 
some one please help me to fetch the data from this record
7 REPLIES 7

Ankur Bawiskar
Tera Patron
Tera Patron

@Mallise 

share the script you are using

Are you sure you are fetching value from correct field?

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Mallise
Tera Contributor

Hi @Ankur Bawiskar 

 

We are using the below background script to fetch the value

 

var gr = new GlideRecord('sys_hub_action_instance');
gr.addEncodedQuery("flow=c37d4b27db145194c0dcedc4059619e8^action_type=2b3a6335531003003bf1d9109ec58759^sys_idSTARTSWITH7534e24ac3bc399032bef9db05013115");
gr.query();
if(gr.next()){
    gs.info("Values = " + gr.action_inputs.var__m_sys_hub_action_input_2b3a6335531003003bf1d9109ec58759.field_values)
}
 
Kindly check the above script and help me to fetch the values.

dchoward9
Tera Contributor

@Mallise did you find fix for issue? If yes please share. 

VaranAwesomenow
Mega Sage

@Mallise @dchoward9  if you try doing a show xml on the sys_hub_action_instance record does it show anything under element <action_inputs/>

I am referring to xml element in below screenshot.

VaranAwesomenow_0-1730777834669.png