CSV to JSON

Convert CSV to JSON

Use it in a workflow

Add a step and choose the Data Converter connector.
Pick the CSV to JSON action (under helper).
Fill in the fields below, then reference the result from later steps as {{csvToJson.response.data}}.

contentstringrequired

The CSV to convert, e.g. {{downloadFile.response.data.content}}.

inputEncodingstring

Choose base64 for content from the FTP, SFTP or File connectors.

One oftextbase64Default "text"

csvDelimiterstring

The column separator.

Default ","

csvHasHeaderboolean

Use the first row as field names. When off, each row becomes a list of values.

Default true

inferTypesboolean

Read "12" as 12 and "true" as true. Values with leading zeros or 16+ digits stay text.

Default true

expandDotColumnsboolean

Turn columns like address.city or items.0.sku into nested data.

Default false

returnAsstring

value: data you can reference field by field. text: JSON text. base64: for uploading with FTP, SFTP or File.

One ofvaluetextbase64Default "value"

prettyboolean

Indent the output.

Default true

Convert CSV to JSON

json

{
  "content": "{{downloadFile.response.data.content}}",
  "inputEncoding": "base64"
}

Need more? See the Data Converter guide for connection setup and behaviour shared by every action.

Was this page helpful?