Importing relationships- reference field value

[joanct]

In an effort to get our CI data in SNOW configuration management , we   successfully identified critical CIs from old system and imported CIs into SNOW CMDB tables Now our team wants to import relationships to cmdb-rel-ci table from external source- CSV template extract.We have verified relationship type exists in cmdb-rel-type . But while trying to come up with a web service import set and transform map , we ran into challenges identifying whether its the tablename or the CI name that should be mapped in parent and child fields - so is it the CI name or CI's table name .if its the CI name - say VMserverC23 , is a script required for the parent and child   field on the web service transform map to check that specific CI data being imported exists in their original tables? what is reference field value on transform maps?

[Subhajit1]

Hi JoanC,

It will have to be the CI name that needs to be uploaded to the cmdb_rel_ci table for Child and Parent fields.

Yes you can write a Transform Script if the Source (Staging) table's Child and Parent Value exist on the CMDB or not. For that you can do a Glide Query on the CMDB table.

Thanks,

Subhajit

[joanct]

I am interested in finding out if we can write script on parent and child on web service transform map for rel-ci table , so when   data is coming into cmdb_rel_ci table , it can check if that parent and child exist on the cmdb-ci table. But what is the use of "referenced value field name" that comes on the field map for a target field? has anyone used it?

[Ishan4]

Hi,

Did you find the solution ? I am exactly at same situation.

[Bhavesh Jain1]

Your excel should be something like below.

[joanct]

can this script be used on web service transform map? how to update ,if we are parent and child are not mapped on transform map , then how to update without using coalesce?