Not able to see target record in import set.

[Bharath kumar6]

I have uploaded the data using data source/transform map method.

Uploaded the data using excel sheet.

I see some records are ignored, some are updated and 1 record is inserted.

In this inserted record I cannot see the target record - It says empty.

Please anyone guide me on this.

[Tony Chatfield1 · Accepted solution]

Hi, with no details of your configuration, I would guess that the most likely cause is that the target record has been deleted.

If you right click the breadcrumb filter for your Import Set Rows query, you should be able to Open in a new window and from there you should be able to view xml of the import record.
If the target record existed, but has since been deleted, the target table and target sys_id should still be visible in the field sys_target_table and sys_target_sys_id.

You could then search 'Deleted Records' payload field for the sys_id, which might indicate who and when.

Another (less) possible cause might be table\class change for the record, checking the xml should still give you some indication/direction for further investigation.

[PratyushaBodepu]

For everyone who'd come here for the same issue.

Adding to what Tony has already mentioned. I had the same case and I have observed that the target record was in fact in the archived table, in my case ar_incident table. So, it'd be worth checking there as well if anyone would see something like this in the future.