Shapes

Files and EDI

Read file

Reads a CSV, JSON or text file carried on a record back into records.

Nodes › FilesOpen in Neblex
Good for
Processing incoming files
Role
Works on the records in a flow
Find it in
Nodes › Files

When to use it

  • Files arrive by file transfer, email or upload and their rows must be processed.
  • Files are large and should be processed without loading them at once.

Reach for something else when

Convert JSONWhen the content is a small piece of text inside a field.

Example

Download a price list from SFTP, read each row and update products in your shop.

  1. SFTP
  2. Read file
  3. Shopify

How it works

Settings
Format: CSV, JSON, Text; Field holding the file [contentBase64]; Content is: Plain text, Base64-encoded, or Detect.
Output
CSV: one record per row (values as text). JSON: a list becomes records, an object one record. Text: {text} per line. Large files stream through without being loaded at once.
Tip
To read a workbook made by Create Excel or a file from a file-transfer adapter, set Field holding the file to the field that carries the content (for Create Excel and Create file output that is contentBase64, the default).
More in the guide

Add it to a flow

  1. Open the flow from Build › Workflows.
  2. Open Nodes and find Read file under Files, or search for it. Click it or drag it onto the canvas.
  3. Drag from the previous step's output handle to its input, then open its settings with ✎ Edit.
  4. 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 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 › FilesAcknowledge EDIBuilds the functional acknowledgment (997, 999 or CONTRL) to send back to the partner.Nodes › Files