Automation on Decision table record insertion

[elanrajad]

Can you please help me someone on below query.

I have a requirement to insert a row into the decision table via a scripting flow, where I have an input variable value and an output variable. The input variable references the schedule table, and the output variable references the group table.

[Robert H]

Hello @elanrajad ,

You can use the DecisionTable API to create new decisions, for example:

var decisionID = 'SYS_ID_OF_DECISION_TABLE';
var questions = [
   {
      condition: 'u_schedule=SYS_ID_OF_SCHEDULE_1',
      answer:[
         {
            name: 'u_group',
            value: 'SYS_ID_OF_GROUP_1'
         }
      ],
      active: true,
      defaultAnswer: true,
      order: 100
   },
   {
      condition: 'u_schedule=SYS_ID_OF_SCHEDULE_2',
      answer:[ 
         {
            name: 'u_group',
            value: 'SYS_ID_OF_GROUP_2'
         }
      ],
      active: true,
      defaultAnswer: false,
      order: 150
   }
];

var dt = new sn_dt.DecisionTableAPI();
var response = dt.createQuestions(decisionID, questions);
gs.info(JSON.stringify(response));

The above example assumes that your input is named "Schedule" and the output is named "Group", and that both  have the "Reference" type.

Regards,

Robert

[elanrajad]

Hi @Robert H  Thanks for your response 

when am trying via background script its giving below error how can we over come ?

@Ankur Bawiskar you have any suggestions

[Robert H]

Hello @elanrajad ,

Looks like the Draft authoring feature is enabled for this Decision table.

You need to click Create Draft before running the script, or disable the feature.

Regards,

Robert

[elanrajad]

Hi @Robert H 

I have tried where decision table is in draft mode and publish mode as well its not working for  me

The below is the script am running from background script 

var decisionID = '226c6cf98331221009799d60ceaad316';

var questions = [

   {

      condition: 'u_schedule=f86b71e3672322004792adab9485ef19',

      answer:[

         {

            name: 'u_decision_output',

            value: '553032e853165110b846ddeeff7b12aa'

         }

      ],

      active: true,

      defaultAnswer: true,

      order: 100

   }

];

var dt = new sn_dt.DecisionTableAPI();

var response = dt.createQuestions(decisionID, questions);

gs.info(JSON.stringify(response));