Really cool stuff @ikbelkirasan!

Thanks @AndrewJDavison_Luhhu ! :D

This is awesome, @ikbelkirasan! Thanks for creating this and sharing with the Community!

Thank you @nicksimard ! :D

Amazing- thanks for sharing @ikbelkirasan !!

Thank you @Liz_Roberts  :D

Hi there.  

I tried the link, but I can’t find it after I get redirected.  Is this still available?

Thanks buddy!

@Jimwinner 

If you’re building a zap and you can’t find the app in the app selector dropdown, this is a known issue.

Refresh the page and the app should magically appear in the dropdown.

Is this safe to use. What happens when I accept the invite? 

Amazing stuff @ikbelkirasan 

Thanks @andywingrave :)

@CreekFire - Yes, it’s safe to use this integration. When you accept the invite, this integration will be added to your available integrations menu.

I have data that looks like this:

[{"Product":"8 \"","Quantity":"2","Flavour":"B Choc"},{"Product":"10\"","Quantity":"1","Flavour":"Lemon"},{"Product":"10\"","Quantity":"1","Flavour":"Vanilla"},{"Product":"12\"","Quantity":"2","Flavour":"Carrot"}]

It can be a variable size, this one happens to have 4 entries.

What I need is this:

Product: 8",10",10",12"

Quantity: 2,1,1,2

Flavour: B Choc,Lemon,Vanilla, Carrot

Can Export CSV do this?

It did this very well. I just need it the other way around.

It did this very well. I just need it the other way around.

 

@ikbelkirasan I second this… I’m looking for something to Convert CSV to JSON (need it to Execute JSON API Requests - Typically I can use Webhooks by zapier ‘Form’, but not when it’s a nested request)

Hi @chrisboat and @eden - I’m going to add a CSV to JSON feature in the next few days. 

@ikbelkirasan  Awesome!

I’m a bit of a newb - I’m wondering how it would work with Nested JSON to execute nested JSON requests

@eden - Could you show me an example CSV and the expected JSON output so I can be sure we’re on the same page? Thanks!

@ikbelkirasan  I’m trying to create multiple subtasks in Asana from a google sheet which will list the subtasks and submit them via an Asana Batch API Request 

Thanks!

Thanks for the great add-on!

Thanks for the effort!  Advanced Utilities is exciting to me because of the CSV functionality!  However, the invite link seems to be broken and although it shows up in Zapier, it still says Invite Only .  Any ideas?

Hi @gootecks@crosscounter.tv - Can you show me a screenshot of what you’re seeing? Advanced Utilities is currently a private app so you’ll need to open the invite link to have access to it. Once done, refresh the page and you’ll be able to select it in your zap. Make sure you don’t use it as the first step because it doesn’t have any triggers.

Hi @ikbelkirasan 

Thanks for this awesome add-on.

However, I’m getting an error when exporting to CSV File using a specific JSON input:

Got 400 - <?xml version="1.0" encoding="UTF-8"?><Error><Code>MalformedPOSTRequest</Code><Message>The body of your POST request is not well-formed multipart/form-data.</Message><RequestId>9A94538C0DA3B304</RequestId><HostId>7+t+SBjyWOQcFRbibJsu50paYNl6ajNu30KMcNquQ55VW+y9uVYewwcZLMC4Ckpyg1hNuEenym0=</HostId></Error>

My first suspicion was whether the JSON string was broken or had special characters, but I confirmed it’s valid and your add-on actually is able to generate a CSV string as output using that same JSON input. It’s only when I select the File output that I get the above error.

Another specific detail about this JSON payload is that it’s considerably bigger than the rest of the payloads I tried so far. If I generate a CSV string output and I save it as txt, the file is around 450KB.

Any help would be really appreciated.

Thanks again!

@ikbelkirasan 

Just found this!

Zapier needs more of these handy type of utilities as apps.

Thanks a bunch!

@ikbelkirasan 

Thought: Include the links to the reference articles for Moment.js, etc. as part of the Zap steps for easier access and reference.

Could you possibly provide a bit more guidance around the second step of converting to a CSV?

Sorry am very new to this so wondering where your line items have come from in the example and how the previous step fits into this one?

Thank you