LabVIEW
JSON Parser File Path Not Found
Solved!
So I have a JSON file from which I'm trying to extract data, but I cannot get the correct file path. I'm using Unflatten from JSON
The JSON string looks something like this:
{"latitude":32.78,"longitude":-96.81,"timezone":"America/Chicago","offset":-5,
"currently":{"time":1478744444, "summary":"Mostly cloudy"},
"minutely":{},
"hourly":{"summary":"Rain",
"icon":"rain",
"data":[{"time":1478744555,"summary":"Cloudy","temperature":60.55,"windSpeed":14.5}
{"time":1478745555,"summary":"Mildly cloudy","temperature":60.00,"windSpeed":13.5}]},
"daily":{},
"flags":{}
}There is much more in the actual string, but the important part is the hourly data, which is divided into 48 different pieces for 48 hours. I know that I can get the "time" and "summary" from the "currently" portion, but whenever I try to get something from "hourly" or "hourly/data" I get this error: "LabVIEW: The path cannot be found in the JSON string."
I can get the "currently" info like this: 
But trying to do the same thing doesn't work with the array of objects:
I've also tried making the type and defaults the same as what's in the "data" array elements, but the error is still the same.
So is there a way to separate each of the time slices in "data", or to extract everything that's in the "hourly" block and then use the Unflatten JSON function on that again?
You need to include the array index in your path. The square brackets in the json data indicate an array so you need to do something like the following:
For some reason I'm getting a "LabVIEW: The JSON string is invalid. JSON strings must be encoded in UTF-8 and must conform to the JSON grammar." error but that might just be because of the copy+paste of the JSON string.
Oh...it's missing the comma between the array elements. Add a comma after the windSpeed":14.5} at the end of the 6th line.
In your second example, you should have made the cluster into an array of clusters containing 3 numeric elements - then that should have worked. It takes a bit of getting used to understanding how to convert JSON structures to LV Clusters.
