Does anyone have a working example of the Referenced Entity within RTE Field Mapping?
Here are the details of my ETL Definition:
5 entities
Import Set (import)
temp (temp)
Azure Subscriptions (sub) - azure_id (PK, string)
Azure Resource Groups (rg) (azure_id, PK, string)
CI Relationships (rel) (child, parent, type)
Mappings
Import set > Temp
Temp > Azure Subscriptions
Temp > Azure Resource Groups
Temp > CI Relationships
Within the Temp > CI Relationships mapping, I have 2 RTE Field Mapping;
Target field: CI Relationships.parent (Referenced Entity = Azure Subscriptions 1)
Target field: CI Relationships.child (Referenced Entity = Azure Resource Groups)
Unfortunately, an empty record is being created in the CI Relationships (cmdb_rel_ci) table.
Any help would be appreciated.
