IntegrationHub ETL Nested Ojbects
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thursday
Hello!
I've been tasked with installing and configuring the Service Graph Connector for Google Console to maintain our ChromeOS devices with our CMDB. I got the baseline installation of the plugin to work and data is flowing. The end user requested the customization of including CPU and RAM details. The RAM part was easy since the systemRamTotal was already in the top level. I simply added a transform to convert the value to MBs and updated the mapping.
The CPU details is proving to be a little more challenging as it has Nested Objects. It's an array that seems to have a record per CPU core. I'm primarily trying to access the model (cpuInfo[0].model) record. That data point seems to be the same per core, so I only need one of the values.
I've attempted to update the mapping to have the model added, but quickly discovered that doesn't work between levels.
I've also attempted to update the Robust Transform Engine to see if I could have the model added to the top level with no luck. I don't see the JSON record on the top level record either. I do see it in a u_data column in the staging table.
Is anyone familiar with working with nested objects in a Service Graph Connector that can help, point me at a good reference, or recommend something from ServiceNow University that can help me?
Thank you!
- Labels:
-
Service Graph Connector
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yesterday
@Ned F Before you do the mapping, how about creating a variable in Step 2 of the IntegrationHub ETL and load the value of CPUInfo.Model into that. In the Step3 of the IntegrationHub ETL, you can map that variable to the CPU field.
Just like any other variable, which are modified before mapping. Also, here is the video from Servicenow Academy related to nested objects.
https://youtu.be/jonkMkFiNaQ?si=A9oZiMfF6E7EEYOk
