Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

Code & Webhooks

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

  • 2,490 Topics
  • 8,354 Replies
Video

Code steps 101 (session from ZapConnect 2021)

  • 2
  • 1
2490 Topics
F
FrankPBeginner
asked in Code & Webhooks
Excel VBA to trigger an update to a specific monday.com record

I’ve been fairly successful using zapier to integrate our monday.com instance with Excel, OneDrive, Outlook etc. but am stumped with this one because I believe it entails a POST webhook of some sort. See below for the details of our set up Existing ProcessMonday.com creates an excel file and adds item specific information to itUser completes work in excel documentUser clicks button in excel that triggers macro to generate PDF and insert into a draft email Next StepsI would like for when that macro runs, to flip a status on Monday.com. At this point, I would have enough information about the item that it would be easy to find it, I just dont know what I need to do to trigger the process and where to send the data to be read by Monday (my research has told me that Monday.com only does outgoing webhooks. Thanks   

3201
christina.d
2 years ago
C
ChadLivingstonNew
asked in Code & Webhooks
Housecall. pro Tagging.

I have a typeform on my website and my current zap creates a customer in Housecall Pro.   Is there a way to have the zap also add a tag to the customer so that I know the new customer was made?

556
Troy Tessalone
2 years ago
W
warmsocialBeginner
asked in Code & Webhooks
How do I choose which type of data format I need to use when setting up QuickBooks Online line item?

Hi Team,I am working on the web-hook implementation to insert data into the sheet. I have inserted the data in the sheet using web-hook  but having issue to choose which type of data format do I need to setup for quick book line items.For example: Basically, I am working on the app where the user can make the design by itself and select the multiple garment with colours & sizes, quantity.So, lets suppose,  I have an order and in the order, there can be single/multiple design(D1, D2) items and each design can have multiple garment with multiple/single combination(Garment, size, colour, Qty) so, I want to use these details(combination) to make the invoice with each combination and with the help of line items in the zap.Please suggest me the data format that i need to add in the sheet by using web hook and about the grouped data(combination garment). Also, please assist me that, do i need to add the data in a single row of the sheet with comma separated like for design column(D1,D2) G

582
W
2 years ago
J
JuliAudrocBeginner
asked in Code & Webhooks
List Pop on Zapier Store with Javascript

Hello everyone!I'm a heavy user of the Zapier Store in code blocks (Javascript).Recently the data sent to the storage encountered a sudden increase and sometimes I got a full store (cleaning it everyday does not help).I wanted to adopt a FIFO approach, for which if the number of records in the store > 450, I would delete the first record created in the Store. I've been trying the following:let found = false;let secret = "mySuperSecret";let store = StoreClient(secret);// Get the amount of data included in the Storagelet res = await fetch("https://store.zapier.com/api/records?secret=" + secret);let body = await res.json();let length= Object.keys(body).length;console.log(length);let value = await store.get(inputData.importantInfo);if (value == "published"){ found = true; callback(null, {result:"Store Record already found"});} else { // Check if the number of records is higher than the limit if (length>450){ // Delete the first record in the Storage (FIFO) store.lis

1214
christina.d
2 years ago
A
Arun2020Beginner
asked in Code & Webhooks
Zoom and power bi Integration by using webhook

I am new to zapier and working testing some integration with zoom and power bi. How to get the data of zoom into power bi automatically through webhook. I am totally struck near the webhook. https://zapier.com/shared/0449dee80266916ae1885df1b47752e66d0c50ff   

4256
Troy Tessalone
2 years ago
J
JameswinBeginner
asked in Code & Webhooks
ReferenceError: input_data is not defined

I am trying to understand a syntax error I am encountering and was hoping what I’m doing wrong.I am pulling data from a previous step then using this data to make my API call but whenever I add my function an error is thrown ReferenceError: input_data is not defined but when I remove let data = input_data[“data”] or function it works as expected.const user = input_data['user_data'] //123const getUser = async (user) => { const token = "..."; const endpoint = `https://example.com/test?user=${userId}`; const request = await fetch(endpoint, { method: "GET", headers: { "Content-Type": "application/json; charset=utf-8", "Authorization": token, "Accept": "application/json", }, }); const response = await request.json(); return response;}const result = await getUser(user);output = { result } 

6883
Troy Tessalone
2 years ago
Z
Zap355555Beginner
asked in Code & Webhooks
How do I use the Squarespace forms API with Webhooks?

I am finding it impossible to find data on the net regarding tutorials for this subject. Solutions that I thought were going to be easy like Mongodb are near impossible because for some reason or another, the developers for Mongodb, or, Zapier, haven’t gotten around to updating their code. They still are a version behind, from my understanding. I’ve been combing around for hours and I have not found a solution. I don’t need someone to tell me everything to do, but, this is new to me, and, I would really like it if there was really helpful documentation out there, like, there seems to be with so many other products. Thank you! 

5203
Troy Tessalone
2 years ago
A
alexadagostinoBeginner
asked in Code & Webhooks
Issue with Monday Get Item by Column Value in monday.com

Has anyone experienced this before. I am trying to pull in Monday data into Zapier so that I can update fields in Monday when someone reschedules. So to break it down:I have the Monday Reschedule function. I then have 3 checks using Get Item by Column Value in monday.com (three different databases) to see if the person exists in any of these databases.  What I am finding is, for some reason, even though I am clicking a specific reschedule appointment In the “get Item by Column Value” it’s actually pulling the completely wrong person making it so I cannot do proper checks to get my zapier to actually launch.What I DO find though is if I get it to launch, it WILL run right but just not during the test. Anyone else experience this? ​​​​​​​ 

1502
Troy Tessalone
2 years ago
D
dane78Beginner
asked in Code & Webhooks
Zap not triggering for new webhooks sent

h teamI have created a ZAP which should run a triggert by a webhook. after subscription i got the hook urlas i run the following code (same from postman) i can see the hook in the monitor but nothing actually happned in the zap (emai/goolge sheet) am i missing something? await fetch("https://hooks.zapier.com/hooks/standard/5461766/f82abd556c744950bb4804b049a13eda",     { method: "POST",       body: '[{"id":20829875,"name":"M","firstname":"m","lastname":"w","company":"S","phone":"","title":"d","location":"usa","email":"xxx"}]',      headers: { "Content-Type": "application/json", Accept: "application/json", } });   

734
T
2 years ago
L
litechBeginner
asked in Code & Webhooks
Need help extracting data from webhook

Hello all, I am trying to figure out how to extract regular data from a webhook through Zapier. Here’s a snip of the payload as it comes in:message:    type: message    text:*Order-Form* submission from <user> *Item * Server Warranty Renewal *Company * Test Company I started messing around in Code but can’t get the js to run and do what I need. Normally, I’d just be able to pull the values or pick off a child key, but it seems like I’ll need some sort of coding with this since my two items I need are nested under “text”. The text after “item” and the text after “company” are going to be different every time. I would need to extract those values every time. This is where I am completely stuck. Any help would be greatly appreciated! :) 

