Example 3: Insert a record in an external source

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

For Remote Table API information, refer to:

• v_query – Scoped, Global
• v_record - Scoped, Global
• v_table – Scoped, Global

(function executeInsert(v_record) {
	var gr = new GlideRecord("incident");
	gr.setNewGuidValue(v_record.sys_id);

	delete v_record["sys_id"];
	gr.number = v_record.u_number;
	gr.short_description = v_record.u_short_description;
	if (!gr.insert()) {
		v_record.setLastErrorMessage("Error on insert: " + gr.getLastErrorMessage());
	}
})(v_record);