Convert a CSV string to a JSON

How To
,
1

I am trying to convert a CSV file, converted as a string with toString, to a JSON format.

Using the JSON module that is supposed to “conver any object” in JSON… but the output is still a CSV format.

Any idea how I can achieved this ?

Ultimate goal is to make an automatic conversion of the google Spreadshit to a converted JSON file that will be re-uploaded on google Drive.

Capture d’écran 2024-04-23 à 12.01.19
Capture d’écran 2024-04-23 à 12.01.191657×493 37.1 KB

Capture d’écran 2024-04-23 à 12.01.32
Capture d’écran 2024-04-23 à 12.01.32444×558 35.9 KB

2

You have to process the data from the source file in Make and define the JSON structure you want as output.
You can use the “Parse CSV” module to read the data, use an “aggregator” to merge all lines to 1 output bundle and then assign the matching columns in your “Create JSON” output:

image
image1800×632 84.7 KB

2 Likes