Extracting Firebase JSON Data Into a LabVIEW Table

[hwkim418]

I’m working on a LabVIEW application that retrieves measurement logs from Firebase. The Firebase API returns data as a nested JSON object where each entry has an auto-generated key. Each entry contains fields such as DATE, TIME, RESULT, TEMP, etc.

 

My goal is to parse this JSON into a 2D string array so that each Firebase record becomes one row in a LabVIEW table indicator.

I’m using the JSONtext library, but I’m having difficulty iterating through the nested keys and reliably building each row. My main issues so far:

1. The top-level object contains dynamic child names (-Obew83hY0lgN7ac7JK0, -ObewEcv8G0LtSRTx92G, etc.), so I cannot index them directly.

2. When I extract values using Get JSON Object Keys + Unflatten from JSON, the order of keys is not guaranteed, so my 2D table rows become misaligned.

3. Attempts to build rows inside a loop give me only a 1D array unless I carefully manage the auto-indexing tunnels.

Here is a minimal reproducible example of the Firebase response:Has anyone done this before or can provide an example of how to reliably transform Firebase JSON data into a LabVIEW table?

{"data": {
  "-Obew83hY0lgN7ac7JK0":{"DATE":"20251015","RESULT":"NG","TEMP":"20.2\\r\\n","TEMP_MAX":0,"TEMP_MIN":0,"TIME":"21:54:09 "},
  "-ObewEcv8G0LtSRTx92G":{"DATE":"20251015","RESULT":"OK","TEMP":"","TEMP_MAX":0,"TEMP_MIN":0,"TIME":"21:54:29 "},
  "-OeUEMm0u55cSRyy4OhH":{"DATE":"20251119","RESULT":"OK","TEMP":"","TEMP_MAX":0,"TEMP_MIN":0,"TIME":"21:09:57 "},
  "-OeUEO-CYBUUw_gtiab9":{"DATE":"20251119","RESULT":"OK","TEMP":"","TEMP_MAX":0,"TEMP_MIN":0,"TIME":"21:10:02 "}
}}