About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Home
Get Help
Code & Webhooks

Code & Webhooks

Ask questions and find answers related to Zapier's Code and Webhooks apps.

2,126 Topics
7,279 Replies

When you subscribe we will email you when there is a new topic in this category

Video

Code steps 101 (session from ZapConnect 2021)

2
1

2126 Topics

Recently active

Most replies Most views Newest first

Darin ZenventoryNew

asked in Code & Webhooks

Can Zapier grab shipment updates via tracking numbers?

Here is my dream scenario and not quite sure if it is available.Our software populates a google sheet with order details. One of these details would be a shipment tracking number. I want to be able to check that tracking either periodically, or subscribe to a webhook to then update my google sheet with the shipment status. At the very least a delivered date.Does anyone know if this setup is possible?

timleroyBeginner

asked in Code & Webhooks

Unable to run a Javascript code with correct data

I created a long zap with various steps. Some of them include some Javascript “Code by Zapier” steps.The inputData is the result of a Snowflake SQL query, so sometimes it returned 0 result.Because of that, as I was iterating the results, it was throwing the dreaded “TypeError: Cannot read property 'trim' of undefined”.I wanted to fix that by creating a logic to check the data and stop the script. See below:// Catch empty data and return empty valueif ( !inputData || !inputData.dates || !inputData.integrations || !inputData.counts) { console.error( "Missing or empty inputData properties. Cannot create the chart." ); output = { url: "Not enough data" }; return output;}(note that I need to return something or the step fails)Now the strangest thing happened:The test of the zap shows no issue if there’s correct inputData or not In production, when testing the complete zap, there’s still the “TypeError: Cannot read property 'trim' of undefined” with correct data As a consequence,

Thales CampolimNew

asked in Code & Webhooks

Replace null values with 0 in a array

I am collecting conversion data from facebook’s API, and grouping it by hour.As there isnt conversions for every single hour, it’s bringing a whole array of values comma separated, so as I want to put it in a google sheets, I need to input a value 0 for the hours I dont have any conversions. I tried to use the code this article suggest , however, I am no getting the same result as my output just remove the null values instead of replace it with 0.Input: Output:

asked in Code & Webhooks

Zap to Slack integration is showing HTML tags

We are currently experiencing an issue with our Zap to Slack integration, and we need your assistance to resolve it.The problem we're encountering is that when we use the Zap to Slack integration to post content, it displays HTML tags instead of rendering the content correctly. This is affecting our ability to share information effectively within our Slack channels.Ideally, we would like our Slack posts to render correctly with images and formatted text, as they do when posted directly within Slack. However, currently, we are seeing raw HTML code in the posts.To provide you with more context, here are some additional details:The Zap is set up to trigger when specific events occur in the Beamer application. The content we are sending to Slack includes text, images, videos and links. We expect the content to display as it does when posted manually in Slack.We are unsure why this issue is occurring and would appreciate your guidance on how to resolve it. We want to ensure that our Zap to

lcallanderBeginner

asked in Code & Webhooks

Send Facebook Lead to Leap JobProgress API via Webhook Post

After reading this community question, may you help me with this API post?Step TWO of my Zap: ProTech FB > Em > WhatConverts > BQ5Contains a Webhook with the token, headers and a couple sample data fields for testing.Getting a 412 error when I test the step, which may be related to the headers or authorization.Public API documentation is located here:https://docs.api.jobprogress.com/I’m using the POST - Create Prospect example. Here is how my webhook is created so far:URL: https://api.jobprogress.com/api/v3/prospectsPayload Type: jsonData: first_name = Donald last_name = Duck email = dduck1925@toon.inWrap request in Array: NoFile (none)Unflatten (default yes)Basic Auth = (actual username)|(actual password) <<=== with user/pass get 401 error; without get 412 errorHeaders: Content Type = aapplication/x-www-form-urlencoded Authorization = Bearer (copy/paste token) ~~ Looking forward to your feedback!

Mitchell ZezimaBeginner

asked in Code & Webhooks

Zap is running twice (Duplicate trigger)

Hello, I am trying to follow this article: I am trying to get this to work by following the code step described in the above post, I feel like I have it set up correctly but its still triggering twice. Heres some screenshots of how I have the Zap set up and the Zap runs history. Have I done something wrong? Regards

