how can i read Json data for specific parameters

[Emp 53]

Hi Team,

Below is the JSON data updated in 1of the variables in catalog item.

{

"id":"123",

"region":"us-east-1",

"name":"123@gmail.com"

} i above JSON i need to read id & name details. how can i develop script for the same.

[Sandeep Rajput]

@Emp 53 Could you please let me know what type of variable is bulk_info? Please share a snapshot of this variable if possible.

[Sandeep Rajput]

@Emp 53 If it is a multiline text then the JSON parsing might be breaking due to the carriage return /r or new line characters /n. Please check if the following code fixes your issue.

var gr = new GlideRecord('sc_req_item');
gr.addQuery('number', 'RITM1100611');
gr.query();
var jsonVar='';
while(gr.next()) {
    jsonVar = JSON.parse(gr.variables.bulk_info.replace(/\r?\n|\r/g, "")); //replace variable name with variable containing JSON data
       gs.print('id: '+jsonVar.id);//will print id

}

[Emp 53]

still facing same issue. can you suggest which variable i need to use if multiline text not work

[Sandeep Rajput]

@Emp 53 if you are taking a JSON input in the multiline text field than the chances of variable having /r/n characters are higher. You would need to remove all the new line characters from the variable and finally your variable should have the text 

{ "id":"123", "region":"us-east-1", "name":"123@gmail.com" }

without any newlines. Then only JSON.parse will be able to work.