Trouble Mapping Nested JSON Data in IH-ETL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-15-2025 10:33 AM
Hi!
I'm looking into IH-ETL to import data in the form of nested JSON into the CMDB table, but I'm stuck at a point where, when I run it, the records in the CMDB are transformed but the IP address field is empty.
From the sample data I have attached below, you can see that the ipAddress is at a different level than the connectionId (which I have mapped to the Source Native Key as the Unique Key). When using the IH-ETL Hub to map by dragging and dropping the ipAddress property into the field, I receive an error stating "Mapping brand of the data is not allowed" (as shown in the image).
I have learned that within the same Class where I map properties to fields, we can only map properties at the same level in JSON such as displayName and connectionId. Is there any other solution that could help populate the IP address that not same level along with the other properties during the transformation?
Thank you!
