@AndyB5000 ,
You are mapping u_model directly to model_id field, and you are not mapping model category at all. Both are required to create an asset correctly and create a resulting CI. This is the cause of your issue.
Model: Since there is no source script used here, and presumably the value of u_model is not a sys_id of a Model reference, this won't work. You need to provide a reference to a valid model. My recommendation would be to use a combination of u_manufacturer (if available) and u_model, and then use MakeAndModelJS script to automatically obtain or create a valid model reference on the fly. If you do not have u_manufacturer available in your data source, you will need to determine an appropriate method to supply a valid model reference, or else this will not work correctly, because it cannot determine what model to use.
Model Category: This is typically something that you will have to provide some customized logic for, depending on your data source. Like model, it has to be a reference (sys_id) to a model category. It's not a String field. So you will need to map the information from your data source to an appropriate model category in your system.
Please mark as helpful and as correct answer if this resolves your issue.
Paul
The opinions expressed here are the opinions of the author, and are not endorsed by ServiceNow or any other employer, company, or entity.
