Update JSON

With this node you can create a JSON file or you can update a JSON file by updating nodes that are selected by a path.

It has the following configuration options:
  • JSON Data: here you can specify the JSON data. Select the pencil to open Expression Builder.Options:
    • JSON data generated by a previous node.
    • JSON from a variable.
    • A URL reference to a XML file.
    Note: See also JSON Data Type.
  • JSON Data Type: here you can specify how the contents of the JSON data parameter should be interpreted. Options:
    • Auto detect: if you select this option, the data type will be detected automatically.
    • JSON Data (output from other node): if you select this option, the JSON content will be interpreted as JSON data.
    • JSON Data (for example from a variable): if you select this option, the JSON content will be interpreted as JSON data.
    • URL reference: if you select this option, the JSON content will be interpreted as an URL reference.
  • Path: here you can define an array of elements to update. For each entry you need to define:
    • A path: here you can define a JSON path that selects an element in the JSON document. Select the pencil to open Expression Builder.
    • A value: here you can specify the value to set. Select the pencil to open Expression Builder.

    Select + to add more paths.

  • Output: here you can specify where to save the updated output. Options:
    • If you leave this field blank, the data will be sent to a container in the database and no physical file will be created.
    • If you enter a file name without an extension, an output file with the specified file name and the original extension will be written in the same folder as the input file.
    • If you define an absolute CLOUDFLOW URL (cloudflow://..., see Server URL for more information), containing a file name and an extension, a physical output file with the specified file name and the original extension will be written in the specified folder.
    • If you enter a relative path without a file name and extension, an output file with the original file name and extension will be written in a folder based on the original input folder.
    • If you enter a relative path containing a file name and extension, an output file with the specified file name and the original extension will be written in a folder based on the original input folder.
  • Overwrite existing file: if you select this checkbox, files that already exist will be overwritten. If you leave this checkbox unselected, existing files will not be overwritten and an error is displayed.