Skip to main content

Hey everyone,

I would like to share a custom Zapier integration I built to solve a few problems. The integration provides the following action steps. I hope you find it helpful. :)

---

Run JavaScript Code: This is kind of a clone of the regular Code Step. Nothing fancy, it just comes with some useful tools available in the global scope. It also supports modern JavaScript async/await.

The global scope includes the following utilities:

  • moment: The well-known moment.js library that helps when dealing with date/time.
  • _: Lodash library that makes it easier to work with objects and arrays.
  • JSON: this replaces the built-in JSON.parse function with the more advanced JSON5 library.
  • toCSV: A function that converts an object to CSV.

 

---

Export to CSV: This action makes it easy to convert JSON data or line items to a CSV string or file.

 

---

If you’re interested in trying it, here’s the invite link: https://zapier.com/developer/public-invite/112461/039174f595539444ce5c14e114c1dc1e/

 

Known issues:

  • The code field in Run JavaScript Code action doesn’t highlight code.

Feel free to report any other issues and let me know if you there’s any other library that you wish you could use in a Code Step.

@ikbelkirasan 

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


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.


@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!


@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  Awesome!

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


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)


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?


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.


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


@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.


Hi there.  

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

Thanks buddy!


Thank you @Liz_Roberts  :D


Thank you @nicksimard ! :D


Thanks @AndrewJDavison_Luhhu ! :D