I’ve 1000 records to import in the system. I’ve used the number field as coalesce and my system has 100 records. Now I want to update the existing record without importing other records from the list. How can I achieve this?

[John Doe]

I’ve 1000 records to import in the system. I’ve used the number field as coalesce and my system has 100 records. Now I want to update the existing record without importing other records from the list. How can I achieve this?

I tried one script, but its not working

Transform map script 

(function transformRow(source, target, map, log, isUpdate) {

	if(!action == 'update'){
		ignore = true;

}

})(source, target, map, log, action==="update");

[Maik Skoddow]

Hi @John Doe 

unfortunately it is not clear what that mentioned "number field" is. Is this is a field which is only present in ServiceNow and not in your import source? If so you have to add the number values to your import file only that way ServiceNow can find the previously imported record and update it.

If the number field is already present in your import file, we need all the configurations from you which are related to the import (data source, transform map, etc.)

Kind regards
Maik

[Shruti · Accepted solution]

Hi,

To ignore insertion you can use below script. 

if(action=='insert')

{

ignore=true;

}

Refer https://developer.servicenow.com/dev.do#!/learn/learning-plans/paris/citizen_developer/app_store_lea...

[John Doe]

Yes it worked!