how to check if a string is present in JSON response?

swathigangadhar · ‎02-27-2017

Am getting response as below line,

"{\"Table\":[[\"Yes\"],null]}"

And it contains Yes, if Yes is present in response i need to do something, how to parse or split the response to identify Yes or No present in it?

Ankur Bawiskar · ‎02-27-2017

Hi Swathi,

Here is the code. I have executed in background and value is coming as Yes

you can also test

var str = '{"Table":[["Yes"],null]}';

var parsed = new JSONParser();

var parsedData = parsed.parse(str);

gs.print('Value is:'+parsedData.Table[0]);

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.

Thanks

Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Ankur Bawiskar · ‎02-27-2017

Hi Swathi,

Thanks for sharing the script. Is the value coming properly for the log of gs.log('data:'+parsedData.Table[0]);

Regards

Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

swathigangadhar · ‎02-27-2017

hi ankur,

I found out the bug...

The bug is with rest message....

Ankur Bawiskar · ‎02-27-2017

Hi Swathi,

Great that you found the bug. So it should work now when you correct your Rest Message bug. Could you mark the answer as correct, helpful and hit like. Thanks in advance

Regards

Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader