parse csv

This block is part of the files group and was last modified in core v11.5.13.

parse csv v10.3.11 Updated v11.5.13

Parse a CSV file into an array of objects.

In pins 5 + flow
  • flow
    flow
  • file required
    file

    File to parse as CSV.

  • separator
    value

    The separator used to split values on a row.

    Default ,

  • detect separator v11.5.13
    condition

    If set to true the action will try to detect the separator based on the first few lines. If it fails to do so it will fall back to the given or default separator

    Default false

  • Has headers
    condition

    Indicates if the CSV has headers or not, we will use the headers to create objects using these keys if true is given.

  • Custom headers
    array<value>

    Array of headers to be used in case has_headers is set to false.

Out pins 3 + flow
  • flow
    flow
  • array
    array
  • Headers
    array
  • error
    value

An uploaded file becomes rows: get takes the file from the form, parse CSV turns it into an array of objects, and filter by geo distance keeps only the rows whose location lies within their own radius of from city (here Breda). array length counts what survived.

Studio canvas example for the parse CSV block: upload, parse, filter by city.

Version history

Introduced in v10.3.11.

Last modified in v11.5.13.


Back to files Return to the main group to view all sub-groups Back to file parsing Return to the group to view all blocks within this group