younifyd
Menu

JSON to CSV

Convert JSON to CSV

Use it in a workflow

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

Fields

contentstringrequired

The JSON to convert, as text or data from a previous step, e.g. {{getOrder.response.data}}.

inputEncodingstring

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

One oftextbase64Default "text"

recordPathstring

Where the list of rows is, e.g. Orders.Order or data.items. Can be left empty when the data is a list, or a list inside single wrappers like <Orders><Order>…; otherwise the whole object becomes one row.

csvDelimiterstring

The column separator.

Default ","

includeHeaderboolean

Start with a row of column names.

Default true

lineEndingstring

One oflfcrlfDefault "lf"

escapeFormulasboolean

Prefix cells starting with = + - or @ with ' so spreadsheets show them as text. Changes those values.

Default false

returnAsstring

text: the converted text. base64: for uploading with FTP, SFTP or File.

One oftextbase64Default "text"

Examples

JSON to CSV

Convert JSON to CSV

json
{
  "content": "{{getItems.response.data}}",
  "recordPath": "items"
}

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

Was this page helpful?