Hey @sourabhrows ,

You should use Code by Zapier to create your own JSON. 

@jayeshkumarbhatia — thanks; tried that already. This is what is generated as output via code —

Here’s the actual code for reference too —

const csvData = inputData.data || '';

// Split the CSV data into rows
const rows = csvData.split('\r\n');

// Extract the headers from the first row
const headers = rows[0].split(',');

// Convert the remaining rows into an array of objects
const jsonOutput = rows.slice(1).map(row => {
  const values = row.split(',');
  return headers.reduce((acc, header, index) => {
    acc[header.trim()] = values[index] ? values[index].trim() : null; // Handle empty values
    return acc;
  }, {});
});

// Prepare the output as an object
output = jsonOutput;

Unfortunately, the output is still similar to before —

As in, I can’t get the raw JSON that I need.

I tried returning the output as text/string from the code too but that doesn’t work (unsure if that’s a bug?) as the expected output from code is either “an object or array of objects” as stated here.

Hi @sourabhrows 

If you are using a Code step you can output the raw JSON by converting it to a string.

// Convert JSON object to string
const jsonString = JSON.stringify(jsonData);

// Convert JSON object to string
const jsonString = JSON.stringify(jsonData);

@Troy Tessalone — this is the error that I get when doing so —

The official docs also indicate something similar.

Would you happen to have a different / working example? Or, maybe I’m missing something?

@sourabhrows 

Output needs to be like this:

@sourabhrows

Output needs to be like this:

 

@Troy Tessalone — this takes me back to my original issue 😅 as in, I’m able to have the output as a JSON form the Code part but unable to access the raw JSON in subsequent steps.

@sourabhrows

Are you outputting the JSON generated in the Code step as a string?

If you are using a Code step you can output the raw JSON by converting it to a string.

// Convert JSON object to string
const jsonString = JSON.stringify(jsonData);

Help: https://www.w3schools.com/js/js_json_stringify.asp