Hi Community,
I am working on getting the ServiceNow integration with IT Component fact sheets Software working. Anyone who has done this is aware of the aggregation challenges. We are using SAMPro, so I am using the cmdb_sam_sw_discovery table as the primary table. Looks fine. However, the aggregated product name is a reference field as opposed to normalized text. This is normal in ServiceNow. SAP LeanIX indicates that dot walking is possible (ServiceNow Integration: Advanced Configuration | SAP Help Portal). I made the Advanced modifications to the JSON (two different ways as the documentation presents the information in two different configuration - sweet right? )
"fieldMapping": {
"mapping": {
"name": {
"fieldType": "FOREIGN_FIELD",
"foreignFieldName": "norm_product.prod_name",
"useNormalDirection": true,
"referenceTable": "samp_sw_product"
},
"externalId/externalId": {
"fieldType": "EXTERNAL_ID",
"foreignFieldName": "sys_id",
"useNormalDirection": true
}
}
},
So the fiield in cmdb_sam_sw_discovery has a field norm_product which is a reference field to the table samp_sw_product and the field prod_name. Easy. ServiceNow dot walking would format this as norm_product.prod_name. This is consistent with the documentation. However, when I attempt to save the configuration I get:
Error while saving your settings
<li>Can not resolve a column on table 'cmdb_sam_sw_discovery_model' that represents the name.</li>
So --- the question --- Has anyone successfully configured this dot walking? Or perhaps there is another way to get this done properly.
