Parse JSON

Convert nested JSON to new columns

The Parse JSON Action

JSON is short for JavaScript Object Notation. It is a method for storing data. Sometimes you might come across some of your data with JSON columns. The Parse JSON Action helps you convert JSON to regular row/column-based data sets. See an example in the video below.

JSON data looks something like this:

{"name":"John", "age":28}

Above it consist of two column - name and age - and only a single observation - John at age 28.