How to display detailed/meaningful error message after uploading assets.

[SuriH]

I’m uploading asset records into the alm_asset table using a Data Source and Transform Map. I want to capture and display specific row-level errors (like missing model or invalid location) after the import. 

My goal is to:

Identify specific row-level errors that occurred during the insert Extract those errors from sys_import_set_row.error_message where status = Completed with error Display meaningful error messages to users after the upload — such as "Missing model", "Invalid location", etc.

[Tushar]

Hi @SuriH 

I think to capture and show row-level errors when uploading asset records to the alm_asset table using a Data Source and Transform Map, you can try this steps: Add an onBefore script in the Transform Map to check for issues like missing models or invalid locations, and log those errors with action.setError.

After the import, query the sys_import_set_row table for rows with "Completed with error" status to pull the error_message. Optionally, save these errors in a custom table like u_import_errors for easy tracking.

Then you can display them to users via a simple UI page, email, or report, I would go with report as it's easier.

Thanks,

Tushar