CSV to JSON

Description

This action converts your CSV into an JSON format.

The delimiters of the CSV input are recognized automatically. Possible delimiters:

Input Argument	Type	Description	Required?	Advanced Option?	Default
`CSV`	`String` in `CSV` format	The `CSV` code or a file containing `CSV`	✔️	✔️	-
`Data Includes Header?`	`Boolean`	`Yes`: The first line of the `CSV` input will be formatted as headers in the Excel table. `No`: Default names will be included as headers in the Excel table.	✔️	✔️	`Yes`

Response	Type	Description
`JSON`	`String`	The `JSON` response from the `CSV` formatted as a `String`

We use a simple CSV with four pets.

Simple CSV with semicolon delimiter

Pet; Identifier;First name;Last name
Dog;1000;Eats;A Lot
Cat;1001;Likes;To Scratch
Cat;1002;Furry;Kitty
Duck;1003;Dagobert;Swimmy

We have not changed the advanced options.

We once again use a simple JSON with four pets.

Simple CSV with Pipe delimiter

Dog|1000|Eats|A Lot
Cat|1001|Likes|To Scratch
Cat|1002|Furry|Kitty
Duck|1003|Dagobert|Swimmy

We have directly entered the CSV into our action. We have not changed in the Advanced Options that there is no header included.

⚠️

If you experienced other limitations please get in touch with us!

All cells in the Excel File are automatically formatted as text columns. There will be an option inlcuded in the next version.