Andres from IABeginner

asked in Code & Webhooks

Failed to create a request in Webhooks by Zapier: {+1XXXXXXXXXX} is not a valid phone number.

Hello!I am currently trying to link a client’s RingCentral to Gorgias using Webhooks by Zapier. After troubleshooting some early issues, this one has me stumped:Failed to create a request in Webhooks by Zapier{+1XXXXXXXXXX} is not a valid phone number. (HTTP Status Code: 400)At first I was trying to create a Zap for pulling in “Call Ended” tickets and ran into the issue with the sample numbers Zapier autofilled, so I switched to pulling in “New Voicemail”. I called and left a voicemail, updated data pulled in and now I still get the above error. Any insight would be greatly appreciated! Thank you!For reference, here is the Gorgias article on how to create the Zaps.

TenerifekiwiBeginner

posted in Code & Webhooks

Integration with Get Your Guide

Has anyone done an integration your the travel booking platform “Get Your Guide”?They have an API so it looks like it should be possible.

Cronfree Time Scheduler

posted in Code & Webhooks

Run a Zap every 2 Weeks

Hello Cronfree is able to solve a lot of these Zap mental gymnastics. Shoutout to @Wemakefuture for an amazing big brain post and identifying an obvious problem. https://zapier.com/apps/cronfree-time-scheduler/integrations To trigger every 2 weeks: Hey zapier folk,I had the problem that for a customer a Zap has to be executed every two weeks. I would like to present my solution to you and I'am open to alternative solutions or issues I haven't considered. First I used the trigger "Schedule by Zapier" and selected "Every Week" as the event.In a code block I determine the weeks between the current day and the beginning of time (1970 😀). After that I determine with the modulo operation whether the week is even (0) or odd (1). import datetimedate_delta = datetime.date.today() - datetime.date.fromtimestamp(0)return {"continue" : int(date_delta.days/7)%2}Then I check with a filter if the Zap should be continued in even (0) or odd (1) weeks. I hope the description is sufficient.

Cronfree Time Scheduler

posted in Code & Webhooks

Schedule Multiple Triggers in One Zap

Hello world, Problem: I want to trigger something on Mon, Wed and Fri at 1:23am. I’d have to create three separate Zaps. Solution: This lead us to create Cronfree Time Scheduler. One Zap to manage multiple scheduling triggers. Try it out for free! CheersCronfree Time Scheduler Team

asked in Code & Webhooks

Missing data after status response 200 in Code by Zapier

Hello everyone, I’m having an error everytime I’ve run a custom code into Code by Zapier. The main idea is to have a personalized “Welcome” greetings with a custom related form “Link” embbeded into this welcome text in order to be sent to the Customer. The issue shows up when I’m requesting through Airtable Web API the record with the “Link” related. The response status request is 200 which is OK. Also in Visual Studio Code the answer and the data is OK too.BUT when I run the code into Code by Zapier, the mentioned “Link” is missing.Does anyone have experienced something like this?import requestsimport jsoninput_data = { 'api_key':'', 'base_form':'theBaseWithTheTable', 'program':'theProgramName', 'client_name':'Customer', 'table_form':'theTableWithTheLink'}API_KEY = input_data['api_key']base_id = ''table_id = ''client_name = input_data['client_name']link = ''url = f'https://api.airtable.com/v0/meta/bases'headers = { 'Authorization': f'Bearer {API_KEY}', 'Content-Ty

asked in Code & Webhooks

Problem with sending dynamic data

We are an E-commerce SaaS provider and we would like to send buyer data to Zapier after a successful order from customers. This works fine so far in the developer environment.But what we have problems with is dynamic data. The client has the possibility to create his own fields, e.g. "T-Shirt size" or "Car license plate number". For example, we send Zapier the following object:{ "buyer": { "firstName": "Max", "lastName": "Mustermann" }, "dynamicData": { "T-Shirt-Size": "M", "Car plate": "B-DE-1234" }}How can I now use this freely defined object array in Zapier and, for example, in a simple case, have Google Sheet create a new row as the target? // edit: To make it easier, we can also format the json data something like..but is that better? the problem will still exist.{ "buyer": { "firstName": "Max", "lastName": "Mustermann" }, "dynamicData": [ { "key": "T-Shirt-Size", "value": "M" }, { "key": "Car plate", "value": "B-DE-1234" },

samforwardBeginner

asked in Code & Webhooks

ChatGPT error: JSON.parse is not iterable cannot read property Symbol(Symbol.iterator))

