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.
Hello,
Yes, you're correct you can just create a new Field Map that Uses a source script and set your return value to the sys_id of the Model you want to use. Then map the Target field to the correct field of the table you're importing into.
Hello Ankur,
I have made some changes.Looks like it is working now ,I have tested with few records.Please take a look and let me know if you see any issue .
