I’m working on a requirement to integrate Zoom Devices into a custom CMDB table in ServiceNow.
I have configured a Robust Transform Map (RTM) through IntegrationHub ETL, linked to a data source that uses a custom script to load the import set. The data pull from Zoom APIs is working successfully, and records are reaching the import set.
However, when executing the RTM, the process fails during the Identification and Reconciliation (IRE) step. The custom CMDB table has a reference field (u_asset) that points to alm_asset. During transformation, the system throws “missing mandatory field” errors for Asset-related fields, even though all required mappings (Model, Serial Number, and Name) have been defined in the Transform Map.
I’ve observed that:
Expected Behavior:
The RTM should either:
Create new CI records when no match is found,
Or update existing CIs without throwing mandatory field errors on referenced Asset or Model fields.
Can anyone help me here?
