topic Re: Parsing JSON data in Discussions

Parsing JSON data

afterword — Mon, 09 Jul 2012 14:33:46 GMT

Does anyone know of an existing script or code snippets to get me started on parsing JSON data? I'm particularly interested in how to handle the process of reading each key:value hash and writing it to the JMP data table.

Here's a sample with a group ID number, followed by the timestamp:reading hashes.

{ "1":[[1341118805, 0.654], [1341205195, 0.654]] , "10037506":[[1341118820.000, 0.900], [1341118880.000, 0.000], ... }

Re: Parsing JSON data

afterword — Tue, 10 Jul 2012 01:31:07 GMT

Never mind - took care of it in Python.

I may work on an R implementation just for ease of passing values between JMP and the parser if the interface with Python proves to be too cumbersome.

Re: Parsing JSON data

pmroz — Tue, 10 Jul 2012 12:18:43 GMT

The JSON format looks like a list of lists. You could use the JSL WORDS function for parsing, and an associative array for storage.

Re: Parsing JSON data

afterword — Tue, 10 Jul 2012 13:41:26 GMT

Good eye! I'll see if there's a simple way of unpacking it in JSL. I wanted to avoid reinventing the wheel, but it might be a fun test of my JSL skills, and I'm sure there are others out there who need to parse JSON data.

Thanks for the suggestion!

Re: Parsing JSON data

XanGregg — Fri, 28 Oct 2016 13:09:47 GMT

I also had a need for getting JSON data into JMP and wrote some parsing functions, which I just uploaded to the File Exchange at JSON Parsing Functions.

(Trying for the record for oldest question answered.)