Retrieving Data from JSON

[tomp93]

Hi

I need to retrieve data from JSON using unflatten from JSON sub vi.

My JSON is {"LogMsg":[{"PE":128,"UID":"WISE-4012_00D0C9E2F3B5","TIM":"1573536496","Record":[[0, 0, 7, 10],[0, 0,11, 0]]}]}

I need the value 7 from it.

I want a method without using any addons

[thols · Accepted solution]

How about:

[thols · Accepted solution]

I'm no power user of JSON, but if you really want to use the unflatten from JSON, you can do it like this:

I tried using "path" down to "record" but that doesn't work, not sure why, or how that path should be constructed.

[tomp93]

Thanks ... 🙂

It Worked. Now Iwant solution to get that timestamp "1573536496" from that.

Could you please suggest similar for that also.

[cordm · Accepted solution]

Here is another one if you really only want 7:

[thols]

Thanks cordm, thats where I was failing. Of course it should be like that.

[thols]

---

@tomp93 wrote:

Thanks ... 🙂

It Worked. Now Iwant solution to get that timestamp "1573536496" from that.

Could you please suggest similar for that also.

---

I suggest you go to https://regex101.com and test the regex for that by some trial end error. Thats what I always do.

[wiebe@CARYA]

---

@tomp93 wrote:

Thanks ... 🙂

It Worked. Now Iwant solution to get that timestamp "1573536496" from that.

Could you please suggest similar for that also.

---

What date should 1573536496 be? There are a few different standards...

Anyway, unbundle the string, and parse the string. It's not a JSON problem anymore.

[tomp93]

Thank you all for the solutions. All worked. 🙂