The CreatorCon Call for Content is officially open! Get started here.

how to pass the records in json?

caffry
Kilo Guru

i used the below script where it pass the data in an aray,i need to push to an json array.

(function executeRule(current, previous /*null when async*/) {

try { 
	var r = new sn_ws.RESTMessageV2('direct_rest_transaction', 'direct_rest_transa');
	
	
var fields = current.getFields();
	var hits = [];
	var name=[];
	var field=[];
	var sysid=current.sys_id;

		for (var i = 0; i < fields.size(); i++) {
			var glideElement = fields.get(i);
			if (glideElement.hasValue()) {
				name.push(glideElement);
				field.push(glideElement.getName());
				hits.push(glideElement.getName() + ":" + glideElement);
		}

	}
	hits.push("sys_id:" +sysid);
	r.setStringParameterNoEscape("pay",hits);
	 r.setStringParameterNoEscape('name', name);
 r.setStringParameterNoEscape('fields', field);
	//r.setStringParameterNoEscape('type',1);

 var response = r.execute();
 var responseBody = response.getBody();
 var httpStatus = response.getStatusCode();

}
catch(ex) {
 var message = ex.message;
}

	

})(current, previous);
13 REPLIES 13

Ashutosh Munot1
Kilo Patron
Kilo Patron

Hi,

See this link:

 

https://community.servicenow.com/community?id=community_question&sys_id=a4f847a1db5cdbc01dcaf3231f961950

 

Thanks,
Ashutosh

When i used global.json() its passing only the object

find_real_file.png

	var hits = {};
	var name={};
	var field={};
	var sysid=current.sys_id;

		for (var i = 0; i < fields.size(); i++) {
			var glideElement = fields.get(i);
			if (glideElement.hasValue()) {
				name.push(glideElement);
				field.push(glideElement.getName());
				hits.push(glideElement.getName() + ":" + glideElement);
		}

	}
	hits.push("sys_id:" +sysid);
var parser = new global.JSON();
var parsed = parser.decode(hits);
	gs.log(parsed,"soze");

Hi,

Do not use decode. It is a old fashion and sometimes not supported.

Thanks,
Ashutosh

when i use 

var parser = new global.JSON();
var parsed = parser.encode(hits);
gs.log(parsed,"soze");

it displays as below,,

 

find_real_file.png