CSV to JSON Converter with Error Handling and Slack Notifications

Description

Who this template is for
This template is for developers or teams who need to convert CSV data into JSON format through an API endpoint, with support for both file uploads and raw CSV text input.

Use case
Converting CSV files or raw CSV text data into JSON format via a webhook endpoint, with error handling and notifications. This is particularly useful when you need to transform CSV data into JSON as part of a larger automation or integration process.

How this workflow works

Receives POST requests through a webhook endpoint at
/tool/csv-to-json
Uses a Switch node to handle different input types:
File uploads (binary data)
Plain text CSV data
JSON format data
Processes the CSV data:
For files: Uses the Extract From File node
For raw text: Converts the text to CSV using a custom Code node that handles both comma and semicolon delimiters
Aggregates the processed data and returns:
Success response (200): Converted JSON data
Error response (500): Error message with details
In case of errors, sends notifications to a Slack error channel with execution details and a link to debug

Set up steps

Configure the webhook endpoint by deploying the workflow
Set up Slack integration for error notifications:
Update the Slack channel ID (currently set to "C0832GBAEN4")
Configure OAuth2 authentication for Slack
Test the endpoint using either:
CURL for file uploads:

bash
Copy
curl -X POST "https://yoururl.com/webhook-test/tool/csv-to-json" \
-H "Content-Type: text/csv" \
--data-binary @path/to/your/file.csv


Or send raw CSV data as text/plain content type