Unflatten from JSON and variant to data

[ThomasGutzler]

Hi,

I'm receiving a JSON string from a web API, which I'm trying to convert into a cluster (of clusters) but I've run into some problems:

1) Sometimes the order of the elements in the JSON string changes, which causes my conversion to fail.

2) Sometimes the "object" returned via JSON is null, which causes my conversion to fail if I use clusters within clusters. It works with variants in clusters but then I need to convert the all the variants manually

Is there any way to improve my code to fix those problems? The attached snippet is a simplified version. In my project, the first JSON string to data is done in a library. The second conversion from "result" variant to data is done in my application. This makes a direct conversion from JSON string more difficult.

[JKSH]

35 minutes ago, ThomasGutzler said:

1) Sometimes the order of the elements in the JSON string changes, which causes my conversion to fail.

2) Sometimes the "object" returned via JSON is null, which causes my conversion to fail if I use clusters within clusters. It works with variants in clusters but then I need to convert the all the variants manually

To solve both issues, insert "Adapt to Type.vi" before "Variant to Data". However, your cluster element names are now case-sensitive. "TimeStamp" will not match "timeStamp" in the JSON string.

[smithd]

Drjdpowell's json library has functionality for breaking subclusters apart and all sorts of other useful ways of manipulating the json strings directly. If you can use 2017 its worth a look.

[ThomasGutzler]

1 hour ago, smithd said:

Drjdpowell's json library has functionality for breaking subclusters apart and all sorts of other useful ways of manipulating the json strings directly. If you can use 2017 its worth a look.

Unfortunately, I'm still stuck in 2016 land.

But JKSH's suggestion got me going. Thanks