The JSON parse tool structures JavaScript Object Notation text into a table made up of its key pair values. So it will essentially take a JSON object, like we have in our first picture pane here and structure it into a table, like our third picture pane. The key pair values are the JSON name and JSON value string records in the third picture pane. Let's start a new workflow. So we can pass a JSON object, we'll go to the Insert tab. And instead of using the input data tool, like we normally use, we'll go for text input this time and drag that into our workflow.
We'll also go to our course files and open up the JSON parse file, copy the contents in there and paste them into our text input. Once we've done that, we'll Go to the developer tab, which is at the far right here and select the JSON pars tool here. If you're unable to see it in your version of ultrix, you can go to the Add remove tools icon here, scroll to the bottom, go to developer, and make sure you've got Jason paths ticked. We'll drag it into our workflow. And in the configuration pane on the left, we have the option to select which column from our input data we want to structure. Because we only have one field in our input data, it's going to be field one.
To the right of it, we have the option to include in output which also includes the field name chunk of text in our output, but we don't want that in this scenario. And finally, we have the option to output values into a single string field, which means it will only The JSON attribute name and value, or we can output it into data type specific fields, which will show us the attribute name value, and whether or not it's an int, float or Boolean. We'll add a browse tool to the end of our workflow with Ctrl Shift B and run it with Ctrl R. And with single field selected, our data has been output into two columns.