Parsing for nested Json

Hello

With advent of OTEL data it is becoming too complex today with this nested data concept. For example LogicMonitor data Publisher export data in certain format and this is heavily nested. Example is found in this link https://www.logicmonitor.com/support/logicmonitor-data-publisher-for-kafka-receiver

I had been trying for days and nothing seems to flatten it. On top if it needs to go to Splunk HEC that adds more complexity as splunk needs 1 Metrics per event. This has become too complex and am about to give up. No AI chatgpt java script is able to handle this 

Example 

{
  "resourceMetrics": [
    {
      "resource": {
        "attributes": [
          {
            "key": "hostName",
            "value": {
              "stringValue": "127.0.0.1"
            }
          },
          {
            "key": "hostId",
            "value": {
              "stringValue": "13359"
            }
          }
        ]
      },
      "scopeMetrics": [
        {
          "scope": {
            "name": "LogicMonitor_Collector_JVMGarbageCollection",
            "attributes": [
              {
                "key": "collector",
                "value": {
                  "stringValue": "jmx"
                }
              },
              {
                "key": "epoch",
                "value": {
                  "stringValue": "1779370342098"
                }
              },
              {
                "key": "datasourceId",
                "value": {
                  "stringValue": "897"
                }
              },
              {
                "key": "datasourceInstanceId",
                "value": {
                  "stringValue": "537954400"
                }
              }
            ]
          },
          "metrics": [
            {
              "name": "CollectionTime",
              "sum": {
                "dataPoints": [
                  {
                    "startTimeUnixNano": "1779370342098000000",
                    "timeUnixNano": "1779370342098000000",
                    "asDouble": 140,
                    "attributes": [
                      {
                        "key": "dataSourceInstanceName",
                        "value": {
                          "stringValue": "LogicMonitor_Collector_JVMGarbageCollection-G1 Concurrent GC"
                        }
                      },
                      {
                        "key": "datapointid",
                        "value": {
                          "stringValue": "5429"
                        }
                      },
                      {
                        "key": "wildValue",
                        "value": {
                          "stringValue": "G1 Concurrent GC"
                        }
                      },
                      {
                        "key": "wildAlias",
                        "value": {
                          "stringValue": "G1 Concurrent GC"
                        }
                      }
                    ]
                  }
                ],
                "aggregationTemporality": "AGGREGATION_TEMPORALITY_DELTA",
                "isMonotonic": true
              }
            },
            {
              "name": "Count",
              "sum": {
                "dataPoints": [
                  {
                    "startTimeUnixNano": "1779370342098000000",
                    "timeUnixNano": "1779370342098000000",
                    "asDouble": 16,
                    "attributes": [
                      {
                        "key": "dataSourceInstanceName",
                        "value": {
                          "stringValue": "LogicMonitor_Collector_JVMGarbageCollection-G1 Concurrent GC"
                        }
                      },
                      {
                        "key": "datapointid",
                        "value": {
                          "stringValue": "5430"
                        }
                      },
                      {
                        "key": "wildValue",
                        "value": {
                          "stringValue": "G1 Concurrent GC"
                        }
                      },
                      {
                        "key": "wildAlias",
                        "value": {
                          "stringValue": "G1 Concurrent GC"
                        }
                      }
                    ]
                  }
                ],
                "aggregationTemporality": "AGGREGATION_TEMPORALITY_DELTA",
                "isMonotonic": true
              }
            }
          ]
        }
      ]
    }
  ],
  "_time": 1779388930.109
}