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.

How we store the Record Producer Fields details in table contain field as json/script.

Kumari Divya
Giga Guru

Hi @LL

 I created 1 Record Producer on Test Case table in PDI

KumariDivya_0-1708103100080.png

Now i want to stored the Record Producer Field details-Test Case Number in table-Test Case in Field Test Result which is script type or Json when user Submitted the Record on Form.

 

KumariDivya_1-1708103423591.png

Please suggest on this  how we stored the Fields details in json format in Table.

 

Thanks in advance

Divya Kumari

8 REPLIES 8

What's output of the above code and what is expected output in JSON format.

replace the line position of "var testResult1= {};" on top.

 

 

 

 


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution

Anand Kumar P
Giga Patron

Hi @Kumari Divya ,

In Record producer script add below script

var testCaseNumber = producer.test_case_number;

var jsonDetails = {
"testCaseNumber": testCaseNumber;
};

current.test_fieldset= JSON.stringify(jsonDetails);

 

Mark it as helpful and solution proposed if it serves your purpose.
Thanks,
Anand

Hi @Anand Kumar P 

Thanks for the script but its now working.

 

Thanks 

Divya

Hi @Kumari Divya ,
Mark it as helpful and solution proposed if it serves your purpose.
Thanks,
Anand