I’ve created a Zap that takes forwarded emails, runs them through the Chat GPT API for parsing into specific fields, and add these to a Google sheet table. I’m using Email by Zapier as the first step, and emails are manually forwarded to the email address. The email body is then passed to Chat GPT, and the answer is then passed on to Google Sheets.So far so good, it works successfully with emails forwarded manually. I’d like to automatically forward emails that arrive and are are tagged with a specific tag in Helpscout to the Zapier email address, which as far as I can see can be done 2 ways:Set up a workflow in Helpscout, where when a tag is added, an email forward task is automatically completed. Add Helpscout plugin to the start of the Zap, and when the tag is added then the ‘Conversation’ is forwarded.I tried the first option, the email successfully reaches the Zapier email, but fails at the Chat GPT step with the following error. I can’t find any difference between emails manuall

Mitchell ZezimaBeginner

asked in Code & Webhooks

Xero New Bill Trigger - Intermittent Fault

Hello, We have a Zap set up where if a new bill is approved into Xero, it will trigger a Zap, filter the results depending on account code, then create a spreadsheet row. For the most part this trigger works fine, however some data is not being pulled through despite meeting the trigger & filter requirements. As you can see from the screenshot below, the bill was created 18:49 September 4th. I have attached a screenshot of all bills triggered on that day. None of the Zaps are for the Xero bill in question. Thank you

CaseyABeginner

asked in Code & Webhooks

How do I extract specific data from QuickBooks Online reports to update a custom field in Pipedrive?

I have ongoing costs that I track in QBO, they are a sub account of “Other current assets” where I spend money on a project, and then recoup those costs at the end. I have a custom report that tracks these expenses and splits it out per client. I want to be able to pull that data from that report and put it into my CRM (pipedrive) in a custom field. I cannot, for the life of me, figure out how to conduct an API call in Quickbooks to get this data out. How do I call that data out?

blueguyBeginner

asked in Code & Webhooks

IF/ Else Statement in JavaScript

I am getting comfortable with IF/ Then Statements in my ZAPS but I an trying to do this IF/ ELSE statement and I cannot seem to get it to work.Verbally my statement goes like this: “If UDS is an empty cell, then the value to output is 99999 otherwise output 80307”Code wise it looks like this:let UDS = inputData.UDS; let EM = ""; // sets a blank valueif (UDS=" ") {EM = "99999";} else {EM = "80307";}output = [{UDS, EM}]; For some reason, I cannot get the else part of this code to output the correct result. The issue is this: when attempting to identify an empty cell (i.e., no data), the if / then statement yields an error when using spreadsheet style formulas so I thought I would use the IF/ Else statement to get around this issue by creating an input when the correct value does not exist (so the ZAP keeps running)Help please!! I have diligently read all of the support materials in this Community multiple times!!Thanks!! gml

PentaneonBeginner

asked in Code & Webhooks

Zap Auto Deactivation Problem with Webhook

My Zap, configured to add tags to orders to Shopify using a Webhook, works flawlessly during testing, successfully tagging orders in Shopify. However, when I activate it for real use, it mysteriously turns itself off. Seeking insights and solutions from the Zapier community to keep it running smoothly!

kacalicaBeginner

asked in Code & Webhooks

Notion App Extension can't escape quotes

I am trying to inject changes to my database item. I need to add some JSON to the properties. However the quotations keep getting turned into char code. Even when I esccape. What’s the strategy here in Zapier inputs to escape quotations?

asked in Code & Webhooks

Update row in postgres with JSONB data

We have a postgres table with a JSONB column we’d like to update. We’re using ‘Update row in PostgreSQL”, however, when we specify a value, such as:`{“key”: “Value”}` ..it inputs it into our db with escape characters that render the JSON invalid. We have also tried single quotes and other formatting, but are unable to find a consistent format that works. How can we format a jsonb value?

