Process Import Set to Multiple Tables

[DylanBlumenberg]

Hi everyone, 

We get an Excel file from Dell that contains our computer assets and the contract they are associated with. We want to process that Excel file and do the following:

• Create a contract if one does not exist.
• On the Asset record, add the contract to the cmn_lease_contract field.
• Create a record on the clm_m2m_contract_asset table linking the asset record to the contract record. 

I've successfully done the above actions by using transform maps to process the Dell Excel one time to each of the tables, but ideally this is automated process, so I'm thinking there has to be a better way. Does anyone have experience doing something like this?

[Marcos Michalsk · Accepted solution]

Hello,

To effectively execute an import, you should create an import set of the robust type (Robust Transform Map). Using the RTM, it will be possible to create a staging table for data processing and execute the entire relational structure needed for each row at once, ensuring there are no orphan entities due to missing information.

Documentation: ServiceNow Robust Import Set Transformers

I hope this helps.

Best regards.

[DylanBlumenberg]

This looks like exactly what I need. Thanks for making me aware of this Marcos!