How to store JSON data on Strung field

[Parul Sahu]

Hi All,

I have a requirement where I need to get the HR service JSON data and store in a HR case table field.

I created a new field "Processing Hidden" on HR case form of "String" Type. Now I need to get the json data of some fields of  current HR case - HR Service and populate that json data into "Processing Hidden" field. How can I acheive this.?

I used something like this below: 

var currentval = current.hr_service.getRefRecord(); // This will store HR service record object
gs.addInfoMessage("Alert current message" + " " + currentval);

current.u_processing_unit_time_hidden = currentval;

[Sebastian L]

Not sure I understand your requirement 100%, but it sounds like all you need to do is to add JSON.stringify: current.u_processing_unit_time_hidden = JSON.stringify(currentval);

[suvro]

Try this

var currentval = current.hr_service.getRefRecord(); // This will store HR service record object
gs.addInfoMessage("Alert current message" + " " + currentval);

current.u_processing_unit_time_hidden = JSON.stringify(currentval);

[Community Alums]

Hi @Parul Sahu ,

You could stringify the JSON and store it in a text field. Then retrieve and parse the stored JSON text when you need to work with the actual JSON object.

The ServiceNow JSON API is documented here.

If you must store the hierarchy you'd need to design a table structure that represents a hierarchy of name-value pairs. You'd have to transform the JSON into appropriate records.