Shapes

Convert and format values

Convert JSON

Converts between records and JSON, CSV or XML text.

Nodes › DataOpen in Neblex
Good for
Text formats inside fields
Role
Works on the records in a flow
Find it in
Nodes › Data

When to use it

  • An API returns JSON or XML as text inside a field.
  • A destination expects CSV or XML text.

Reach for something else when

Read fileWhen you are reading a whole file, especially a large one.

Example

Parse an XML order that arrives as text in a webhook body into a record you can map.

  1. Webhook
  2. Convert JSON
  3. Map fields

How it works

Settings
Direction: Value -> JSON string [default], JSON string -> value, Value -> CSV, CSV -> records, Value -> XML, XML -> records; Field; Into field [json].
Limits
CSV input up to 4 MB, 1,024 columns, 100,000 rows; XML input up to 1 MB. For larger files use Read file.
More in the guide

Add it to a flow

  1. Open the flow from Build › Workflows.
  2. Open Nodes and find Convert JSON under Data, 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 Convert and format values

Hash valueCreates a SHA-256 or SHA-512 fingerprint of a field, or a signature with your key.Nodes › DataFormat dateReformats a date or time into the pattern a system expects.Nodes › DataCompress (zip)Compresses a text field with gzip and encodes it for transport.Nodes › DataScrape websiteExtracts values from HTML with CSS selectors.Nodes › DataRender markdownTurns Markdown into safe HTML.Nodes › Data