[New Integration] Advanced Utilities


Userlevel 7
Badge +12

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.


37 replies

Userlevel 7
Badge +11

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

Userlevel 1

Thanks for creating this brilliant tool @ikbelkirasan!

Userlevel 1
Badge

Awesome work @ikbelkirasan

Userlevel 7
Badge +12

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

Userlevel 3
Badge +1

Thanks for the great add-on!

Userlevel 1

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?

Userlevel 1

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!

 

 

 

Userlevel 7
Badge +10

Really cool stuff @ikbelkirasan!

Userlevel 7
Badge +8

Amazing- thanks for sharing @ikbelkirasan !!:clap_tone3:

Userlevel 7
Badge +9

Amazing stuff @ikbelkirasan 

Userlevel 1

Hi @ikbelkirasan -  I accepted in the invite using the link (https://zapier.com/developer/public-invite/112461/039174f595539444ce5c14e114c1dc1e/), but I’m still not able to build the zap / access the “Advanced Utilities” options. Is there maybe a new(er) invite link I should be using? Thank you so much! 😀

Userlevel 1
Badge

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

 

Userlevel 7
Badge +14

@ikbelkirasan 

Just found this!

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

Thanks a bunch!

Hi @qbftech - The link still works. Maybe you need to refresh your zap editor page to access the integration. Make sure to select it in an action step.

I with the same Problem, maybe something is wrong

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

Userlevel 7
Badge +9

Hey there, I gave this a shot and the invite it still live, @Yago Almeida!

You’ll need to accept the invite and perhaps give it a minute and/or do a hard refresh of the editor. It’s worth mentioning this app will only be visible as an action step.

I hope some of this helps! 🧡

Userlevel 1

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)

Userlevel 7
Badge +14

@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, @ikbelkirasan!   I am new to Zapier and trying to convert a JSON file on my google drive to a CSV file and found your integration.  Yet when I select the file name [File: (exists but not shown)] for the ‘*JSON data’ field from the previous google drive step and test it, I keep getting:  JSON5: invalid character 'h' at 1:1.  Am I not able to pull a file in from my google drive or do I need a URL of where the file is?  Thanks for any guidance.

Userlevel 1

@ikbelkirasan  Awesome!

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

Userlevel 7
Badge +12

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

Userlevel 1

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

Userlevel 7
Badge +12

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.

Userlevel 7
Badge +12

Thanks @AndrewJDavison_Luhhu ! :D

Userlevel 7
Badge +12

Thank you @nicksimard ! :D

Reply