Double-click tExtractJSONFields to
display its Basic settings view.
Click Edit schema to open the schema
Click the [+] button in the right panel
to add three columns, namely firstname,
lastname and dept, which will hold the data of their counterpart nodes in
the JSON field staff.
Click OK to close the editor.
In the pop-up Propagate box, click
Yes to propagate the schema to the
- In the Loop XPath query field, enter "/staff", which is the root node of the JSON data.
- In the Mapping area, type in the node name of the JSON data under the XPath query part. The data of those nodes will be extracted and passed to their counterpart columns defined in the output schema.
- Specifically, define the XPath query "firstname" for the column firstname, "lastname" for the column lastname, and "" for the column dept. Note that "" is not a valid XPath query and will lead to execution errors.