There is a failure to import files from SFTP server

[Community Alums]

Hi All,

When an scheduled import triggers SFTP data source then we are getting an error to import files from SFTP server into ServiceNow, for time being we fixed, however in the future we want to send a report and also notification to the user if there is any error.

My findings:

There is table: import log, there i could see warning and error records, however how we can match with the current  data source one..

Could anyone let me know, what will be the possibilities to achieve this.

Any help is appreciated!!

Thanks in advance!!

[Ankur Bawiskar]

@Community Alums 

I believe the only table you can rely on is the Transform history

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Community Alums]

Thanks Ankur!!

In the transform history table, we would be have only records if any data gets fails during load or transform map.

Here if i click on "load all record" button the error is occurring.

So in the import log table, i could see below error records, how to bring into script with the current data source?