Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I’m using Formatter to convert CSV to JSON —

 

The output from the above image is the same as shown here.

As part of my next step, I have to push the raw JSON to my next app. I’m expecting the raw JSON to look something like so —

g
	{
		"Output Data H1": "A",
		"Output Data H2": 1,
		"Output Data H3": true
	},
	{
		"Output Data H1": "B",
		"Output Data H2": 2,
		"Output Data H3": false
	},
	{
		"Output Data H1": "C",
		"Output Data H2": 3,
		"Output Data H3": true
	}
]

However, I keep seeing this instead —

 

What should I do to access the raw JSON instead?

Hey @sourabhrows ,

 

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

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()] = valuesrindex] ? valuesiindex].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);

 

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);

 

@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

Terms & Conditions