Transform XML

With this node you can transform an XML file using XSLT or XQuery into another XML or JSON file.

It has the following configuration options:
  • XML Data: here you can specify the XML data. Select the pencil to open Expression Builder.Options:
    • XML data generated by a previous node.
    • XML in a string.
    • An URL reference to a XML file.
    Note: See also XML Data Type.
  • XML Data Type: here you can specify how the contents of the XML data parameter should be interpreted. Options:
    • Auto detect: if you select this option, the content of the XML data parameter will be detected automatically.
    • XML data: if you select this option, the content of the XML data parameter will be used as XML data.
    • XML string: if you select this option, the content of the XML data parameter will be used as an XML string.
    • URL reference: if you select this option, the content of the XML data parameter will be used as an URL reference.
  • Transformation file: here you can define the transformation file. This can either be an XSLT file or a XQuery file. You need to the format in Transformation Type.
  • Transformation Type: here you can specify the format of the transformation file. Options:
    • XSLT 1.0: xslt 1.0 with xpath 1.0
    • XSLT 2.0: xslt 2.0 with xpath 2.0
    • XSLT 3.0: xslt 3.0 with xpath 3.0
    • XQuery 1.0: xquery 1.0 with xpath 2.0
    • XQuery 3.0: xquery 3.0 with xpath 3.0
  • Output: here you can specify where to save the transformed 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.
  • Output Type: here you can define the output type should be XML or JSON.
  • 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.