Can schemaHints dynamically handle nested json structures?

ChristianRRL
Honored Contributor

‎08-12-2025 10:38 AM

Hi there, as I'm learning more about schemaHints, it seems like an incredibly useful way to unpack some of my json data. However, I've hit what is either a limitation of schemaHints or of my understanding of how to use it properly.

Below I have an example of a somewhat standard read_files query. However, rather than applying schemaHints to a single nested structure, I would like to apply a schemaHints pattern to multiple nested fields inside *all* structs inside a given sub_data field (e.g. everything inside elementData.element.data.*).

ChristianRRL_0-1755017647152.png

However, when I try using the `*` wildcard, I quickly get an error:

ChristianRRL_2-1755018810157.png

The only way I've seen so far to get close to (but not quite) where I'm wanting to get, is I can apply a double map<string,string> on the data field, like so:

ChristianRRL_3-1755019651215.png

But the challenge is I want to map two separate sub-fields (dataPoint & values).

If I try to triple map, I lose either the dataPoint field or the values field (depending on how I map it):

e.g. Mapping dataPoint properly (but values is lost)

ChristianRRL_6-1755020076906.png

e.g. Mapping values properly (but dataPoint is lost)

ChristianRRL_5-1755019866487.png

Any feedback/input on this would be much appreciated!

+Side-note: Props to @genevive_mdonça for your post Handling Complex Nested JSON in Databricks Using s... - Databricks Community - 116210. This was a great springboard!

0 Kudos

Brahmareddy
Esteemed Contributor II

‎08-12-2025 09:38 PM

Hi ChristianRRL,

How are you doing today? as per my understanding, you're absolutely right that schemaHints is powerful for handling semi-structured JSON, especially with deeply nested fields. But it does have some limitations—one being that it doesn’t currently support applying complex hints like multiple field patterns (*) across multiple nested structures within arrays or structs. When you try using wildcards too broadly (like elementData.element.data.*), it can’t resolve how to map both dataPoint and values at the same level—so one ends up getting lost. A practical workaround would be to define the exact path to each field you're trying to unpack instead of using wildcards. If the nested schema is known and consistent, consider writing a more explicit schema or use a combination of from_json and withColumn to parse it manually after ingesting the raw data. It’s a bit more work upfront, but gives you precise control over both dataPoint and values. Hopefully, Databricks will enhance schemaHints to handle more flexible nesting in future releases. Keep experimenting—you're digging into an advanced area that many avoid, and it's a great skill to build!

Regards,

Brahma

View solution in original post

ChristianRRL
Honored Contributor
In response to Brahmareddy

‎08-13-2025 07:27 PM

