Files and EDI
XML
Queries, transforms, checks and builds XML with XPath, XSLT and XML Schema.
Nodes › FilesOpen in Neblex
- Good for
- Working with XML
- Role
- Works on the records in a flow
- Find it in
- Nodes › Files
When to use it
- A partner sends XML that must be checked against its schema.
- XSLT should turn one XML format into another.
- Values should be picked out with XPath.
Reach for something else when
Convert JSONWhen you only need to convert XML to records or back.Validate RecordsWhen records, not XML documents, need checking.
Example
Check each incoming order document against the partner's XML Schema and transform it with XSLT before importing it.
How it works
- Settings
- Action: XPath (an XPath 3.1 XPath expression), Transform (an XSLT 3.0 XSLT stylesheet), Check against XML Schema (an XML Schema) or Generate (from the record under the Root element); Field holding the XML; Namespaces (prefixes and their URIs); Write to.
- Output
- The XPath result, the transformed document, a validation result like Validate Records, or the generated XML. Documents never fetch external entities or files.
Add it to a flow
- Open the flow from Build › Workflows.
- Open Nodes and find XML under Files, or search for it. Click it or drag it onto the canvas.
- Drag from the previous step's output handle to its input, then open its settings with ✎ Edit.
- Run the flow and click the step to see the records it received and produced.
More in Files and EDI
Create ExcelBuilds an Excel workbook from all records, ready to attach or upload.Nodes › FilesCreate fileBuilds one CSV, JSON or text file from all records.Nodes › FilesRead fileReads a CSV, JSON or text file carried on a record back into records.Nodes › FilesRead EDIReads ANSI X12 or UN/EDIFACT documents into a structure you can map.Nodes › FilesBuild EDIBuilds EDI text from a structure, ready to send to a partner.Nodes › FilesValidate EDIChecks an EDI document's envelope and required business segments.Nodes › Files