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

Deepika Mishra
Mega Guru

JSON.parse is not working 😞

I tried in background script too but it is not allowing.

Deepika Mishra
Mega Guru

Below is the string which I want to convert:

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

Thameem Ansari
Giga Guru

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";

Please mark it as helpful/correct If my answer is helpful in any way,

Best regards,

Thameem

 

I fixed the issue in my previous code

please try the above code. its tested find_real_file.png