Convert a CSV string to a JSON

[Castets_Jean]

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.

[AutoPilots]

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: