Shotgun automation with webhooks and Zapier

Last time, during test SG Webhooks + Zapier Webhooks + Send Email. Zapier native PUT doesn’t work. It means the pipeline can’t update any record in Shotgun. Today, we will see how Zapier code to update Shotgun records.

Pipeline

The pipeline is simple and short. Just for testing update an existing record

In this pipeline, we will update Task 5758 status to rdy
Pipeline

Notes:

  • Zapier supports node.js. We will see how to use node.js in Zapier to exchange data with Shotgun;
  • We will start with Step 2

Steps

  1. Define variables.



  2. Authentication




  3. Get task information.

Ignored. Please refer SG Webhooks + Zapier Webhooks + Send Email

  1. PUT to update task status




Result

We could use Zapier code + Zapier Webhooks to build a better pipeline. :slight_smile:

7 Likes

Awesome Post!

2 Likes

Hi! Awesome post!
Could one also use zapier to send back data?
For example after a changed status i want to trigger a event?

@RemcodeBont At step 5, you could see how to update task status.

Hi @jing.liu Thanks! I was to quick…
I’ve got another question. My end goal is that I can link the status of a version to it’s connected task. When I do a webhook trigger for a Shotgun_Version_Change I don’t see any info or line about it’s connected task. Is this even possible in this way or do I need to write more custom scripts to include this in the catch?

You need to do a a new query to gain the information you need and then the rest of your logic.
The Webhook Event only includes information on stuff related to the change of status for that version, through this metadata you can query the other data.