7356
Troy Tessalone
2 years ago
D
DimNew
asked in Code & Webhooks
Adding user info to a new row when a new member joins my Discord server. How do I send messages to a Discord channel when the Zap runs?

Hello I use zapier to add the users info to a new row every time someone joins my discord server! The problem is that its kind of a hassle to come back to the website to make sure it runs. Now for the question, Is it possible to send a message to a discord channel I set every time the zapier process runs?

1981
Danvers
2 years ago
L
luoxinBeginner
asked in Code & Webhooks
sheets uses webhook to send a line of records to Enterprise WeChat.

I need to send a row of data from Google sheets to a messaging platform. His configuration requirements: How to use a group botAfter adding a bot to a group in the terminal, the creator can see the bot-specific webhook url on the bot details page, and the developer can make an HTTP POST request to this address to send messages to the group as described below. Here's a simple example.Suppose the webhook is: https://qyapi.weixin.qq.com/cgi-bin/webhook/send?key=693a91f6-7xxx-4bc4-97a0-0ec2sifa5aaaSpecial note: Be sure to protect the bot's webhook address from leaks! Don't share it on github, blogs or other publicly accessible places, or the bad guys can use your bot to spam.Here's an example of pushing a text message to a group using the curl tool (note that the url should be replaced with your bot's webhook address and the content must be in utf8 encoding).curl 'https://qyapi.weixin.qq.com/cgi-bin/webhook/send?key=693axxx6-7aoc-4bc4-97a0-0ec2sifa5aaa' \   -H 'Content-Type: application/js

1961
Danvers
2 years ago
S
SDCBeginner
asked in Code & Webhooks
Used Code by Zapier to try to grab UTMs with dynamic java seen on here, UTMs do not come through from the URL. Any ideas?

I used the code below in my zapier workflow to --- capture UTM info when a lead takes action on our website, fills out a form, then gets routed into pardot/salesforce.  Steps:1: webhookcode for UTMs prospect routing through pardot/salesforce I used for URL: http://site.com?utm_source=source&utm_campaign=campaign&utm_medium=medium&utm_term=term&utm_content=content and the code I used:  const url = inputData.url; // http://example.com?const urlObject = new URL(url);const id = urlObject.searchParams.get('id')console.log(id)// printsconst utm_term = urlObject.searchParams.get('utm_term');const fbclid = urlObject.searchParams.get('fbclid');const gclid = urlObject.searchParams.get('gclid');const gacid = urlObject.searchParams.get('gacid');const utm_campaign = urlObject.searchParams.get('utm_campaign');const utm_content = urlObject.searchParams.get('utm_content');const utm_medium = urlObject.searchParams.get('utm_medium');const utm_source = urlObject.searchParams.get('utm_sour

4822
Troy Tessalone
2 years ago
J
Juan CarlosNew
asked in Code & Webhooks
Enroll users to Thinkific getting data from Fluent Forms

Hi,We are trying to connect Fluent Forms and Thinkifiv via Zapier.The path should be this:User submits a form from Fluent Forms, Zapier gets the data and then enrolls the user to our Thinkific course. After the enroll, user should recieve a email with account credentials. The data we have to take from the user is its name, email and the pass (don’t know if it’s better setting pass from our side or there another way, like sending link to user to set by itself).To do this, I made a Zap using Webhook and following FF steps:https://fluentforms.com/connect-zapier-to-wordpress/When I try to do the Thinkific part, I can’t chosee which data is equal to our parameters.What am I missing? Also, if there is any tutorial (more detailed) I would like to know about it.Thanks 

1411
Danvers
2 years ago
B
BaIntegrationsNew
asked in Code & Webhooks
Get the name of the trigger app for a subsequent action

Hi Zapier Community,In the zap I have built, the trigger app is Hubspot and the trigger event is “New Deal”. Now, I would like to get the name of the trigger app (here, Hubspot) for a subsequent action where I use this name. How do I get the trigger app service name?I have tried obtaining the bundle and using the name under the service attribute as given here:"trigger": { "service": { "name": "A Zapier App", "logos": { "16x16": "https://cdn.zapier.com/storage/photos/73a6433488cca7c5bd6ed9836fd6d9c8.png", "32x32": "https://cdn.zapier.com/storage/photos/73a6433488cca7c5bd6ed9836fd6d9c8.png", "64x64": "https://cdn.zapier.com/storage/photos/73a6433488cca7c5bd6ed9836fd6d9c8.png", "128x128": "https://cdn.zapier.com/storage/photos/73a6433488cca7c5bd6ed9836fd6d9c8.png" } } }Even if I turn on the Zap and create a new deal on Hubspot, the name of the trigger service is “A Zapier App” onl

851
Danvers
2 years ago
J
jwolffNew
asked in Code & Webhooks
Unable to add Appcontx to my account

I am trying to connect my bot to Zapier using my Appcontx App credentials.  When I provide the key I get a 404 error and it does not allow the connection any help here?  If the API key is not recognized or accepted how then do I get support help to get this done to connect my bot?

151
Danvers
2 years ago
M
MauryNew
asked in Code & Webhooks
Webhook POST Running several Times

Hello! my Zap is doing a Webhook POST request to another API. The API takes a couple of seconds to respond and therefore the POST request is sent multiple times, trying to get a response from the other service. the other service logs reflects a response time of 0.85sec or 0.90secThis behavior causes duplicates in the database of the other service, because the same request is sent 2-3 times due the slow response time Is there a way to prevent the request to be send multiple times? I found this answer from a previous post… but besides directing where might be the issue, there is no example or advice for solution… Can anyone help? Best answer by DanversIt sounds like the webhook is waiting for a successful response from the API that it’s sending to. Are you able to take a look at the logs of the API that the Zap is sending to to see what responses it’s giving and it what timeframe? One thing to remember is that the timeout for getting a response from a webhook is 37ms, so if the API isn’t

5821
Danvers
2 years ago
J
jfreeman1412Beginner
asked in Code & Webhooks
Is it possible to use title of zap as a variable

Hello, Is it possible to use the title of a ZAP as a variable in <Zap_Title> in a zap.  More so in a MySQL custom Query?  

561
Troy Tessalone
2 years ago
M
mark_beeNew
asked in Code & Webhooks
Unable to configure auth on webhook

Hi, I’ve successfully created a zap using a raw webhook as a trigger/event.However, I don’t seem to be able to configure any form of authorisation on the webhook?Am I missing something?Thanks 

221
Troy Tessalone
2 years ago
M
mehedihasanNew
asked in Code & Webhooks
How to pass Google Sheet data in any website?

Hi I have some data in my google sheet. I want to send that data into my website. So, How can I solve it with zapier?

342
M
2 years ago
K
kt1111Beginner
asked in Code & Webhooks
How to get json data in Code step?

I have some data coming in in json format with Zap.(Attached "Long Answer")I want to use that json data in Code Step (JavaScript), but when I do JSON.parse, the test succeeds and the Zap execution fails.(Is the input format different between test and runtime?)For example, the following code will fail.// *input data// {"object":"AAA", "id":"BBB"}const fixed_json = JSON.parse(inputData.text);output = {"result" : fixed_json.object};How can I get the contents of the incoming json data with inputData?

627313
christina.d
2 years ago
R
RBaileyBeginner
asked in Code & Webhooks
Trouble creating spreadsheet-style-formula to compare data. Error: “The app returned "Invalid Syntax: Only numeric values are allowed"

Hi.  I am trying to take some data from some output of two people and compare to see if they are the same person.  I need to compare the name in addition to the birthdate.  I am using a formatter with spreadsheet-style-formula to do it but I am getting an error that says “The app returned "Invalid Syntax: Only numeric values are allowed".  I am not sure how to format the input to get the result I need.  Can someone help?  I am pretty new to this syntax.  I can’t tell if it needs quotes or not.  I have tried both ways.Formula=IF(AND(Rhonda Bailey=Suzy Q,01-08-1972=10-11-1990), “true”, “false”)Thanks,   

6745
R
2 years ago
L
luoxinBeginner
asked in Code & Webhooks
I use webhook to get the BODY: string, which cannot be broken down and written to Google sheets.

I use webhook to get the BODY: string, which cannot be broken down and written to Google sheets.Using formatter, please describe exactly the steps, and how to set up google sheets, has been bothering me for a long time. Thank you!

224
L
2 years ago
raehill
raehillNew
asked in Code & Webhooks
How to Search for a Google Contact when you have a large number of contacts (timing out)

Hi Everyone,Issue: When creating the action “Find Contact” for the App Google Contacts, it times out because I have 13,000 contacts. Zapier Support says this is a known issue with Google Integration but did not offer a solution.What I’m Trying to Do: Create a Zap that Creates or Updates a Google Contact when a record is created/updated in my database (Crelate ATS). I first want to search to see if the Contact already exists in Google Contacts but I can’t because the Zap times out.Any suggestions/workaround?Thank you!

351
Troy Tessalone
2 years ago
A
AmirKatzNew
asked in Code & Webhooks
Updating module in Zoho CRM

Hello,I want to create a Zap with the event “Create/Update Module Entry in Zoho CRM”,in which when two specific fields already exists, it will update the module instead of creating a new one.The problem is that when I define 2 “duplicate check fields” it checks if only one of them exists, and then updates if it does. I want the zap to update the module only if BOTH of the fields in a specific module are the same as the ones entered.Is there a way to do that? Thank you.

1771
Troy Tessalone
2 years ago
Terms & Conditions