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 Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

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.

Code & Webhooks

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

  • 2,163 Topics
  • 7,366 Replies
Video

Code steps 101 (session from ZapConnect 2021)

  • 2
  • 1

2163 Topics

S
SayersNew
asked in Code & Webhooks

At least one not empty property is required, otherwise action would fail with error

How do I know which field is causing this warning?“At least one not empty property is required, otherwise action would fail with error”I am trying to create a contact in Hubspot from LinkedIn. When linking the variables from the JSON to the Hubspot variables this warning appears.Thanks in advance

1
Troy Tessalone
1 year ago
D
Derrek HennessyBeginner
asked in Code & Webhooks

Zapier is not pulling back all data from a Postgres Heroku Query with JOIN

This is the query I put into Zapier and for some reason it is not pulling back the organization name. This lives in a different data table so I used JOIN. This query works no problem in heroku data clip but in Zapier its missing all the fields associated to the JOINs. How do you prevent this? SELECT organization.name, test_test, concat('Unique URL’) AS url, test_id.name, test_status, test.created_atFROM test_plan_specJOIN user_account ON user_account.id = test_plan_spec.user_account_idJOIN organization ON organization.id = user_account.organization_idWHERE tps_status = 'ACTIVE'ORDER BY test_plan_spec.created_at ASC 

4
D
1 year ago
J
Joe PetersonBeginner
asked in Code & Webhooks

Firebase create a record with child

Hello, I’m trying to send data from webhook to firebase through zapier. I was able to send fields, but I’m not sure how to send with child object? Here is what I need to be in firebase  But on Zap there is only input fields, so I’m not sure how to create an object with fields and “seller” object with email, name.  

1
J
1 year ago
P
pluviano16New
asked in Code & Webhooks

POST using Vicidial to Zapier

Hello Im trying to post info from Vicidial to Zapier using a API and lm trying to find instruction on how to do it but it seem like i cant find it, any out there that can help? Thank you in advance!

2
C
1 year ago
T
thatkidrichNew
asked in Code & Webhooks

Call a webhook and return data from Airtable

I am trying to set up a flow and I am not sure how it would work.  I am calling a webhook and passing some query parameters to Zapier. Zapier catches the hook, and uses the data to search for a record in Airtable, all works well...BUT, I want to the response of the webhook call to return the record it found in Air table. Anyone ever do anything like this?

1
Troy Tessalone
1 year ago
F
FahadBeginner
asked in Code & Webhooks

How to get a parent message of a Slack thread in Zapier?

Hey, I want to get the parent message in a slack thread using a thread id.  I have never worked with API's but today I gave it a try.  I got this code from chat gptimport osfrom slack_sdk import WebClientfrom slack_sdk.errors import SlackApiErrordef main(input_data):    # Retrieve the Slack API token from the environment variables    SLACK_API_TOKEN = os.environ["SLACK_API_TOKEN"]    # Initialize the WebClient with the API token    client = WebClient(token=SLACK_API_TOKEN)    try:        # Call the conversations.history method using the WebClient        # The client passes the token you included in initialization            result = client.conversations_history(            channel=input_data["Thread_ID"],            inclusive=True,            oldest="1610144875.000600",            limit=1        )        # Get the first message in the result        message = result["messages"][0]        # Print the message text to the console        print(message["text"])    except SlackApiError as e: 

20
F
1 year ago
T
TylerSBeginner
asked in Code & Webhooks

The number of applicants in workable is not matching in HubSpot.

We are having some issue with Zapier to HubSpot. The number of applicants in Workable is not matching the number of candidates in HubSpot. Zapier is the middle tool that we are using so that we can receive applicants from Workable. Can someone please help me to fix this so that all applicants from Workable will go through in HubSpot? 

24
MohSwellam
1 year ago
J
jmcallisterNew
asked in Code & Webhooks

Code Timeout Issue in Zap

I have a zap that makes an API call that takes 10+ seconds. Triggering it via python code. The API is responding in about 5-15 seconds, but the zap is ending prematurely do to timeout when it takes >10 seconds. How can I extend the timeout for a zap to 20 seconds or so? 

2
christina.d
1 year ago
J
Joshua MursicBeginner
asked in Code & Webhooks

Create 2 arrays from 1. One array with Unique Items, and the second with occurrence of those items

Hello,I have a list of text items that I would like to loop through to create 2 outputs. One array that contains the unique items in the list, and another that contains the occurrences of those items. I am trying to create an Invoice in Quickbooks and I want the invoice to have the item and the quantity, instead of a duplicate item over and over again with a quantity of 1. Thanks in advance! Kind regards,Josh   

5
J
1 year ago
J
JayKBeginner
asked in Code & Webhooks

Code Help: Two Lists - How to Add The Lists Together, How to Remove (Subtract) the lists?

Hi, I’m hoping someone can help me. I’ve been playing around to try and do this, to mixed results.The input values are coming in via webhook, as a list comma separated listExample 1: Adding 2 to 1Input 1: [Alice, Bob]Input 2: [Charlie]Desired Output: [Alice, Bob, Charlie] Example 2: Subtract 2 from 1Input 1: [Alice, Bob, Charlie]Input 2: [Bob]Desired Output: [Alice, Charlie] I’ve been playing around with code in both Javascript & Python to try and achieve these results.I thought I had it, but instead of adding / subtract the items in the list, it seemed to add / delete the individual characters instead. But maybe I was outputting it wrong? Thank you for any help you can offer. 

2
Todd Harper
1 year ago
J
JonathanGrafDigitalschaftNew
asked in Code & Webhooks

Firebase/Firestore: Query Document by __name__ doesnt work

I am trying create a query for specific Firestore Document by filtering for its generated ID like this:  { "where": { "fieldFilter": { "field": { "fieldPath": "__name__" }, "op": "EQUAL", "value": { "stringValue": "{{177820683__Campaign ID}}" } } } }But everytime i try to run it i get this error message.Error code 400: [{ "error": { "code": 400, "message": "__key__ filter value must be a Key", "status": "INVALID_ARGUMENT" } } ]I looked through the whole documentation on Googles Site but cannot find a way to do that. For normal fields this works and I do not want to additional fields just for Zapier.

1
christina.d
1 year ago
A
AidenBeginner
asked in Code & Webhooks

Catch Hooks in Wix's Webhooks

Hello, I am trying to integrate Wix and Zoho Inventory using Zapier. Wix’s Automation doesn’t provide enough detail to match Zoho Inventory’s API, so I switched to using Catch Hooks in Webhooks by Zapier to catch data from Wix’s Webhook. I put the Webhook URL(created by Zapier) in Wix’s Webhook. I tested the trigger and Zapier couldn’t catch any data but this: “querystring:”Is it because they use different types of language? If so, is there a workaround this?Or is it a different kind of problem?Please let me know what you think! Thank you

3
Todd Harper
1 year ago
F
FahadBeginner
asked in Code & Webhooks

How to get a parent message of a slack thread in Zapier

Hey, I want to get the parent message in a slack thread using a thread id.  I have never worked with API's but today I gave it a try.  I got this code from chat gptimport osfrom slack_sdk import WebClientfrom slack_sdk.errors import SlackApiErrordef main(input_data):    # Retrieve the Slack API token from the environment variables    SLACK_API_TOKEN = os.environ["SLACK_API_TOKEN"]    # Initialize the WebClient with the API token    client = WebClient(token=SLACK_API_TOKEN)    try:        # Call the conversations.history method using the WebClient        # The client passes the token you included in initialization            result = client.conversations_history(            channel=input_data["Thread_ID"],            inclusive=True,            oldest="1610144875.000600",            limit=1        )        # Get the first message in the result        message = result["messages"][0]        # Print the message text to the console        print(message["text"])    except SlackApiError as e: 

0
F
1 year ago
Z
ZhealeNew
asked in Code & Webhooks

Custom API request periodically

I have an API I’m using (SocialBlade). Long story short, I want to be able to pull the information through the API periodically. I have a google sheet which I have a list of social handles and I want to pull the followers for every handle through the API and update either the same sheet or a different sheet. I also want a way to be able to refresh the data every so often. Any ideas?

1
nicksimard
1 year ago
G
Google Forms -> Monday.comBeginner
asked in Code & Webhooks

webhook test data not being populated

It seems like ever since Zapier rolled out “drafts”, none of my webhook triggered zaps have new “test data” in the dropdown when I refresh.  Has anyone else had this issue?

8
T
1 year ago
S
StarrfocksBeginner
asked in Code & Webhooks

Need to translate text into numbers

I am using Google sheets connected to webhooks to post data to my crm. The CRM requires the state field as a number. So Alabama or AL = 1.Can I use formatter to accomplish this? I need it for 15 plus states. It needs to read the sheet and if it sees the state name or abbreviation in the state field it will post the the proper numeric number to the CRM

2
S
1 year ago
M
MrLeadNew
asked in Code & Webhooks

State abbreviation required but state name given

Failed to create a request in Webhooks by ZapierThe app returned "data.state: Michigan is not an acceptable value! Must be one of: AL,AK,AZ,AR,CA,CO,CT,DE,DC,FL,GA,HI,ID,IL,IN,IA,KS,KY,LA,ME,MD,MA,MI,MN,MS,MO,MT,NE,NV,NH,NJ,NM,NY,NC,ND,OH,OK,OR,PA,RI,SC,SD,TN,TX,UT,...". data.state: Michigan is not an acceptable value! Must be one of: AL,AK,AZ,AR,CA,CO,CT,DE,DC,FL,GA,HI,ID,IL,IN,IA,KS,KY,LA,ME,MD,MA,MI,MN,MS,MO,MT,NE,NV,NH,NJ,NM,NY,NC,ND,OH,OK,OR,PA,RI,SC,SD,TN,TX,UT,VT,VA,WA,WV,WI,WY,PRshow less

3
Danvers
1 year ago
J
jparnellBeginner
asked in Code & Webhooks

Webhook to excel save question

Webhook is providing data to an excel spredsheet throughout the day and after a certain time (ex. 1:00PM) we want the zap to do a save as and place into a folder in onedrive business.  Does anyone know if this can be done?

4
Troy Tessalone
1 year ago
A
alon123New
asked in Code & Webhooks

Google sheet date field turns to random numbers

I created a webhook from my element or form to a google sheet.for some reason the date and time field I defined shows random numbers, what seem to be the reason and how do I fix this?* ill mention that the test from Zapier send those properly and the random numbers appear only when I send the form manually

1
Danvers
1 year ago
D
dunkstewartNew
posted in Code & Webhooks

Sending selected text to Zapier via a chrome extension

I created a simple chrome extension that sends the currently selected text to Zapier via a web hook. It solves the problem asked in this question - Select Browser/Website Text, Right Click, Send To Zapier - Searched all day for the answer, can someone help?I built it to streamline my own product research with Dovetail.It’s called Post Selected, hope others find it useful :) Duncan

