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,356 Replies
Video

Code steps 101 (session from ZapConnect 2021)

  • 2
  • 1
2490 Topics
S
stylebaseBeginner
asked in Code & Webhooks
Importing a large list onto a Python code

  Hi Zapier Community I am running a Python code on Zapier and know that I cannot use libraries beyond the native ones.I am trying to import a list of strings that I use on the Python code as ONE huge string, which is a concatenate of all rows in a mySQL database. This long string doesn’t need to be regenerated every time, it will not change.  To generate this list on mySQL workbench I use the code SET @@group_concat_max_len = 3000000;SELECT group_concat(reference_field SEPARATOR ',')FROM Items; Which doesn’t work on Zapier, I’m guessing it’s SET function that Zapier is not liking because without i, the concat field works fine. But since the total length of the list of strings is ~3M characters, I need this SET function. I was also exploring storing the list of string values (or huge string value) in another file and using it in my Python code. But I can’t figure out what’s the best way to store a list of value (HTML, JSON,??) and how to import that onto Zapier so that it doesn’t look

820
S
2 years ago
L
lifeisgoodBeginner
asked in Code & Webhooks
zap is not receiving notifications.

 I'm using Google spreadsheet and messenger app in conjunction. using zapier through web hook. today, The corresponding "zap" does not receive and receive notifications. check history, The notification has been stopped since the 27th.(yesterday) I entered new data in real time, but there is no response. The spreadsheet is being input normally. Others work normally.

1153
christina.d
2 years ago
B
BFTNew
asked in Code & Webhooks
Adding +1 to a cell.

I’m looking to have my webhook add +1 to the number already in a cell. I’ve tried =(c8)+1 but getting a #REF error. Any ideas how I can take the number already there and add 1 to it? 

1512
GetUWired
2 years ago
A
AgriZapBeginner
asked in Code & Webhooks
Pick off a Child Key Syntax