Ah I see, thanks for the explanation. In our case, the nested schema is neither fully known nor fully consistent (I'd say mostly consistent, but there are edge-cases). I'll need to tinker with this a bit, but I think I have a workaround in mind for this case.

This is a bit of an unfortunate limitation of schemaHints at the moment, but I agree it would be great if they enhance schemaHints to support this in the future!

Brahmareddy
Esteemed Contributor II
In response to ChristianRRL

‎08-13-2025 07:35 PM

Absolutely ChristianRRL, when your nested schema isn't fully known or consistent, schemaHints can only take you so far before you need a workaround. A flexible pattern in these cases is to first ingest the raw JSON using permissive mode (with schema inference or minimal hints), and then flatten and transform the data using from_json or explode + selectExpr logic in a second stage, once you have more control. This two-stage approach gives you better resilience against edge cases, and also allows you to isolate logic for future schema evolution. And yes, here's hoping Databricks @Sujitha improves schemaHints to support wildcards and more advanced nested patterns—would definitely make streaming and ingestion pipelines smoother.

View solution in original post

boitumelodikoko
Databricks Partner

‎08-12-2025 09:54 PM

Hi @ChristianRRL,

Would you be able to share a small sample of your JSON file (with any sensitive data removed)? That way, I can try to replicate your use case and see if we can get schemaHints working across multiple nested fields without losing dataPoint or values.

Once I can test it end-to-end, I'll share an example query or transformation that achieves what you're looking for.


Thanks,
Boitumelo

ChristianRRL
Honored Contributor
In response to boitumelodikoko

‎08-13-2025 07:30 PM

I'll be a bit tied up the next couple of days, but I'll try and get something pulled together to share by Friday or early next week!

ChristianRRL
Honored Contributor
In response to boitumelodikoko

‎08-29-2025 11:31 AM

Hey @boitumelodikoko , got busier than expected, but here's the requested sample json. I'm curious if you'd know of a better/easier way to set both dataPoint and values as string across all "NESTED_DATA_NAME_X"?

ChristianRRL_0-1756492275834.png

 

json_text = '{"packageHeader":{"transactionId":"5c3661ac-abdd-480c-88b6-c3c128bce7bd","rootName":"rootName","endpointName":"report","elementType":"Generator","elementName":"rootName","intervalSize":5,"environment":"production","startDate":"2025-07-10T04:00:00","endDate":"2025-07-10T04:10:00"},"elementData":[{"elementName":"elementName1","elementIdentifier":"ae5f1a94-33b4-4001-b926-499dc0425bf1","elementDefinitionIdentifier":2,"metaData":{},"data":{}},{"elementName":"elementName2","elementIdentifier":"c647ffb1-b8ba-4b34-8b45-8590fed273ef","elementDefinitionIdentifier":2,"metaData":{},"data":{"NESTED_DATA_NAME_1":{"dataPoint":{"name":"NESTED_DATA_NAME_1","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.975200119018556},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.21553290049235}]},"NESTED_DATA_NAME_2":{"dataPoint":{"name":"NESTED_DATA_NAME_2","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"ON"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"ON"}]},"NESTED_DATA_NAME_3":{"dataPoint":{"name":"NESTED_DATA_NAME_3","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.0},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0}]},"NESTED_DATA_NAME_5":{"dataPoint":{"name":"NESTED_DATA_NAME_5","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.0},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0}]},"NESTED_DATA_NAME_6":{"dataPoint":{"name":"NESTED_DATA_NAME_6","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"Off"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"Off"}]},"NESTED_DATA_NAME_7":{"dataPoint":{"name":"NESTED_DATA_NAME_7","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.00011502826237119734},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.00011502826237119734}]}}},{"elementName":"elementName3","elementIdentifier":"3e4bd6b5-389d-4297-a65e-9f717a0eebda","elementDefinitionIdentifier":2,"metaData":{},"data":{"NESTED_DATA_NAME_1":{"dataPoint":{"name":"NESTED_DATA_NAME_1","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.975200119018556},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.21553290049235}]},"NESTED_DATA_NAME_2":{"dataPoint":{"name":"NESTED_DATA_NAME_2","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"ON"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"ON"}]},"NESTED_DATA_NAME_3":{"dataPoint":{"name":"NESTED_DATA_NAME_3","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.0},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0}]},"NESTED_DATA_NAME_5":{"dataPoint":{"name":"NESTED_DATA_NAME_5","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.0},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0}]},"NESTED_DATA_NAME_6":{"dataPoint":{"name":"NESTED_DATA_NAME_6","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"Off"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"Off"}]},"NESTED_DATA_NAME_7":{"dataPoint":{"name":"NESTED_DATA_NAME_7","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.0},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0}]}}},{"elementName":"elementName4","elementIdentifier":"1a167479-9314-4031-9155-31a0c36af870","elementDefinitionIdentifier":2,"metaData":{},"data":{"NESTED_DATA_NAME_1":{"dataPoint":{"name":"NESTED_DATA_NAME_1","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.966800231933593},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.1588000869751}]},"NESTED_DATA_NAME_2":{"dataPoint":{"name":"NESTED_DATA_NAME_2","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"ON"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"ON"}]},"NESTED_DATA_NAME_3":{"dataPoint":{"name":"NESTED_DATA_NAME_3","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.0},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0}]},"NESTED_DATA_NAME_5":{"dataPoint":{"name":"NESTED_DATA_NAME_5","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.0},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0}]},"NESTED_DATA_NAME_6":{"dataPoint":{"name":"NESTED_DATA_NAME_6","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"Off"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"Off"}]},"NESTED_DATA_NAME_7":{"dataPoint":{"name":"NESTED_DATA_NAME_7","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.0},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0}]}}},{"elementName":"elementName5","elementIdentifier":"7831fc23-0d40-42d9-9c2c-fc803d1d6b36","elementDefinitionIdentifier":2,"metaData":{},"data":{"NESTED_DATA_NAME_1":{"dataPoint":{"name":"NESTED_DATA_NAME_1","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.966800231933593},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.1588000869751}]},"NESTED_DATA_NAME_2":{"dataPoint":{"name":"NESTED_DATA_NAME_2","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"ON"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"ON"}]},"NESTED_DATA_NAME_3":{"dataPoint":{"name":"NESTED_DATA_NAME_3","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.0},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0}]},"NESTED_DATA_NAME_5":{"dataPoint":{"name":"NESTED_DATA_NAME_5","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.0},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0}]},"NESTED_DATA_NAME_6":{"dataPoint":{"name":"NESTED_DATA_NAME_6","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"Off"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"Off"}]},"NESTED_DATA_NAME_7":{"dataPoint":{"name":"NESTED_DATA_NAME_7","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.0},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0}]}}},{"elementName":"elementName6","elementIdentifier":"5ce98e58-1f62-4620-b6e8-768f14491071","elementDefinitionIdentifier":2,"metaData":{},"data":{"NESTED_DATA_NAME_1":{"dataPoint":{"name":"NESTED_DATA_NAME_1","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.992400665283203},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.20739938100179}]},"NESTED_DATA_NAME_2":{"dataPoint":{"name":"NESTED_DATA_NAME_2","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"ON"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"ON"}]},"NESTED_DATA_NAME_3":{"dataPoint":{"name":"NESTED_DATA_NAME_3","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.0},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0}]},"NESTED_DATA_NAME_5":{"dataPoint":{"name":"NESTED_DATA_NAME_5","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.0},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0}]},"NESTED_DATA_NAME_6":{"dataPoint":{"name":"NESTED_DATA_NAME_6","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"Off"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"Off"}]},"NESTED_DATA_NAME_7":{"dataPoint":{"name":"NESTED_DATA_NAME_7","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.0},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0}]}}},{"elementName":"elementName7","elementIdentifier":"2287c2e6-4cb0-4f96-b7e5-a99033a1bbcf","elementDefinitionIdentifier":2,"metaData":{},"data":{"NESTED_DATA_NAME_1":{"dataPoint":{"name":"NESTED_DATA_NAME_1","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.992400665283203},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.20739938100179}]},"NESTED_DATA_NAME_2":{"dataPoint":{"name":"NESTED_DATA_NAME_2","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"ON"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"ON"}]},"NESTED_DATA_NAME_3":{"dataPoint":{"name":"NESTED_DATA_NAME_3","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.0},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0}]},"NESTED_DATA_NAME_5":{"dataPoint":{"name":"NESTED_DATA_NAME_5","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.0},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0}]},"NESTED_DATA_NAME_6":{"dataPoint":{"name":"NESTED_DATA_NAME_6","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"Off"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"Off"}]},"NESTED_DATA_NAME_7":{"dataPoint":{"name":"NESTED_DATA_NAME_7","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.0},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0}]}}},{"elementName":"elementName8","elementIdentifier":"fc0c6b40-d548-4554-9e57-aa7a38eb1a08","elementDefinitionIdentifier":2,"metaData":{},"data":{"NESTED_DATA_NAME_1":{"dataPoint":{"name":"NESTED_DATA_NAME_1","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.966800231933593},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.1588000869751}]},"NESTED_DATA_NAME_2":{"dataPoint":{"name":"NESTED_DATA_NAME_2","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"ON"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"ON"}]},"NESTED_DATA_NAME_3":{"dataPoint":{"name":"NESTED_DATA_NAME_3","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.73599884033203},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.45600138346354}]},"NESTED_DATA_NAME_5":{"dataPoint":{"name":"NESTED_DATA_NAME_5","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.54224950154622},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0438220469157}]},"NESTED_DATA_NAME_6":{"dataPoint":{"name":"NESTED_DATA_NAME_6","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"Off"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"Off"}]},"NESTED_DATA_NAME_7":{"dataPoint":{"name":"NESTED_DATA_NAME_7","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.55244023640951},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.029533106486}]}}},{"elementName":"elementName9","elementIdentifier":"42ea05e7-5508-44b7-8807-ea5ff71c591c","elementDefinitionIdentifier":2,"metaData":{},"data":{"NESTED_DATA_NAME_1":{"dataPoint":{"name":"NESTED_DATA_NAME_1","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.966800231933593},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.1588000869751}]},"NESTED_DATA_NAME_2":{"dataPoint":{"name":"NESTED_DATA_NAME_2","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"ON"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"ON"}]},"NESTED_DATA_NAME_3":{"dataPoint":{"name":"NESTED_DATA_NAME_3","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.820000762939454},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.560000762939453}]},"NESTED_DATA_NAME_5":{"dataPoint":{"name":"NESTED_DATA_NAME_5","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.15562644322713},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.029564965566}]},"NESTED_DATA_NAME_6":{"dataPoint":{"name":"NESTED_DATA_NAME_6","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"Off"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"Off"}]},"NESTED_DATA_NAME_7":{"dataPoint":{"name":"NESTED_DATA_NAME_7","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.164396537144977},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.03222537994385}]}}},{"elementName":"elementName10","elementIdentifier":"a223e254-e73c-4305-9092-feb1dcd6defd","elementDefinitionIdentifier":2,"metaData":{},"data":{"NESTED_DATA_NAME_1":{"dataPoint":{"name":"NESTED_DATA_NAME_1","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.966800231933593},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.1588000869751}]},"NESTED_DATA_NAME_2":{"dataPoint":{"name":"NESTED_DATA_NAME_2","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"ON"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"ON"}]},"NESTED_DATA_NAME_3":{"dataPoint":{"name":"NESTED_DATA_NAME_3","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.41600128173828},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.02066528320312}]},"NESTED_DATA_NAME_5":{"dataPoint":{"name":"NESTED_DATA_NAME_5","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.78730902353922},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":47.70534975687663}]},"NESTED_DATA_NAME_6":{"dataPoint":{"name":"NESTED_DATA_NAME_6","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"Off"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"Off"}]},"NESTED_DATA_NAME_7":{"dataPoint":{"name":"NESTED_DATA_NAME_7","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.784257837931314},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":47.73812927246094}]}}},{"elementName":"elementName11","elementIdentifier":"f6570cd7-20f8-4af2-9d4e-4f11cf292f30","elementDefinitionIdentifier":2,"metaData":{},"data":{"NESTED_DATA_NAME_1":{"dataPoint":{"name":"NESTED_DATA_NAME_1","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.918800277709963},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.17413386027018}]},"NESTED_DATA_NAME_2":{"dataPoint":{"name":"NESTED_DATA_NAME_2","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"ON"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"ON"}]},"NESTED_DATA_NAME_3":{"dataPoint":{"name":"NESTED_DATA_NAME_3","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.09600128173828},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.16466601053874}]},"NESTED_DATA_NAME_5":{"dataPoint":{"name":"NESTED_DATA_NAME_5","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.71298851013184},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.921189613342285}]},"NESTED_DATA_NAME_6":{"dataPoint":{"name":"NESTED_DATA_NAME_6","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"Off"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"Off"}]},"NESTED_DATA_NAME_7":{"dataPoint":{"name":"NESTED_DATA_NAME_7","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.71538701375326},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.910447934468586}]}}},{"elementName":"elementName12","elementIdentifier":"3376ef12-5e62-4f62-a4b4-acc786cba346","elementDefinitionIdentifier":2,"metaData":{},"data":{"NESTED_DATA_NAME_1":{"dataPoint":{"name":"NESTED_DATA_NAME_1","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.918800277709963},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.17413386027018}]},"NESTED_DATA_NAME_2":{"dataPoint":{"name":"NESTED_DATA_NAME_2","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"ON"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"ON"}]},"NESTED_DATA_NAME_3":{"dataPoint":{"name":"NESTED_DATA_NAME_3","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.37600067138672},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.48600003560384}]},"NESTED_DATA_NAME_5":{"dataPoint":{"name":"NESTED_DATA_NAME_5","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.024653956095378},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.64366638183594}]},"NESTED_DATA_NAME_6":{"dataPoint":{"name":"NESTED_DATA_NAME_6","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"Off"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"Off"}]},"NESTED_DATA_NAME_7":{"dataPoint":{"name":"NESTED_DATA_NAME_7","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.02808125813802},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.645924688975015}]}}},{"elementName":"elementName13","elementIdentifier":"a6cd6477-a82b-46f7-b6b6-1033f14908ba","elementDefinitionIdentifier":2,"metaData":{},"data":{}},{"elementName":"elementName14","elementIdentifier":"2dba4e48-faa2-4f23-9db0-a1fe74721af8","elementDefinitionIdentifier":2,"metaData":{},"data":{"NESTED_DATA_NAME_1":{"dataPoint":{"name":"NESTED_DATA_NAME_1","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.09960029602051},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.821399726867675}]},"NESTED_DATA_NAME_2":{"dataPoint":{"name":"NESTED_DATA_NAME_2","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"ON"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"ON"}]},"NESTED_DATA_NAME_3":{"dataPoint":{"name":"NESTED_DATA_NAME_3","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.0},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0}]},"NESTED_DATA_NAME_4":{"dataPoint":{"name":"NESTED_DATA_NAME_4","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.4000000953674316},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.4000000953674316}]},"NESTED_DATA_NAME_5":{"dataPoint":{"name":"NESTED_DATA_NAME_5","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.4000000953674316},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.4000000953674316}]},"NESTED_DATA_NAME_6":{"dataPoint":{"name":"NESTED_DATA_NAME_6","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"On"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"On"}]},"NESTED_DATA_NAME_7":{"dataPoint":{"name":"NESTED_DATA_NAME_7","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.0},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0}]}}},{"elementName":"elementName15","elementIdentifier":"42339846-d711-4a64-b562-1c9baceec04e","elementDefinitionIdentifier":2,"metaData":{},"data":{"NESTED_DATA_NAME_1":{"dataPoint":{"name":"NESTED_DATA_NAME_1","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.09960029602051},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.821399726867675}]},"NESTED_DATA_NAME_2":{"dataPoint":{"name":"NESTED_DATA_NAME_2","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"ON"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"ON"}]},"NESTED_DATA_NAME_3":{"dataPoint":{"name":"NESTED_DATA_NAME_3","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.0},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0}]},"NESTED_DATA_NAME_5":{"dataPoint":{"name":"NESTED_DATA_NAME_5","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.0},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0}]},"NESTED_DATA_NAME_6":{"dataPoint":{"name":"NESTED_DATA_NAME_6","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"Off"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"Off"}]},"NESTED_DATA_NAME_7":{"dataPoint":{"name":"NESTED_DATA_NAME_7","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.0},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0}]}}},{"elementName":"elementName16","elementIdentifier":"3767312d-7d5b-4b8e-a7ea-7777781f6f9c","elementDefinitionIdentifier":2,"metaData":{},"data":{"NESTED_DATA_NAME_1":{"dataPoint":{"name":"NESTED_DATA_NAME_1","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.09960029602051},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.821399726867675}]},"NESTED_DATA_NAME_2":{"dataPoint":{"name":"NESTED_DATA_NAME_2","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"ON"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"ON"}]},"NESTED_DATA_NAME_3":{"dataPoint":{"name":"NESTED_DATA_NAME_3","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.0},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0}]},"NESTED_DATA_NAME_5":{"dataPoint":{"name":"NESTED_DATA_NAME_5","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.0},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0}]},"NESTED_DATA_NAME_6":{"dataPoint":{"name":"NESTED_DATA_NAME_6","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"Off"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"Off"}]},"NESTED_DATA_NAME_7":{"dataPoint":{"name":"NESTED_DATA_NAME_7","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.0},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0}]}}},{"elementName":"elementName17","elementIdentifier":"a569c7a5-4fe3-4d1d-9f03-c2cc1b264d69","elementDefinitionIdentifier":2,"metaData":{},"data":{"NESTED_DATA_NAME_1":{"dataPoint":{"name":"NESTED_DATA_NAME_1","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.548799285888673},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.957799746195477}]},"NESTED_DATA_NAME_2":{"dataPoint":{"name":"NESTED_DATA_NAME_2","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"ON"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"ON"}]},"NESTED_DATA_NAME_3":{"dataPoint":{"name":"NESTED_DATA_NAME_3","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.61199859619141},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.5299984741211}]},"NESTED_DATA_NAME_5":{"dataPoint":{"name":"NESTED_DATA_NAME_5","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.73433497111003},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.2483349609375}]},"NESTED_DATA_NAME_6":{"dataPoint":{"name":"NESTED_DATA_NAME_6","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"Off"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"Off"}]},"NESTED_DATA_NAME_7":{"dataPoint":{"name":"NESTED_DATA_NAME_7","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.73500165303548},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.23400133768718}]}}},{"elementName":"elementName18","elementIdentifier":"d03f45b2-a5ec-41b2-b6a5-e448e1d1e1b5","elementDefinitionIdentifier":2,"metaData":{},"data":{"NESTED_DATA_NAME_1":{"dataPoint":{"name":"NESTED_DATA_NAME_1","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.548799285888673},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.957799746195477}]},"NESTED_DATA_NAME_2":{"dataPoint":{"name":"NESTED_DATA_NAME_2","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"ON"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"ON"}]},"NESTED_DATA_NAME_3":{"dataPoint":{"name":"NESTED_DATA_NAME_3","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.18400115966797},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.7326638285319}]},"NESTED_DATA_NAME_5":{"dataPoint":{"name":"NESTED_DATA_NAME_5","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.50466842651367},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.90733510335286}]},"NESTED_DATA_NAME_6":{"dataPoint":{"name":"NESTED_DATA_NAME_6","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"Off"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"Off"}]},"NESTED_DATA_NAME_7":{"dataPoint":{"name":"NESTED_DATA_NAME_7","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.51566881815593},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.91100161234537}]}}},{"elementName":"elementName19","elementIdentifier":"2b6edcc9-01c2-4bc6-ab3c-4e790515ea5d","elementDefinitionIdentifier":2,"metaData":{},"data":{"NESTED_DATA_NAME_1":{"dataPoint":{"name":"NESTED_DATA_NAME_1","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.548799285888673},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.957799746195477}]},"NESTED_DATA_NAME_2":{"dataPoint":{"name":"NESTED_DATA_NAME_2","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"ON"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"ON"}]},"NESTED_DATA_NAME_3":{"dataPoint":{"name":"NESTED_DATA_NAME_3","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.72433169047038},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.10899701436361}]},"NESTED_DATA_NAME_5":{"dataPoint":{"name":"NESTED_DATA_NAME_5","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.91033480326335},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.3211684926351}]},"NESTED_DATA_NAME_6":{"dataPoint":{"name":"NESTED_DATA_NAME_6","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"Off"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"Off"}]},"NESTED_DATA_NAME_7":{"dataPoint":{"name":"NESTED_DATA_NAME_7","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.91650160471599},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.29516859690348}]}}},{"elementName":"elementName20","elementIdentifier":"586041ec-8443-4130-a921-ab13f3452a0f","elementDefinitionIdentifier":2,"metaData":{},"data":{"NESTED_DATA_NAME_1":{"dataPoint":{"name":"NESTED_DATA_NAME_1","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.548799285888673},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.957799746195477}]},"NESTED_DATA_NAME_2":{"dataPoint":{"name":"NESTED_DATA_NAME_2","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"ON"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"ON"}]},"NESTED_DATA_NAME_3":{"dataPoint":{"name":"NESTED_DATA_NAME_3","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.90733591715495},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.1393305460612}]},"NESTED_DATA_NAME_5":{"dataPoint":{"name":"NESTED_DATA_NAME_5","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.49500190734864},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.70533476511638}]},"NESTED_DATA_NAME_6":{"dataPoint":{"name":"NESTED_DATA_NAME_6","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"Off"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"Off"}]},"NESTED_DATA_NAME_7":{"dataPoint":{"name":"NESTED_DATA_NAME_7","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.48866841634114},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.7558347829183}]}}},{"elementName":"elementName21","elementIdentifier":"e4164f1f-4f33-4a9e-8545-0e013680070f","elementDefinitionIdentifier":2,"metaData":{},"data":{"NESTED_DATA_NAME_1":{"dataPoint":{"name":"NESTED_DATA_NAME_1","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.85120018005371},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.12226609547933}]},"NESTED_DATA_NAME_2":{"dataPoint":{"name":"NESTED_DATA_NAME_2","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"ON"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"ON"}]},"NESTED_DATA_NAME_3":{"dataPoint":{"name":"NESTED_DATA_NAME_3","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.184667371114095},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.14766523996989}]},"NESTED_DATA_NAME_5":{"dataPoint":{"name":"NESTED_DATA_NAME_5","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.618000780741376},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.665667231877645}]},"NESTED_DATA_NAME_6":{"dataPoint":{"name":"NESTED_DATA_NAME_6","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"Off"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"Off"}]},"NESTED_DATA_NAME_7":{"dataPoint":{"name":"NESTED_DATA_NAME_7","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.62150080998739},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.669000590642295}]}}},{"elementName":"elementName22","elementIdentifier":"104232c3-ded4-4b87-801a-eeb3c9d2744f","elementDefinitionIdentifier":2,"metaData":{},"data":{"NESTED_DATA_NAME_1":{"dataPoint":{"name":"NESTED_DATA_NAME_1","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.85120018005371},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.12226609547933}]},"NESTED_DATA_NAME_2":{"dataPoint":{"name":"NESTED_DATA_NAME_2","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"ON"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"ON"}]},"NESTED_DATA_NAME_3":{"dataPoint":{"name":"NESTED_DATA_NAME_3","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.3156680170695},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.14733339945475}]},"NESTED_DATA_NAME_5":{"dataPoint":{"name":"NESTED_DATA_NAME_5","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.92333425945706},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.61900051328871}]},"NESTED_DATA_NAME_6":{"dataPoint":{"name":"NESTED_DATA_NAME_6","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"Off"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"Off"}]},"NESTED_DATA_NAME_7":{"dataPoint":{"name":"NESTED_DATA_NAME_7","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.92550085703532},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.60316721598307}]}}},{"elementName":"elementName23","elementIdentifier":"05cc3c94-2227-4086-831c-4d3e55f7ab61","elementDefinitionIdentifier":2,"metaData":{},"data":{"NESTED_DATA_NAME_1":{"dataPoint":{"name":"NESTED_DATA_NAME_1","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.882799453735352},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.134132944742838}]},"NESTED_DATA_NAME_2":{"dataPoint":{"name":"NESTED_DATA_NAME_2","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"ON"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"ON"}]},"NESTED_DATA_NAME_3":{"dataPoint":{"name":"NESTED_DATA_NAME_3","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.80833333333333},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.53966739654541}]},"NESTED_DATA_NAME_5":{"dataPoint":{"name":"NESTED_DATA_NAME_5","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.32150091171265},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.27400076548258}]},"NESTED_DATA_NAME_6":{"dataPoint":{"name":"NESTED_DATA_NAME_6","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"Off"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"Off"}]},"NESTED_DATA_NAME_7":{"dataPoint":{"name":"NESTED_DATA_NAME_7","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.33700085957845},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.25500073750814}]}}},{"elementName":"elementName24","elementIdentifier":"c020f079-de8b-4a0a-8ff6-4fe9c02d0107","elementDefinitionIdentifier":2,"metaData":{},"data":{"NESTED_DATA_NAME_1":{"dataPoint":{"name":"NESTED_DATA_NAME_1","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.860000686645506},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.12319945017497}]},"NESTED_DATA_NAME_2":{"dataPoint":{"name":"NESTED_DATA_NAME_2","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"ON"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"ON"}]},"NESTED_DATA_NAME_3":{"dataPoint":{"name":"NESTED_DATA_NAME_3","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.19900135040283},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.60400006612142}]},"NESTED_DATA_NAME_5":{"dataPoint":{"name":"NESTED_DATA_NAME_5","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.277167638142906},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.596167176564535}]},"NESTED_DATA_NAME_6":{"dataPoint":{"name":"NESTED_DATA_NAME_6","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"Off"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"Off"}]},"NESTED_DATA_NAME_7":{"dataPoint":{"name":"NESTED_DATA_NAME_7","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.306667474110924},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.58350050608317}]}}},{"elementName":"elementName25","elementIdentifier":"cdea6474-c65b-4720-bd2d-6ed89df26b93","elementDefinitionIdentifier":2,"metaData":{},"data":{"NESTED_DATA_NAME_1":{"dataPoint":{"name":"NESTED_DATA_NAME_1","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.860000686645506},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.12319945017497}]},"NESTED_DATA_NAME_2":{"dataPoint":{"name":"NESTED_DATA_NAME_2","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"ON"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"ON"}]},"NESTED_DATA_NAME_3":{"dataPoint":{"name":"NESTED_DATA_NAME_3","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.62166742960612},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.86066596984863}]},"NESTED_DATA_NAME_5":{"dataPoint":{"name":"NESTED_DATA_NAME_5","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.71683401743571},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.12333412806193}]},"NESTED_DATA_NAME_6":{"dataPoint":{"name":"NESTED_DATA_NAME_6","friendlyName":"friendlyName","keyName":"keyName","dataType":"String","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":"Off"},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":"Off"}]},"NESTED_DATA_NAME_7":{"dataPoint":{"name":"NESTED_DATA_NAME_7","friendlyName":"friendlyName","keyName":"keyName","dataType":"Decimal","sequence":null},"values":[{"intervalLocal":"2025-07-10T04:05:00-05:00","value":0.75300062179566},{"intervalLocal":"2025-07-10T04:10:00-05:00","value":0.0943341255188}]}}}]}'
rdd = spark.sparkContext.parallelize(json_text.split(', '))

df = spark.read.json(rdd)

df.printSchema()

 

0 Kudos