Hello Everyone,
I will be uploading asset data into ServiceNow using an Excel spreadsheet and a transform map. I am trying to determine if it possible to restrict new records being inserted on the associated tables during the upload. The asset information should only be updated with data that exists on the associated tables.
For example, if the spreadsheet had a model that wasn't in ServiceNow as a record, I would want that insert to be ignored.
Please let me know your thoughts on what the best way to go about this would be. My understanding is that you can configure an onBefore Transform map to potentially do something like this but I don't know where to begin. Thank you.
Tables that we want to restrict insert on if the record doesn't exist in the table.
- Location
- Stockroom
- Model
- Model Category
