Map the json array in to string field with comma separated value

salu
Mega Guru

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;

  }

1 ACCEPTED SOLUTION

Gurpreet07
Mega Sage

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


View solution in original post

15 REPLIES 15

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();