How to send email containing errors came after transform process.

[Obito]

Hi Guys,

We imported 100k records into servicenow using a data source. In this process, some errors came, and now we want to combine all the errors that happened in this process and send them via email. How can we fetch all these errors that came in this process? is it stored inside any table in servicenow? How to send error data using email?

Thank you in advance.

[Ankur Bawiskar · Accepted solution]

@Obito 

you can have notification on Transform History table (sys_import_set_run) and determine this based on import set

[Ankur Bawiskar · Accepted solution]

@Obito 

you can have notification on Transform History table (sys_import_set_run) and determine this based on import set

[Ankur Bawiskar]

@Obito 

Thank you for marking my response as helpful.

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

[Harsh_Deep · Accepted solution]

Hello @Obito ,

You can Glide on "sys_import_set_run" then get sys_id then again Glide "sys_import_set_row_error" and get your errors and send the notification on this.

Please mark my answer as helpful and solution accepted.
Thanks

[Harsh_Deep]

Hello @Obito ,

Thank you for marking my response as helpful.

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