Parse JSON

<< Click to Display Table of Contents >>

Navigation:  Using StreamLab > StreamLab Guides Overview > Guide Commands > Parsers >

Parse JSON

Previous pageReturn to chapter overviewNext page

This parser assumes the input is a simple JSON object.

Properties: a comma-separated list of properties to extract from the JSON object

Prefix: used when constructing the column names.  

So if the input is a series of JSON objects like:

{"id":"50116195532", "reported_at":"2014-07-23T20:51:58.547", "lat":-33.530784606933594, "lon":150.87783813476562, "speed":0, "bearing":0, "driver_no":"160019", "prescribed":false, "highway":""}

If prefix is 'xyz_' and properties is 'id,lat,lon', you'll get 3 new columns, xyz_id, xyz_lat, and xyz_lon.