Parse JSON
Convert nested JSON to new columns
Last updated
Convert nested JSON to new columns
Last updated
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.