asked in Code & Webhooks

Creating a split transaction in YNAB (You Need a Budget)

Goal – My goal is to create a zap which streamlines the process of entering transactions into both YNAB and Splitwise, whilst traveling with friends.Current state – I have successfully configured a zap which, upon creation of a new transaction in Splitwise, creates an almost correct equivalent transaction in YNAB.Desired state – I want my new transaction in YNAB to be a split transaction, in order to follow this guidance on using YNAB and Splitwise together. Looking at the YNAB API docs, I see this is possible to implement as an array of `subtransactions`.However I don’t see this functionality exposed in the Zapier visual editor. Is this something that is possible, and/or on your radar?

asked in Code & Webhooks

How do I create a personalization tool to scrape LinkedIn and website data to generate personalized introductions?

I would like to create a personalisation tool using Zapier or as close to 100% automated as possible. I will be getting the following information Full Name, Company Name, Company URL & personal LinkedIn URL.With this information I need to scrape their LinkedIn profile and get insights into the prospect's recent professional interests or achievements, and also extract significant endorsements or skills from their profile.I will also need to scrape their website and extract mission or vision statement, if available. Scan for recent news or blog posts about major achievements or initiatives. Identify any awards or recognitions the company has received recently.With the above information I will use ChatGPT to craft a 1-2 sentence introduction that includes a compliment based on the scraped info.Then with the processed data as context, instruct OpenAI's GPT-4 to generate a personalised introduction that addresses the prospect and highlights positive aspects from the extracted data.With

Troy TessaloneZapier Expert

asked in Code & Webhooks

Zapier API: Connect Apps and Automate Your Work

Zapier API Documentationhttps://docs.api.zapier.com

asked in Code & Webhooks

How to distribute leads to clients based on state/region?

I am using Facebook primarily to generate leads however would like to start doing so through my websites. The issue I have is if a lead comes in from region 1, this needs to go client A, B & C. However is the lead comes in from region 2, this lead would need to go to client D, E & F.So the lead needs to be sorted and distributed based on the region, which then emails the correct clients.My question is, how to sort & distribute leads to clients based on state/region?My method through facebook involves using a BCC and storing the clients details in there so when the form (which is region specific) is propagated, then the lead is automatically received by those clients.I would like to replicate something similar through the website without having to resort to creating a separate form for every single region which would be a nightmare.Ideally I would like to achieve this without having to resort to data dumping into a google sheet and then using zapier to read the sheet and the

asked in Code & Webhooks

Dynamic handling of API keys to apps

I have a zap which makes use of ChatGPT app. I have a requirement to utilize the API key sent into the zap’s trigger step to connect using a provided OpenAI account connection for the steps. Is there any way to utilize the integrated ChatGPT app in Zapier with a dynamically provided API key, or would I need to convert all the steps using that app to instead use a Code app and handle the API requests with custom code?

asked in Code & Webhooks

Error 403 with webhooks api get request

Hi, I have very little programming knowledge and I’m trying to set up API calls with Zapier to get links from Reddit posts scheduled with Postpone.app to no avail, I don’t understand why this code isn’t working after hours switching things around, any help would be amazing.The documentation is on: https://help.postpone.app/en/api-docs/postpone-api and I’ve tested out the code itself on: https://api.postpone.app/gql. and it seems to work but on Zapier I’m getting this message: Failed to create a request in Webhooks by Zapier ERROR: The request could not be satisfied (HTTP Status Code: 403)I’ve screenshotted the code below, the text version is: query submissions( $limit: Int = 1 ) { submissions( limit: $limit ) { objects { result { url } } } }

1
...
17
18
19
20
21
22
23
...
86

Page 20 / 86

Powered by Gainsight

Terms & Conditions

Sign up

Already have an account? Login

Use your Zapier credentials

Log in with Zapier

Log in to the Community

Use your Zapier credentials

Log in with Zapier

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK

Pricing
Help
Developer Platform
Press
Jobs
Zapier for Companies
Templates

Follow us

Zapier

© 2024 Zapier Inc.

Legal
Privacy