Create Multiple records using JSON Payload

[Vamshi_ch123]

Hi @Pavankumar_1 

Trying to create multiple records from JSON using the below script but the records are not inserted.

Script: 

var reqbody = request.body.data;
var  parsedData = reqbody.alerts;
gs.info("event : REQ " + reqbody);

for(var i=0; i<parsedData.alerts.length; i++){
	
	var gr = new GlideRecord("em_event");
	gr.initialize();
	gr.setValue("description",parsedData.alerts[i].annotations.summary);
	gr.setValue("node",parsedData.alerts[i].labels.Customer);
	gr.insert();
	gs.info("testevent : val " + parsedData.alerts[i].valueString);

-Thanks 

[Tony Chatfield1]

Hi, without clear details of your payload your issue is difficult to evaluate.

What are the results of your debugging? What happens if you add debugging\logging inside your for loop IE
gs.info(parsedData.alerts[i].annotations.summary);
Are there mandatory requirements that are not being met as part of your 'em_event' record insert?

[Vamshi_ch123]

Hi This worked after I change my script as below

var reqbody = request.body.dataString;
var parser = new global.JSON();
var  parsedData = JSON.parse(reqbody);
gs.info("Grafana : REQ " + reqbody);


for(var i=0; i<parsedData.alerts.length; i++){
	gs.info(parsedData.alerts[i].annotations.summary);
	var gr = new GlideRecord("em_event");
	gr.initialize();
	gr.description = parsedData.alerts[i].annotations.summary;
	gr.node = parsedData.alerts[i].labels.Customer;
        gr.insert();

[Ankur Bawiskar]

@Vamshi_ch123 

are you sure the for loop is running?

[Pavankumar_1]

Hi @Vamshi_ch123 ,

Need to end the for loop and check the length and values of the payload using logs

var reqbody = request.body.data;
var  parsedData = reqbody.alerts;
gs.info("event : REQ " + reqbody);
gs.info("length is "+parsedData.alerts.length);
for(var i=0; i<parsedData.alerts.length; i++){
var gr = new GlideRecord("em_event");
gr.initialize();
gr.description = parsedData.alerts[i].annotations.summary;
gr.node = parsedData.alerts[i].labels.Customer;
gr.insert();
gs.info("testevent : val " + parsedData.alerts[i].valueString);
}