GlideRecord to JSON

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
var GlideRecordAjaxUtils = Class.create();
GlideRecordAjaxUtils.prototype = Object.extendsObject(AbstractAjaxProcessor, {

	getRecord: function(table,sys_id,fields){
		table = table || this.getParameter('sysparm_table');
		sys_id = sys_id || this.getParameter('sysparm_sys_id');
		fields = fields || this.getParameter('sysparm_fields');

		var gr = new GlideRecord(table);
		gr.get(sys_id);

		return this._convertGRtoJSON(gr, fields);

	},

	_convertGRtoJSON : function(record, objFields) {
		var fields = new GlideRecordUtil().getFields(record),
			resultObject = {},
			field;
		if(typeof objFields != 'undefined')
			fields = objFields.toString().split(',');
		for (field in fields) {
			resultObject[fields[field]] = (record.getValue(fields[field])+'')
				.replace(/\\n/g, "\\n")
				.replace(/\\'/g, "\\'")
				.replace(/\\"/g, '\\"')
				.replace(/\\&/g, "\\&")
				.replace(/\\r/g, "\\r")
				.replace(/\\t/g, "\\t")
				.replace(/\\b/g, "\\b")
				.replace(/\\f/g, "\\f");
		}
		return JSON.stringify(resultObject);
	},

	type: 'GlideRecordAjaxUtils'
});

1
2
3
4
5
/* Return entire record */
new GlideRecordAjaxUtils().getRecord('TABLE_NAME','RECORD_SYS_ID')

/* Return specific fields */
new GlideRecordAjaxUtils().getRecord('TABLE_NAME','RECORD_SYS_ID', ["FIELD_NAME1","FIELD_NAME2"])

1
2
3
4
5
6
7
8
9
10
11
12
var ga = new GlideAjax('GlideRecordAjaxUtils');
ga.addParam('sysparm_name', 'getRecord');
ga.addParam('sysparm_table', 'TABLE_NAME');
ga.addParam('sysparm_sys_id', 'RECORD_SYS_ID');
/* Optional */
ga.addParam('sysparm_fields', ["FIELD_NAME1","FIELD_NAME2"]);
/* Optional */
ga.getXML(function(response){
    var responseDocument = response.responseXML.documentElement;
    var answer = responseDocument.getAttribute('answer');    
    console.log(answer);
});