0
D
1 year ago
J
jrolfeNew
asked in Code & Webhooks

Is there a simple way to validate json?

I have a number of zaps that receive data via a webhook.  I then need to build a different json string using SOME of those fields, some other custom data, etc. to post to a different api using a separate webhook action.  It’s pretty simple, and all works well until some of my fields have invalid characters in them - like quotes or a backslash.  These end up invalidating the json because they are interpreted as string termination or an escape character by the system receiving the json.  In my case, it’s Splunk sending data to a listening Zapier webhook, which I then manipulate and send to a Cisco WebEx space using a custom webhook action.I can fix this by adding a “formatter” action and doing a string replace on any given field for any given character, but when I’m building a json string of say 15 different fields from my initial input, all of which “might” have a “ or a \, then that’s a very inefficient way to format.  What would be ideal if there was a simple “validate json” action, o

1
Troy Tessalone
1 year ago
R
Ridge TBeginner
asked in Code & Webhooks

Zapier and Bunny.net Integration

What’s up guys, I’ve noticed that zapier does not have any integrations with bunny.net (video storage service). Is there a way around this maybe using API or webhooks?Any advice would be helpful!

2
christina.d
1 year ago
A
azcwebmanagerBeginner
asked in Code & Webhooks

Malformed JSON between Zapier webhook POST / Catch Raw Hook

