Convert JSON to CSV with to CSV throwing an error

Looks like you’re using the standard built-in Code by Zapier for this, rather than the custom app that @ikbelkirasan was sharing in that tutorial.  Try switching the app to the one they linked to in the post.  It’s an unpublised app so you’ll need to click that link to get access to use it.

The example and screenshot you posted is of a Zap configured using a completely different app - the Code by Zapier official built-in app. You can tell by the name of it, and by the logo. 

You’ve selected this one: https://zapier.com/apps/code/integrations. You’ll need to delete that step from your Zap and paste your code into a new Zap step using this one as the selected app : https://zapier.com/developer/public-invite/112461/039174f595539444ce5c14e114c1dc1e/ Note that it’ll have a red atom-looking logo and be called “Advanced Utilities”, not “Code by Zapier”

Looks like “Run JavaScript Code” in @ikbelkirasan’s app is actually a Search type step - perhaps that’s why you’re not seeing it where you expect it.  You might reach out to him and see if he’ll help you get up and running.

If that fails to work, we’re happy to help you as you write your own custom Zapier integration to do exactly what you need it to. https://zapier.com/platform

@ikbelkirasan thanks that helped. 

@Zane for some reason it does not appear red atom-looking logo :( 

After running it, the output is a single line of CSV. It doesn’t match the nested-style output of the tutorial. 

@zap29550 - The output in the screenshot seems is not a single line, each item in the array is represented by a separate line. The whole text is stored in the csv text property.

@zap29550 - Yes, that’s possible. Try the code snippet below:

const lines = JSON.parse(inputData.lines);
const csv = await toCSV(lines);
const [, ...outputLines] = csv.split("\n");

return [
  {
    csv: outputLines,
  },
];

@zap29550 - You can only split by \n because that’s how the output is formatted. The output would be an array of strings.

Can you post a screenshot showing how you want to use the CSV lines in the subsequent step(s)? Thanks.

@zap29550 - If that’s the output you want then there’s no need to output CSV at all, you just need to parse the JSON and return it.

return [
  {
    lines: JSON.parse(inputData.lines),
  },
];

If this does the trick then you can just use the Code by Zapier app in this case.

@zap29550 What’s the next step? It needs to support line items.

@zap29550 - In that case, you’ll need to add an intermediary Looping by Zapier step to execute the Email by Zapier multiple times, once per item.

This forum is being a PITA in responding, so let’s try again.

Thank you @ikbelkirasan 

My goal is to have a single parameter that is formatted as I showed in my original post (can’t repost as it’ll be sent into a moderation black hole) without having to loop. I just want to send one e-mail (for example) with n blocks.