- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-15-2017 09:47 PM
Hello,
I want to map the value from the json array to string variable.
[{"number":0,"fields":[{"min":6,"max":10,"label":"","type":"text","value":"111111"}]},{"number":1,"fields":[{"min":6,"max":10,"label":"","type":"text","value":"111111"}]}]
var json_output=this.getParameter('sysparm_json_output');
var parser = new JSONParser();
var parsedData = parser.parse(json_output);
var length = parsedData.length; // get length
for(var i=0;i<length;i++)
{
var value1 = parsedData[i].fields[0].value;
if(value1 != "")
{
inc.u_bdc_sku_number=value1.toString();// its not working
}
else
break;
}
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-15-2017 10:03 PM
Following should work fine
var json_output=this.getParameter('sysparm_json_output');
var parser = new JSONParser();
var parsedData = parser.parse(json_output);
var strValue= '' ;
var parsedData = parser.parse(json_output);
var length = parsedData.length; // get length
for(var i=0;i<length;i++)
{
var value1 = parsedData[i].fields[0].value;
if(value1 != "")
{
strValue += ','+value1;
}
}
strValue = strValue.substring(1);
inc.u_bdc_sku_number=strValue ;// its not working
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-16-2017 09:11 PM
Use below code
var parser = new JSONParser();
var strValue1= '' ;
var parsedData = parser.parse(json_output);
var length = parsedData.length; // get length
for(var i=0;i<length;i++)
{
var value1 = parsedData[i].fields[0].value;
if(value1 != "")
{
strValue1 += ','+value1;
var gr = new GlideRecord('u_bdc_sku_details');
gr.initialize();
gs.log('Jan 17 inside if '+strValue);
gr.u_bdc_sku =value1.toString();
gr.u_incident=inc.sys_id;
gr.insert();
}
}
strValue1 = strValue1.substring(1); // this should be outside of the loop
inc.u_bdc_sku_number = strValue1;
inc.update();