When you configure an upsert operation to update data in a ServiceNow target, the Secure Agent updates or inserts the data based on the availability of the SYS_ID value in the target record.

If the SYS_ID value in the record of the input data matches the SYS_ID in the target, the Secure Agent updates that record in the ServiceNow target.

When the SYS_ID value is not available in the ServiceNow target, the Secure Agent inserts that record to the ServiceNow target.

If the SYS_ID in the target does not match with the SYS_ID from the input data, the rejected records are captured in the error file. See the Job properties for the task to view the error rows file.