how to pass the records in json?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-27-2018 02:00 AM
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);
- Labels:
-
Scripting and Coding
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-27-2018 02:10 AM
Hi caffry,
Please see the below code;
var js = {};
js.res=response.getBody();//Example
var parser = new JSON();
var str = parser.encode(res);
Thanks
PKG
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-27-2018 02:30 AM
its giving an empty object..
(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);
//var json=JSON.stringify(hits);
var parser = new JSON();
var str = parser.encode(hits);
gs.log(str,"soze");
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);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-27-2018 02:31 AM
Please see the below reply

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-27-2018 02:23 AM
HI,
You will have to create a JSON object and then stringify it and then pass it into an array.
Thanks,
Ashutosh