Procedure - Cloud - 8.0

JSON
Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > File components (Integration) > JSON components
Data Quality and Preparation > Third-party systems > File components (Integration) > JSON components
Design and Development > Third-party systems > File components (Integration) > JSON components

Procedure

  1. In the Studio, open the Job used in Extracting JSON data from a file using JSONPath without setting a loop node to display it in the design workspace.
  2. Double-click the tFileInputJSON component to open its Basic settings view.
  3. Select Xpath from the Read By drop-down list.
  4. Click the [...] button next to Edit schema to open the schema editor.
    Select the five columns added previously and click the x button to remove all of them.
    Click the [+] button to add five columns, store_name, 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.
  5. In the Loop XPath query field, enter the XPath query expression between double quotation marks to specify the node on which the loop is based. In this example, it is "/store/goods/book".
  6. In the XPath query fields of the Mapping table, enter the XPath query expressions between double quotation marks to specify the nodes that hold the desired data.

    • For the column store_name, enter the XPath query "../../name" relative to the name node.

    • For the columns book_title, book_category, book_author, and book_price, enter the XPath 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.
    As shown above, the store name and the book information are extracted from the source JSON data and displayed in a flat table on the console.