Automate Transform map using catalog item for end users

Sriram28 · 3 hours ago

Hello All,

I have a similar requirement as per below video:

To give insights about the video above:

"Create a ServiceNow Flow that automatically processes Excel files uploaded through the "Test Compliance Case" catalog item and creates Compliance cases using an existing Data Source, Import Set, and

Transform Map"

So, everything in place and also creating cases once attachment submitted through catalog.

But I have few more questions on this and issues as well.

Extended requirement:

1. I wanted to update work notes of RITM that which is submitted with attachment and processed with transform map with following details like:

Capture Import Results on the respective RITM:

Retrieve import/transform statistics, including:

Rows Processed

Records Inserted (Cases Created)

Records Skipped

Errors

2. On successful completion of transform map execution, set or close the RITM

3. If transform execution fails, update worknotes with results and close incomplete the RITM.

Issues I am facing:

1. post import script to delete already existing attachment on data source is not getting deleted using

var attach= new GlideSysAttachment();

attach.deleteAll(data source);

2. And executions are happening many times even I submit the catalog once in portal using catalog, but case is creating only once. But many times, execution record getting created.

Please help me in how to go technically with above requirements and how to fix the issues that I am facing

Thanks in advance.