I’m have a Custom Request webhook action w/ Data Pass-Thru enabled, sending data to a Catch Raw Hook trigger. I can see everything sent in the raw_body field of the Zap with the Catch Raw Hook trigger, but the JSON is malformed: it uses ‘ instead of “ for both the key names and for the string-typed fields in the JSON object.This obviously makes it not possible to get at the data via JSON.parse() in a subsequent Run Javascript action.Why is the raw_body field not valid JSON and how do I fix it?Note that “just globally search and replace single quotation marks to double quotation marks” is not a valid solution, as that will tamper with legit string-typed JSON fields that have double quotes.I also feel like I shouldn’t have to do ad-hoc munging of the data from Zapier to itself...

8
S
1 year ago
R
RahulGuptaBeginner
asked in Code & Webhooks

Trying to check a sheet field is Empty or not using Code tool with Python language but facing error again and again

I’m using the sheet as a trigger and there is a field called Track Inventory in that sheet if the field is blank(no data)  I want to assign a value to a variable Facing this error 

1
R
1 year ago
R
RahulGuptaBeginner
asked in Code & Webhooks

I'm trying to Check Uncheck the free shipping Field (Product field of BigCom) using Webhook tool but this is not working.

  I think something is wrong with this is_free_shipping field because other fields are updating except this Free shipping fieldplease help me   

10
R
1 year ago
Terms & Conditions