Deleting a record during a transform map

[kimberlylp]

I have an ebonding project with another SN instance that uses Import Table API to create and update both Incidents and Tasks. I have a test task that has a child table to record test results, so there is a Import table for the test task too.

I was just given a requirement that a test result could be deleted, so I added a delete me flag and in the onAfter Transform Map

       if (source.u_delete_me.toString() == 'true'){

               target.deleteRecord();

       }

The record is deleted, but the Import API responds with an error that the target record is not found.

Makes perfect sense, the record was deleted. Is there a way to intercept that error and make it a success?

I realize I the REST Table API is avalible to me, but I was hoping to keep all my code dealing with this ebonding in these Transform maps.

[Aditya Telideva]

Did you get a chance to go through the below link? I personally found this to be helpful....

TechNow Episode 18 | REST API - YouTube

Also, which version of snow are you using?

PS: Hit like, Helpful or Correct depending on the impact of the response

Thanks,

Adi

[kimberlylp]

Thank you, but that is a REST API tutorial and I am working with a Transform Map onAfter.

[shivanipatel]

Hi Kimberly,

We are glad you took advantage of the ServiceNow Community to learn more and to get your questions answered. The Customer Experience Team is working hard to ensure that the Community experience is most optimal for our customers.

If you feel that your question was answered, we would greatly appreciate if you could mark the appropriate thread as "Correct Answer". This allows other customers to learn from your thread and improves the ServiceNow Community experience.

If you are viewing this from the Community inbox you will not see the correct answer button.   If so, please review How to Mark Answers Correct From Inbox View.

Thanks,

Shivani Patel

[kimberlylp · Accepted solution]

I opened a HI incident to learn that I cannot change it from an error, but I can set the status message to say that the record was successfully deleted.

  if (action=="update") { status = "Successful!"; // This will not change status, will still say "Error" status_message = "Status Code = 201 Created: Target record - " + source.u_number + " was successfully removed from target table " + target.getTableName(); } }