Example 4: Update a record in an external source

remote-table-script-def-example4.md
Raw file

In this example, we create a script to update an incident record in the external source.

Note: If multiple users update the same record at the same time, the value on the remote system is from the last update call executed.

For Remote Table API information, refer to:

v_changed_fields is a map of changed field names and values.

JavaScript
(function executeUpdate(v_record, v_changed_fields) {
	var gr = new GlideRecord('incident');	if (gr.get(v_changed_fields.sys_id)) {		Object.keys(v_changed_fields).map(function(k) {				switch (k){				case "u_number" :					gr.number = v_changed_fields.u_number;					break;				case "u_short_description" :					gr.short_description = v_changed_fields.u_short_description;					break;			}		});	gr.update();} else {	v_record.setLastErrorMessage("Missing record to update, " + v_changed_fields.sys_id);}
})(v_record, v_changed_fields);

Parent Topic:Create script definitions for a remote table

Search documentation
Search document titles and file paths on the australia branch