Skip to main content
All CollectionsTemplatesBasic
Convert Newline Delimited JSON to Standard JSON - Workflow Template
Convert Newline Delimited JSON to Standard JSON - Workflow Template

Converts Newline Delimited JSON formatted data into standard JSON format.

Updated over 6 months ago

This workflow template serves as a critical utility for data transformation, focused on converting Newline Delimited JSON (NDJSON) format into standard JSON. It decodes base64 payload, replaces newlines with commas, trims any trailing comma, and formats the data into a JSON structure. Ideal for businesses dealing with NDJSON data that requires processing or analytics in standard JSON format.

Use Cases

Function

Workflow Breakdown

  1. Decodes the incoming base64 payload

  2. Replaces newline entries with a comma

  3. Removes the trailing comma at the end of the payload if required

  4. Converts the remaining JSON escaped data

Vendors

Utils

Workflow Output

Standard JSON formatted payload

Tips

Ensure that the data goes into the workflow as base64 encoded using the \"Encode base64\" step or \"b64enc\" sprig function

Did this answer your question?