Restrict data to import into servicenow tables from import sets

[bhanu27]

Hi All 

I want to restrict new data to import from import sets to table but already existing data if any  can be updated using the importset how can we do that, please suggest me.

Thanks in advance.

Bhanu.

[Harish KM]

Hi @bhanu27 you can add the below script in your transform map to abort the insert

  if (action == "insert") {

        ignore = true;

    }

also you can set Coalesce to true for a field which is unique to avoid insert

[shikhatyagi]

Hi @bhanu27 

Create On Before transform map script with below code.

if (action == 'insert')

      ignore = true;

Please mark this comment as Correct Answer/Helpful if it helped you.

Regards,

Shikha Tyagi