Import set showing records updated

[Colleen]

I have a custom (load by script) data source that uses REST calls to download data to populate an import set. Not all the fields in the import set table are populated by the REST data source  The associated transform only maps the fields returned by the REST data source, has a single coalesce field and only allows updates.   When the data import runs it processes about 31,000 records - almost all have the updated state, the remainder have the ignored state.  The destination table has auditing enabled.  When I check the audit log for records flagged as updated in the import set, there is no record of the update.  The records that are flagged as ignored seem to be those that were previously updated by the transform.

Can anyone explain why the transform map is flagging the destination record as updated when no changes have been made to the record?

[Sulabh Garg]

Hello Colleen,

As you mentioned the destination table is audited, Can you manually update the destination table record and see if you are able to see the updates in the audit log?

Are you updating the table under scoped application? If yes, There may be some issue with the cross scope application access.

Please Mark ✅ Correct/helpful, if applicable, Thanks!! 

Regards

Sulabh Garg

[Colleen]

Hello Sulabh

The data source, import set table and destination table are all in the same scoped application.

I've updated a record in the table through the form and via script and both updates were recorded in the audit log.

Regards

Colleen

[toddgoodhew]

This is an old post, but providing the info since so many have looked at it.

The system does not track changes on the target table (History) made by an import set, even when auditing is enabled.  The import set itself does not track any updates made.  It just knows if it needed to insert, update, or ignore a record.  There is no OOB way to override either of these.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0789915