IntegrationHub ETL - error IRE mandatory fields missing

[KarankiS]

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:

• Existing CMDB records are updated successfully through IRE.

• New records are not being created when no matching CI is found.

Expected Behavior:

The RTM should either:

1. Create new CI records when no match is found,

2. Or update existing CIs without throwing mandatory field errors on referenced Asset or Model fields.

Can anyone help me here?

[TedN]

Check the CI Identifier for the CI Class you're trying to add records to.

If the boolean *Allow null values" is false IRE doesn't accept null values (empty field) which you will always have for new records in the CMDB.

I've stumbled upon this a few times when I've setup new IH ETL configs for non-CMDB tables.

Default the value for "Allow null values" is false...

[fknell]

Hi @KarankiS,

if you don't need an asset for your CI class, why don't you overwrite the asset tracking strategy for your corresponding product model or create one to avoid it?

Another alternative is to create a model category for Zoom Devices, that doesn't map an asset table. 

Hope this helps!