I an trying to use Pick off a Child Key but when I use the syntax as below it doesn’t work:This is a subset of the payloaddata[contact]{:id=>"61d8326f88d0cd60e710e5e7", :first_name=>"TEST FIRST NAME AAABB", :last_name=>"TEST LAST NAME", and I an adding “contact” as the key

9468
jesse
2 years ago
T
Tom M
asked in Code & Webhooks
Attempting to use Zapier to send a JIRA custom request resulting in gaierror(-2)

Attempting to use Zapier to send an issue to a specific sprint is resulting in the following error: ('Connection aborted.', gaierror(-2))Any thoughts on what’s going wrong here?The documentation is here: https://developer.atlassian.com/cloud/jira/software/rest/api-group-sprint/#api-rest-agile-1-0-sprint-sprintid-issue-post 

7782
T
2 years ago
G
gijsdrogeNew
posted in Code & Webhooks
Klaviyo is not receiving any email from LinkTree

Hi @christina.d I am having the same issue. No other email from linktree is being transferred to my list in Klaviyo. How to resolve?

1721
jesse
2 years ago
S
SSCBeginner
asked in Code & Webhooks
My webhook only works with a single set of test data

Hello!I have created a webhook and it successfully runs the test data but won’t being over any other entries but the test one. Any ideas as to what I need to fix to grab all the data? Is it because the Prospect that i required is a particular ID instead of the field ID? I can’t make it blank it always appears as the test data ID. 

1123
jesse
2 years ago
T
TheSuburbsNew
asked in Code & Webhooks
Malformed Data Catch Hook from Klaviyo

I’m sending a webhook from Klaviyo and if I Catch Raw Hook, my ‘raw_body’ seems to be correct JSON format.  But If I try to Catch Hook with the same data, I’m seeing an error that the data is malformed. I get the same error whether I leave the child key empty, or enter ‘raw_body’ — which is my intended goal so I can use the ‘email’ and ‘f_name’ keys:  

941
Troy Tessalone
2 years ago
D
DocBeginner
asked in Code & Webhooks
How to send an array in webhook?

Hello,I’ve got a very basic question for anyone familiar with webhooks and posting data.I have a two step Zap where I:Get a sale from a system Post the sale back to the system with one line item amendedI can “get” the data very easily and successfully.However, when I post it back, I can’t figure out how to handle the array. The API I am using specifies that I send products back as an array of objects called “register_sale_products”, but how do I actually do this in my zap?Do I have one field with the key named “register_sale_products” and then all my data inside it, with zapier using its line items? Or do I create each field as its own key? I’m not really sure how to get this data back into the post request correctly.A screenshot of the two examples I’ve tried is below. What am I missing? 

23864
Troy Tessalone
2 years ago
V
vanessaBeginner
asked in Code & Webhooks
Testing Billing Api

I am testing Shopify Billing API and I am executing a appSubscriptionCreate with the parameter set to true. When I open the confirmationUrl and click approve the request does not succeed and just sends an error message stating that the store cannot accept the payment. My store is a development store, is it possible that it cannot accept a payment on testing mode?

520
V
2 years ago
S
shawnrosspetersBeginner
asked in Code & Webhooks
Unable to "Find a single item in an array, output corresponding field"

I was following the great article over at when I ran into trouble. After following the instructions EXACTLY and even reaching out to the author, I simply cannot get the correct output. I’ve been able to confirm that the incoming info for the step “Run Javascript in Code by Zapier” matches the format shown in the original author’s writeup but the output always fails to return the expected data.I followed the directions from the article but my output does NOT return the value. In fact, I don't have any output other than the id of the code step and a couple items for "runtime_meta". The links below are screenshots of the Code setup, Test Parameters (had to snag it quick) and the Output. Code Setup stephttps://www.awesomescreenshot.com/image/27853177?key=18d81e5faa769e0766cd535f28b547f9 Test Parameters (what shows briefly when testing the step)https://www.awesomescreenshot.com/image/27853176?key=8e64b2a0846ef888ad497b9f28a6244f Outputhttps://www.awesomescreenshot.com/image/27853175?key=70f

1678
jesse
2 years ago
M
Michael HummelNew
asked in Code & Webhooks
Nested JSON brackets POST

Hi guys, Example JSON:"ConsumerDetails": {        "DeliveryAddress": {            "Company": "",            "FirstName": "Kelvin",}}  DATA field:= ConsumerDetails__DeliveryAddress__Company=ConsumerDetails__DeliveryAddress__FirstNameThat works! But!What if i need to POST the following in the DATA field?:  "Lines": [{`        "Sku": "1001",        "OrderedQuantity": 1,}] Ive tried:Lines__skuLines__lines__skuLines[lines]skuLines[lines]__sku The [ ] markup the API required me to send the ‘lines’ data in is not recognized.Anyone know how to do this? Tnx in advance.    

211
Troy Tessalone
2 years ago
N
NagamanickamBeginner
asked in Code & Webhooks
How to create async function?

in code mode, how can we create async function.

7291
Troy Tessalone
2 years ago
P
polygonwindowBeginner
asked in Code & Webhooks
Send boolean values in webhook data

Hi!I need to send a Webhook POST request with JSON payload to trigger a push notification. I have everything set up and working fine EXCEPT that I struggle to send boolean values to the notifications endpoint.Seams that you only send string values in the data fields?e.g. I need to send:{ "title": { "de": "Lorem ipsum dolor sit amet", "fr": "Lorem ipsum dolor sit amet" }, "content": { "de": "Lorem ipsum dolor sit amet", "fr": "Lorem ipsum dolor sit amet" }, "url": { "de": "https://www.google.com", "fr": "https://www.google.com" }, "skipPushNotification": false}but zapier seems to send (check the “skipPushNotification”):{ "title": { "de": "Lorem ipsum dolor sit amet", "fr": "Lorem ipsum dolor sit amet" }, "content": { "de": "Lorem ipsum dolor sit amet", "fr": "Lorem ipsum dolor sit amet" }, "url": { "de": "https://www.google.com", "fr": "https://www.google.com" }, "skipPushNotification": "false"}Here is my setup:I found this post from ~2

6371
Troy Tessalone
2 years ago
P
Partener APLNew
asked in Code & Webhooks
Fields from JetformBuilder not populating in Google Sheets?

Hello,I have a problem with zapier because he didn't give me the automatic text from the section I want to add from my form and put it in google sheet, and I don't understand why he didn't write it to me automatically. Field fields should be done automatically instead of automatically!This is my sitehttps://administratielocala.ro/formular-finante-locale-3/

2112
P
2 years ago
J
josephsultanBeginner
asked in Code & Webhooks
Intercom webhook when an event happen to a conversation

Hi Team! I will be so grateful if anyone can help me with this one!I would like to build an integration between Intercom and Google sheets, to be triggered when an SLA is missed in a conversation. My understanding is that the way here is through Webhook, can someone help me with where to start or how can i go about this one? I want that; 1) When an SLA is missed in a conversation2) The link of the conversation will be sent to google sheets new rowThanks!

1033
christina.d
2 years ago
M
morningmeditationBeginner
asked in Code & Webhooks
Zapier Webhook and Stripe Integration to Search for Payment Intent

I’m setting up a Zapier Webhook GET from Stripe to search for a Payment Intent via the Customer ID.I’m getting an error:Failed to create a request in Webhooks by ZapierThe app returned "invalid_request_error".--Here is the Zap setup: 

5237
M
2 years ago
A
aellcBeginner
asked in Code & Webhooks
Getting error when updating a record in my last step: Object of type LazyFile is not JSON serializable

So I created a webhook Zap that adds an invoice attachment to Airtable. This original zap works fine. I wanted this zap to do the same thing in two other tables in the same base so I copied this Zap twice. I set up everything the exact same as my original Zap just in another table. Yet I keep getting this message when I try to update a record in my last step:Object of type LazyFile is not JSON serializable I’m not even sure what this means or why it is doing this when the Zaps are the exact same other than the location it is locating and updating records. If anyone can give me some advice to figure out why this isn’t working that would be greatly appreciated. 

2463
A
2 years ago
A
azcwebmanagerBeginner
asked in Code & Webhooks
Many problems with new GravityForms/Zapier integration

As others have mentioned on this forum, the new GF ↔ Zapier integration is a total mess for some of us that relied on the existing APIs.In particular, the seeming requirement to have a 1-1 correspondence between a given form and a Zap has caused so many headaches. (We used to be able to have dozens of forms reference the same Zap’s webhook, but now these are all “managed” and as far as I can tell the 1-1 correspondence is forced; the benefits for Zapier to artificially increase Zap count are obvious.)Besides all of that, and after moving to the next Zapier billing tier in order to get the unlimited zap count we would need to migrate our existing forms to use the new API/plugin pairings, I’ve still been unable to establish a workflow that is suitable for our (non-technical) content/form authors on the front-end side of our site’s content management.The previous workflow was that a form author would clone a master template, make some minor cosmetic changes, and put the appropriate webhoo

6655
Z
2 years ago
M
MAGAZONNew
asked in Code & Webhooks
How do I parse .xslx file in my Zap or to convert the file first in .csv?

I have a Zap that triggers when a new email is received in the inbox created using Zapier Mail Parser. The email comes with a file attachment with .xlsx file format. I need a way to parse that file in code step or otherwise but preferably in code step because that’s where my other code and calculations live. Is there a way to parse .xslx file in Zapier or to convert the file first in .csv. I tried uploading the file to Google Drive and then finding the same file and using the text/csv link but i can not retrieve it’s contents and it requires authentication or a public URL. I also tried cloudconvert but it’s not accepting URL that i provide. If there’s a better easier way to handle this i’d really appreciate it. TIA

11472
GetUWired
2 years ago
A
Andy_AndyNew
asked in Code & Webhooks
How do I add 1hour delay before the start and end date to get data?

Hi Guys, I am trying to use Zapier webhook get data from a system hourly.For the argument of query, I need to send a startDate and endDate to get data during this hour.I can Insert nowtime as endDate by insert data provided by Zapier.But don’t know how to add a time 1 hour before now time.Is it available, if it is, please help me.  

2403
M
2 years ago
T
techman123Beginner
asked in Code & Webhooks
Date formatting in first step of webhook

I need the current date and the date for 7 days ago in the first step of a webhook to insert into my call (no time, just formatted MM/DD/YYYY).  I figured that I could do create a first step and use the formatter in the first step based on {{zap_meta_human_now}}, but Zapier wont let me create a first step with the formatter.  What’s the best way to handle this?

6917
T
2 years ago
E
ecoconstructionenergyBeginner
asked in Code & Webhooks
Get address from "Extract Pattern"

I am trying to integrate Calendly with my CRM. The annoying thing about Calendly is that you can’t map an individual “answer” to a single data field in the CRM -- instead, there is an output value for Calendly called “Answers”, which is a string of text that includes ALL answers to all questions from the Calendly scheduling page. So for instance, if my Calendly event asks for an address, city, zip code, plus more, the “Answers” field would consist of the invitee’s answers to all of those fields.So I figured out how to extract just a phone number from “Answers” (using the simple “Extract Phone Number” action in Zapier), and I got that mapping successful in my CRM. Yay!But the next challenge is extracting somebody’s address from the Calendly “Answers”. I assume that I’d have to use the “Extract Pattern” action in Zapier, but I need some help coming up with the Python code to match the pattern of a home address. The pattern would be something like 1234 Street Name Rd, so...A 3-5 digit str

2113
Troy Tessalone
2 years ago
E
EdanNew
asked in Code & Webhooks
Is it possible to avoid a link in a LinkedIn post w/ image?

I’m looking to publish directly to LinkedIn and would like to include an image. At the moment, including an image makes the URL field become mandatory instead of remaining optional. The result of this is a post that looks like an article when it’s not.Below is the Zap and preview of a test post. The link from Airtable is technically just the URL for the image that should be included in the post.  

1661
Danvers
2 years ago
N
Nimrod H.New
asked in Code & Webhooks
Calls to External API and tokern issues

HiWe have a published WebAPI by the Ministry of Transportation to allow the retrieval public information. The way it works via code is that you would call a Login API (with a username and password) to get a token and then use this token in order to call other functions.We’ve been testing it with C# code but we decided that with all the codeless integration and automation platforms this would be too time consuming and require skill sets that we do not have and do not wish to have 😉To be more specific:This is where MOT puts all the ‘documentation’ regarding their WebAPI pool.We’ve been using the “.NET call example” (Scroll down on the main page) that consolidates some of the functions starting from Login and then using the token from Login to retrieve data from Overweight and finish with Logout Our goal is first and foremost to bring structural data (mainly tabular) into either Excel, Airtable etc.I started by trying to utilize Webhooks in order to call the Login process and obtain the

420
N
2 years ago
Terms & Conditions