Restored Record in Source Showing As Deleted in the Destinationlink

Updated 12 days ago

Issuelink

A record was deleted from the source and later imported via XML. It is still marked as _fivetran_deleted = true.

Environmentlink

Connector: ServiceNow

Resolutionlink

To resolve the issue, do the following:

1. Restore the record from the ServiceNow User Interface (UI).

2. Re-sync the table.

Causelink

We store the last date of deletion for every table and use it as the beginning date.

Once we restore the record in the UI, it is removed from the SYS_AUDIT_DELETE table.