Transform map field script to map with sys id

[_bhishek]

Hello All,

I have 2 model category with same name as Tablet device in model table and . I want to  map only one model category(reference field on model table) in model table transform map when there is import which is correct and we don't want to map with old model .Could you please help me with field script of same .I think we can map with sys ID of correct model.

Thanks.

[Ankur Bawiskar]

@_bhishek 

I would suggest to return sys_id of the model

Also update the Referenced value field name field on field map - sys_id

[_bhishek]

Hello Ankur ,

Could you please update script for better clarification.

Thanks.

[Ankur Bawiskar]

@_bhishek 

update field map script as this

answer = (function transformEntry(source) {

	// Add your code here
	if (source.u_model == 'Alienware M14x') {
		return 'sysId of G Series';
	}
	else if(source.u_model == 'Alienware M17x') 
	{
		return "46c41083a9fe1981017c3925c2004930";
	}
	else
	{
		var gr = new GlideRecord("cmdb_model");
		gr.addQuery("name", source.u_model);
		gr.query();
		if (gr.next()) {
			return gr.getUniqueValue();
		}
	}

})(source);

update as this

If my response helped please mark it correct and close the thread so that it benefits future readers.

[_bhishek]

Hello Ankur,

Thanks for your response .

Could you please tell me how can i return sysIds through gs.get property .Could you please update the steps.

[Joe S1 · Accepted solution]

Hello @_bhishek 

Sure thing,

First you'll need to create new system property records with a string value and set the value to the sys_id of the related model.

Then update your field map script to get the system property value like this:

answer = (function transformEntry(source) {

	// Add your code here
	if (source.u_model == 'Alienware M14x') {
		return 'get(sys_property)';
	}
	else if(source.u_model == 'Alienware M17x') 
	{
		return gs.getProperty('cmdb.model.sys_id.alienware_m17x');
	}
	else
	{
		var gr = new GlideRecord("cmdb_model");
		gr.addQuery("name", source.u_model);
		gr.query();
		if (gr.next()) {
			return gr.getUniqueValue();
		}
	}

})(source);

 Now this does require a property for each sys_id you need to return. So the GlideRecord query can return sys_id's but however you can't use a system property.