Get a first look at what's coming. The Developer Passport Australia Release Preview kicks off March 12. Dive in! 

How to get Json data from field through business rule.

Sai25
Tera Guru

Hi All,

How to pull below Json data from a field. I am storing the Json data on form in a  particular field that is string field.

The below data is from  a catalog item details.

{
'sysparm_id': '0d08837237153000158bbfc8bcbe5d02',
'sysparm_quantity': '1',
'variables':{
'example_var1': 'at_and_t_mobility',
'example_var2': '500MB',
'example_var3': 'eighteen_months',
'example_var4': 'slate',
'example_var5': 'sixtyfour'
}};

I want to get the variables and sysparm_id. How to get from a variables.

Thank You,

Sai.

1 ACCEPTED SOLUTION

hvrdhn88
Giga Patron

try now. 

 

var json = {
'sysparm_id': '0d08837237153000158bbfc8bcbe5d02',
'sysparm_quantity': '1',
'variables':{
'example_var1': 'at_and_t_mobility',
'example_var2': '500MB',
'example_var3': 'eighteen_months',
'example_var4': 'slate',
'example_var5': 'sixtyfour'
}};


var ab = JSON.stringify(json);
var op = JSON.parse(ab);

gs.print(op.sysparm_id);

gs.print(op.variables.example_var1); // this way you will get variables object details. 

View solution in original post

5 REPLIES 5

Sanket Pokharka
Kilo Explorer

hiii try like this

 

var json=new JSON();

var object= {
'sysparm_id': '0d08837237153000158bbfc8bcbe5d02',
'sysparm_quantity': '1',
'variables':' ', 
'example_var1': 'at_and_t_mobility',
'example_var2': '500MB',
'example_var3': 'eighteen_months',
'example_var4': 'slate',
'example_var5': 'sixtyfour'
};

var data=json.encode(object);

return data;