# Extracting JSON data with a loop node

## Procedure

1. In Talend Studio, open the Job used in [Extracting JSON data from a file using JSONPath without setting a loop node](https://help.qlik.com/talend/en-US/components/8.0/json/tfileinputjson-tlogrow-extracting-json-data-from-file-using-jsonpath-without-setting-loop-node-standard-component-this) to display it in the design workspace.
2. Double-click the tFileInputJSON component to open its Basic settings view.

   ![](https://help.qlik.com/talend/en-US/components/8.0/Resources/images/components-tfileinputjson_s2_1.png)
3. Select JsonPath from the Read By drop-down list.
4. In the Loop Json query field, enter the JSONPath query expression between double quotation marks to specify the node on which the loop is based. In this example, it is *"$.store.goods.book[\*]"*.
5. Click the [...] button next to Edit schema to open the schema editor.

   ![](https://help.qlik.com/talend/en-US/components/8.0/Resources/images/components-tfileinputjson_s2_2.png)

   Select the five columns added previously and click the x button to remove all of them.

   Click the [+] button to add four columns, *book\_title*, *book\_category*, and *book\_author* of String type, and *book\_price* of Double type.

   Click OK to close the schema editor. In the pop-up dialog box, click Yes to propagate the schema to the subsequent component.
6. In the Json query fields of the Mapping table, enter the JSONPath query expressions between double quotation marks to specify the nodes that hold the desired data. In this example, enter the JSONPath query expressions *"title"*, *"category"*, *"author"*, and *"price"* relative to the four child nodes of the *book* node respectively.
7. Press Ctrl+S to save the Job.
8. Press F6 to execute the Job.

   ![](https://help.qlik.com/talend/en-US/components/8.0/Resources/images/components-tfileinputjson_s2_3.png)

   As shown above, the book information is extracted from the source JSON data and displayed in a flat table on the console.