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.

Convert string to JSON and fetch its variable

Deepika Mishra
Mega Guru

On doing a GlideAjax I am getting a String written in JSON format.

var str ="var data = {"value1": "abc","value2": "def","value3": "ghi"};";

Now from this string I want to fetch individual parameters from this data variable and get output of individual.

Value1 =  abc
Value2 = def
Value3 = ghi

Please let me know how from the output string which has a variable declaration of var data, I can get my individual output.

 

1 ACCEPTED SOLUTION

var str='var data = {"value":"abc","value2":"def","value3":"ghi"};';

var start=str.indexOf('{');
var end=str.indexOf('}');
var str=str.substring(start,end+1)

gs.info(str)

var data=JSON.parse(str); // Now you will have a valid JSON String

 

//Now access them as below

gs.info(data.value);// Now data.value1 will hold "abc";
gs.info(data.value2);// Now data.value2 will hold "def";
gs.info(data.value3);// Now data.value2 will hold "ghi";

 

Its my bad i additionaly added the parsing statement twice;

please try the above cod. its tested 

View solution in original post

22 REPLIES 22

Below is the string which I want to convert:

var str ="var data = {"value1": "abc","value2": "def","value3": "ghi"};";

Below is the string which I want to convert:

var str ="var data = {"value1": "abc","value2": "def","value3": "ghi"};";

Below is the string which I want to convert:

var str ="var data = {"value1": "abc","value2": "def","value3": "ghi"};";

Hi,

 

You can convert only ({"value1": "abc","value2": "def","value3": "ghi"}) to the JSON.

Not like given by you, So use the code like below:

 

 

var str ='var data = {"value1": "abc","value2": "def","value3": "ghi"};';
var js_data = str.split('= ');
var js_data1 = js_data[1].split(';');
gs.print(JSON.parse(js_data1[0]));

Hi,

 

May I know how you are getting the string in this format?

You cannot convert this string value (str) into a JSON format.