[New Integration] Advanced Utilities


Userlevel 7
Badge +11

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.


29 replies

Userlevel 1
Badge

Awesome work @ikbelkirasan

Hi @ikbelkirasan!

Got a question, maybe you can help.

I use “Export to CSV” and “Input Type: Line Items”. I have around 50 line items and get a 400 error when testing with data that contains danish characters (æ,ø,å) in keys and values. Can you imagine a way I can get through with this? 

Weirdly, if I test with just a few line items containing danish characters, I get no errors. 

 

This tool is great, thank you so much!


Is it possible to rename the file being generated?  Currently it’s coming through as “output.csv” but ideally, I’d like this filename to be unique and contain the current day’s date.

Thanks for creating this brilliant tool @ikbelkirasan!

Reply