Skip to main content Skip to complementary content

Setting up the tWriteJSONField

Procedure

  1. Click tWriteJSONField to display its Basic settings view.
  2. Click Configure JSON Tree to open the XML tree editor.
    The schema of tFixedFlowInput appears in the Linker source panel.
  3. In the Linker target panel, click the default rootTag and type in staff, which is the root node of the JSON field to be generated.
  4. Right-click staff and select Add Sub-element from the context menu.
  5. In the pop-up box, enter the sub-node name, namely firstname.
    Repeat the steps to add two more sub-nodes, namely lastname and dept.
  6. Right-click firstname and select Set As Loop Element from the context menu.
  7. Drop firstname from the Linker source panel to its counterpart in the Linker target panel.
    In the pop-up dialog box, select Add linker to target node.
    Click OK to close the dialog box.
  8. Repeat the steps to link the two other items.
    Click OK to close the XML tree editor.
  9. Click Edit schema to open the schema editor.
  10. Click the [+] button in the right panel to add one column, namely staff, which will hold the JSON data generated.
    Click OK to close the editor.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here