Choice Action functionality in CMDB Integration Studio Application Data Source

[Swapna Abburi]

Hi,

In transform maps, ServiceNow has a functionality to select Choice action (Create, Reject and Ignore) for reference/choice field mapping. Do we have such functionality in Robust Transform IntegrationHub ETL. We are facing this issue in Service Graph connector - Intune. It is inserting new model records to hardware model table and we want to restrict the creation of new models from Intune integration. 

Thanks,

Swapna 

[Kristen Ankeny]

Best option here is a transform field that looks for an existing model and gets the sys_id if found, otherwise leave the transform field empty. This way it wouldn't create entries. I'm not positive, but you could also try the Lookup transform type. If that doesn't work the way you expect, script it instead.

[CMDB Whisperer]

In IH-ETL you can use Scripted Transforms in combination with Table Lookups to do effectively the same thing, but you have to explicitly perform the table lookup yourself and code the logic for what to do based on the output.  Ironically, one of the areas where you have to write more code in the no-code/low-code solution.  🙂  But the good news is that what you can do with Table Lookups is much more robust than what is allowed in traditional Transform Maps.