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.

Get Answer From Decision Table

anirban300
Kilo Guru

Hello All,

 

I want to get the 'answer' from the decision table

anirban300_0-1677918514620.png

 

I am using the following decision table API in script:

 

var dt = new sn_dt.DecisionTableAPI();
var input = new Object();
input['u_keywords'] = 'HR case - new hire - mover';
var response = dt.getDecisions('78e5e46d1b6c5554e2e6cbf2164bcb09', input);
var firstRecord = response[0];
gs.print(JSON.stringify(firstRecord));

 

I am getting the following response:

 

[{"sys_meta":{"active":"1","array":"0","attributes":"metadata_link_exempt=true,no_audit_delete=true","audit":"0","calculation":"","choice":"0","choice_field":"","choice_table":"","create_roles":"","default_value":"","delete_roles":"","dependent":"","dependent_on_field":"","display":"label","dynamic_creation":"0","dynamic_creation_script":"","dynamic_default_value":"","dynamic_ref_qual":"","element_reference":"0","filterable":"1","foreign_database":"","function_definition":"","function_field":"0","groupable":"1","help":"","hint":"","i18n_sortable":"1","internal_type":"collection","label":"Choice","language":"en","mandatory":"0","matchable":"1","max_length":"40","multi_text":"0","name":"sys_choice","plural":"Choices","primary":"0","read_only":"0","read_roles":"","reference":"","reference_cascade_rule":"","reference_floats":"0","reference_key":"","reference_qual":"","reference_qual_condition":"","reference_type":"","sizeclass":"1119493","sortable":"1","spell_check":"0","staged":"0","sys_package":"","sys_scope":"global","table_reference":"0","text_index":"0","type":"0","type_description":"collection","unique":"0","url":"","url_target":"","use_dynamic_default":"0","use_reference_qualifier":"simple","virtual":"0","widget":"","write_roles":"","xml_view":"0"},"dependent_value":{},"synonyms":{},"sys_mod_count":{},"language":{},"label":{},"sys_updated_on":{},"sys_domain_path":{},"sys_tags":{},"sequence":{},"sys_id":{},"inactive":{},"sys_updated_by":{},"sys_created_on":{},"hint":{},"sys_domain":{},"name":{},"value":{},"sys_created_by":{},"element":{}},{"sys_meta":{"active":"1","array":"0","attributes":"metadata_link_exempt=true,no_audit_delete=true","audit":"0","calculation":"","choice":"0","choice_field":"","choice_table":"","create_roles":"","default_value":"","delete_roles":"","dependent":"","dependent_on_field":"","display":"label","dynamic_creation":"0","dynamic_creation_script":"","dynamic_default_value":"","dynamic_ref_qual":"","element_reference":"0","filterable":"1","foreign_database":"","function_definition":"","function_field":"0","groupable":"1","help":"","hint":"","i18n_sortable":"1","internal_type":"collection","label":"Choice","language":"en","mandatory":"0","matchable":"1","max_length":"40","multi_text":"0","name":"sys_choice","plural":"Choices","primary":"0","read_only":"0","read_roles":"","reference":"","reference_cascade_rule":"","reference_floats":"0","reference_key":"","reference_qual":"","reference_qual_condition":"","reference_type":"","sizeclass":"1119493","sortable":"1","spell_check":"0","staged":"0","sys_package":"","sys_scope":"global","table_reference":"0","text_index":"0","type":"0","type_description":"collection","unique":"0","url":"","url_target":"","use_dynamic_default":"0","use_reference_qualifier":"simple","virtual":"0","widget":"","write_roles":"","xml_view":"0"},"dependent_value":{},"synonyms":{},"sys_mod_count":{},"language":{},"label":{},"sys_updated_on":{},"sys_domain_path":{},"sys_tags":{},"sequence":{},"sys_id":{},"inactive":{},"sys_updated_by":{},"sys_created_on":{},"hint":{},"sys_domain":{},"name":{},"value":{},"sys_created_by":{},"element":{}}]

 

Can someone help me in getting the correct value i.e. "Choice: 3 - Moderate" in this case.

 

Regards

Anirban

1 REPLY 1

Tarun Kumar9
Tera Contributor

Hi Anirban, 

Did you find any solution for this , thanks