How do I know that whether record is inserted or updated using transform map script

[SD40]

How do I know that whether record is inserted or updated using transform map script 

[SD40]

then syntax will be if(action=='insert)..am I right??

[Allen Andreas]

Hi,

As you mentioned, you have access to "action" which will tell you if it classifies as an insert or update.

Is there anything specific you wanted to discuss regarding that or did you just want to confirm it?

You're on the right track! 🙂

Please mark reply as Helpful, if applicable. Thanks!

[Allen Andreas]

Hi,

You can use, example:

if (action == "insert") {
//do x
}

Further example here and this can even be done in onBefore: https://docs.servicenow.com/en-US/bundle/sandiego-platform-administration/page/administer/import-set...

Please mark reply as Helpful, if applicable. Thanks!

[Michal Hancar1]

For anyone wondering, in the "onAfter" Transform Script, you can find out by the following code:

if(source.sys_import_state == 'inserted'){
// do magic
}

After the record gets processed, the transform map engine goes back and updates the import set row record. At which point you can access it via the "source" object.