Example 4: Update a record in an external source

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

注:

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_query – Scoped, Global
• v_record - Scoped, Global
• v_table – Scoped, Global

v_changed_fields is a map of changed field names and values.

(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);