August 15, 2023

Setting up the tExtractJSONFields – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Setting up the tExtractJSONFields – Docs for ESB 6.x

Setting up the tExtractJSONFields

  1. Double-click tExtractJSONFields to
    display its Basic settings view.

    use_case_textractjsonfields_9.png

  2. Click Edit schema to open the schema
    editor.

    use_case_textractjsonfields_10.png

  3. 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.
  4. In the pop-up Propagate box, click
    Yes to propagate the schema to the
    subsequent components.

    use_case_textractjsonfields_13.png

  5. In the Loop XPath query field, enter
    “/staff”, which is the root node of
    the JSON data.
  6. 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.
  7. 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.
Document get from Talend https://help.talend.com
Thank you for watching.
Docs 6.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x