IntegrationHub ETL Nested Ojbects

Ned F
Tera Contributor

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.

image.png

 

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!

1 REPLY 1

Vijaya_Mnpram
Tera Guru

@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

 

This is a demo of a new Quebec feature in Integration Hub ETL that natively processes nested payloads without scripting by Siyou Li. This powerful new feature can process structured data from data sources like XLM or JSON for example. Data Foundations Playlist: ...