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,573 Topics
  • 8,510 Replies
Video

Code steps 101 (session from ZapConnect 2021)

  • 2
  • 1
2573 Topics
M
mhalletBeginner
asked in Code & Webhooks
Using a dynamic key in POST request - possible? (Updating Sportspress event in Wordpress)

Hey folks, hope you’re doing well! Been stepping up my Zapier automation game lately and been working on a project that essentially triggers when a spreadsheet is updated with sports event scores and automatically updates a Sportspress event hosted on a Wordpress website. I’m so close I can almost taste it! Everything works well until I need to make a dynamic reference to the two teams participating in the games. Essentially I am using a POST request through Zapier App Extensions and I can get everything to update as desired when I have hardcoded team ID numbers. But when I try to reference these variables {{home_id}} and {{away_id}} it seems to read these characters literally instead of recognizing that it should be a variable. If I use the actual IDs of these teams, everything works as intended. The challenge presents itself when I try to use these variables as it’s reading the variables literally. I’m attaching some screenshots so you can take a peek and if more information is requi

1262
M
Q
quitterxNew
asked in Code & Webhooks
How to setup webhooks between WordPress and a separate HTML website on HTTPS?

i have a website https://ai-architects.cloud that is on wordpress, then its got another layer, a hostname https://demos.ai-architects.cloud , and the https matters because they are both secure so should be able to send traffic back and forth since the demos layer is a valid A record using an AWS ip address running a flask app. Only thing is the demos layer is regular html, and I can’t figure out how to get the webhooks to work so they talk to each other. Do you have any integrations documentation?I figure i will be facing a similar issue with https://elpaso.ai because its is running http://ai-agents.live in a https://repl.it domain, and same thing, it is an html website.thanks in advance.

391
Q
matthewcharlesb
matthewcharlesbBeginner
asked in Code & Webhooks
Create "id" property from API that needs to be parsed to an int

I am trying to fix the “Got a result missing the "id" property” issue. return z.request(options) .then((response) => { response.throwForStatus(); const results = response.json; const sales = results["data"].map((item) => { return { ...item, id: item["record_id"], }; }); console.log(sales); return sales; }); In the code above, the “record_id” in our API contains a prefix of either “a_” or “t_” or “d_”. This means a “record_id” could be “a_123456”. I try to address it with: return z.request(options) .then((response) => { response.throwForStatus(); const results = response.json; const sales = results["data"].map((item) => { return { ...item, id: item["record_id"].replace("a_",10).replace("t_",11), }; }); console.log(sales); return sales; }); However, when I view the output I get an error of: Invalid API Response: - Got a two or more results with the id of "10" I would think it should return “10123456” based on the example above. Any input on why it’s not working properly? I’ve tried this

313
matthewcharlesb
matthewcharlesb
matthewcharlesbBeginner
asked in Code & Webhooks
Create "id" property with a parse first

I am trying to fix the “Got a result missing the "id" property” issue. return z.request(options) .then((response) => { response.throwForStatus(); const results = response.json; const sales = results["data"].map((item) => { return { ...item, id: item["record_id"], }; }); console.log(sales); return sales; }); In the code above, the “record_id” in our API contains a prefix of either “a_” or “t_” or “d_”. This means a “record_id” could be “a_123456”. I try to address it with: return z.request(options) .then((response) => { response.throwForStatus(); const results = response.json; const sales = results["data"].map((item) => { return { ...item, id: item["record_id"].replace("a_",10).replace("t_",11), }; }); console.log(sales); return sales; }); However, when I view the output I get an error of: Invalid API Response: - Got a two or more results with the id of "10" I would think it should return “10123456” based on the example above. Any input on why it’s not working properly? I’ve tried this

172
matthewcharlesb
bridgman
bridgmanBeginner
asked in Code & Webhooks
Anyone using Less Annoying CRM's API through Zapier?

I’m trying to get my head around how to format requests to Less Annoying CRM’s API from Zapier. Specifically, I’m trying to call GetGroupsAttachedToContact (doc here: https://account.lessannoyingcrm.com/api_docs/v2/Core_Functions/Group_Memberships and their API syntax is here: https://account.lessannoyingcrm.com/api_docs/v2/Getting_Started/Connect) I’m sure I’m formatting the data incorrectly, but translating their function definitions to Zapier by way of their cURL examples has me stymied. A simple example would be a huge help.

451
Troy Tessalone
F
FJ-DevsBeginner
asked in Code & Webhooks
Zoom to Zapier Webhooks Not Validating

So I’m a little confused on where things lie... I found this thread: Will Zapier provide a solution to enable set up of new Webhooks with Zoom? It made it sound like this was a solved solution. But it’s not working for me. It also wasn’t working for the users in this thread: Zapier Webhook validation with Zoom not working I have a Catch Raw Web Hook set up in Zapier, and it’s showing data being captured, but the auth URL fails on the Zoom side, stating “URL validation failed. Try again later.” What is anyone else’s current experience with this? Appreciate any and all efforts!

54210
F
S
SageSBeginner
asked in Code & Webhooks
Zapier API Request to Zenoti unsuccessful 500

Hello Zapier community, I’ve created a POST request to Zenoti’s API via Zapier Webhooks and I believe my request is formatted correctly. I’ve tested this request in Zenoti’s own API Docs and had the same error (invoice create unsuccessfull) the code on their doc website comes up as: Zenoti API doc request Here are my inputs on Zapier: Zapier’s Inputs And the response Zapier gives me: Zapier’s error code Does anybody see what the issue is? I’ve reached out to Zenoti’s team to see if they can see what the problem is on their end. Any help would be greatly appreciated, thank you!

321
Troy Tessalone
S
SageSBeginner
asked in Code & Webhooks
Create an API key for Zapier in Zenoti

I’m trying to generate an API key for Zapier in Zenoti so I can use Zapier’s Webhooks to send API requests to Zenoti via Zapier Webhooks. Zenoti requires a URI from Zapier to create the API key, where can I find the URI? I’ve seen Zapier provide its URIs for specific apps like Mc Professional and Gitlab: Zapier’s URI for Mc Professional Zapier’s URI for GitLab But I haven’t seen found a Zapier URI that I can use to make an API key in Zenoti. Here is the information required to make an API key in Zenoti: Zenoti’s API key generation fields Any help would be greatly appreciated, thank you!

924
S
H
HugomanNew
asked in Code & Webhooks
How to consume a new message published to a subscribed topic on an activeMQ broker by trigger?

Hello, How do I need to set a trigger when I would like to consume a new message (JSON formatted) that will be published to a topic I would like to subscribe to at an ActiveMQ broker. This received new message will then be processed further in the next steps. Thanks a lot in advance. Best regards, Hugoman

361
SamB
Community Manager
E
ericgTinkerer
asked in Code & Webhooks
Composing and making batch API calls from CSV. How would you approach this?

THE PROBLEM: I have hundreds of shipments in my e-comm to update with tracking numbers. There is no batch upload process to do this but I can and have made API calls to update the shipments. Thing is, in order to update the shipment I need a ShipmentId which is a unique identifier and in order to get that I need to make another API call. Here’s a zap I have in place that works fine: I send a CSV with columns for ACCOUNT NUMBER, ORDER NUMBER, VENDOR NAME, and TRACKING NUMBER to Zapier. Import the CSV and then start to loop over them. First I make an API call using the ORDER NUMBER and VENDOR NAME – this returns the ShipmentId which I use to make another call to update the shipment with tracking number. The ACCOUNT NUMBER is used for auth. This all works fine, but you can imagine that this gobbles up a lot of tasks. I think there might be a better way, but I’m having a hard time wrapping my head around it. THE POTENTIAL SOLUTION: My first thought was that I could use a code step to combi

3462
E
V
ViveBeginner
asked in Code & Webhooks
PATCH in Webhooks by Zapier to Update Klaviyo Profile - Invalid Input and Malformed Request Errors

Hi. I’m trying to add a Webhook Custom Request step to my Zap that uses a Klaviyo PATCH API to update a phone number field in a Klaviyo profile. The Klaviyo profile ID and phone number are dynamically pulling from previous steps in the Zap (I tested the PATCH step by entering static ID and phone and still got the same error). However, I keep getting errors - either “Invalid Input” or “Malformed Request” (depending on the various entries I have tested in the “Data” field). I’m thinking that I haven’t entered the correct information in the “data” section, as I don’t know exactly which part of the code to enter. Or, does a PATCH need to be connected to some other Webhook to work, as it is currently just this single step in my Zap flow (I’m a novice and don’t fully understand webhooks). Thank you in advance for any insight. Klaviyo “Update Profile” API documentation: https://developers.klaviyo.com/en/reference/update_profile

202
Troy Tessalone
V
Visa GeezaBeginner
asked in Code & Webhooks
How to insert text into a new page in a Google Docs using Zapier?

Hello, I am trying to insert text into a Google Doc on a new page. Tried all types of html code for page break, but doesn’t work… Saw this topic: and wanted to know how can I set up the API request? My document is dynamic (I don’t know how long it will be), so splitting before the end wouldn’t work unless there is a tool/app that can split the text based on criteria, like some symbols or stuff that I can add to the end… Any help would be great, thank you in advance!

3386
V
C
clentBeginner
asked in Code & Webhooks
How to upload forminator form media to GDrive?

Hi @everyone, I create a zap that will move forminator form data to Asana using webhook. I want to move form attached media to GDrive, I can easily upload one document (photo, PDF, Video) at a time but how I can move multiple documents to GDrive?

13713
C
B
Bruno BendavidNew
asked in Code & Webhooks
New Issue (Via JQL) in Jira Software Cloud

Hi, I build new task that triggered on “New issue via JQL. Does it identified issue creation on the spot and run the JQL? Or it using any kind of interval to executethe JQL against Jira? If i change the trigger to be “Issue create” (without JQL), is taht will be immediate triggered on issue create or its also based on interval. if that runs as interval, what is the value and can i control it to decrease.

161
Troy Tessalone
L
lijom1980New
asked in Code & Webhooks
HTTP POST Content-Type: application/x-www-form-urlencoded

This curl works imported to Postman - it works curl https://invoice-generator.com \ -d from="Nikolaus Ltd" \ -d to="Acme, Corp." \ -d logo="https://example.com/img/logo-invoice.png" \ -d number=1 \ -d date="Feb 9, 2015" \ -d due_date="Feb 16, 2015" \ -d items[0][name]="Starter plan monthly" \ -d items[0][quantity]=1 \ -d items[0][unit_cost]=99 \ -d notes="Thanks for being an awesome customer!" \ -d terms="Please pay by the due date." How to send the same using Zapier. I tried everything I knew, and still getting a blank pdf

1051
Troy Tessalone
D
DFMNew
asked in Code & Webhooks
Zoom ID in UUID Needed for API Request

I’m trying to build an automation that deletes Zoom recordings. I’m relying on AI to help me setting this up since I’m not knowledgeable and it seems that the Zoom app is providing the meetingId (FgQPW0qrTGyOdLPxBunTXw==) and recordingId (9c3cb230-0b51-42d8-8b8f-1b18b3b7c0c5) in a wrong format How can I fix this? Apparently I need them to be a 10 or 11-digit number (at least the meetingId should be this according to Zoom)

681
Troy Tessalone
J
Joel LAMBOURDIEREBeginner
asked in Code & Webhooks
Generate draft orders with line items in Square using Webhook by Zapier

Hi, I am desespartly trying to create "Draft orders" in Square as an Order ID is required to créate an invoice in Square. Create a “Draft order” is not currenly avaliable in Zapier. We can only create "paid Order" but no "Draft order". I have tried to get this done using the " Post in Webhook by Zapier" app. I first tried to use the "Post" event… but it has not worked as I need to put Line items data and that they do not seem to be supported. Here a screenshot of a “draft order “ test request I have sent using Square API Explorer and for which I got a 200 response ( I also test my request with Postman and it worked too) : The following Zapier guide explains that we can send Line-Items data with " Post in Wehbhook by Zapier" app using the “Custom Request” method : So I have tried to implement step by step what is explained on that guide. I first made sure to get on a previous step of my zap all the data I need to send to the API call. Just do not know what to do from there. Here are the

951
Troy Tessalone
T
testing123New
asked in Code & Webhooks
How do I turn excel file in sharepoint to JSON file

Hi I have an excel file located in sharepoint, which I want to turn it into a json file to use in a zapier “Run python by code” block. However I am not sure how to turn the excel file to a json file. If it was a google sheets I could use the “Get many spreadsheet rows”, but there I can’t find an equivalent for an excel file in sharepoint. I cannot just convert to google sheets, because I do not have access to google sheets.

1301
Troy Tessalone
R
ronjabaumannBeginner
asked in Code & Webhooks
Getting data from nested array within API

Hey, I got a problem with gettin data from an external API in Zapier, which is more nested within the API. The data I am not able to get are the “Categories” under “JopOpening” (see screenshot attached), which are again having arrays of data, from which I would like to get the “name” Element and insert it within wordpress. This should just be added as text elements seperated by “,” within a metafield of the wordpress post. I also attached some screenshot of my zap, the second step was a try to reformat those data, but did not work. Does anyone have an idea if and how this is possible? Thanks a lot. Best regards Ronja

2895
Troy Tessalone
T
toiee labNew
posted in Code & Webhooks
To handle Shopify order data properties and variants, you can use Code by Zapier

I referred to the following article but could not solve the problem. Shopify multiple line items properties How to Rebuild RAW JSON for Code Blocks I tried Webhoo, App Extension, and etc. Finally I tried “Code” like below. const order_id = inputData['orderid'];const res = await fetch( 'https://YOUR-STORE-SUBDOMAIN.myshopify.com/admin/api/2023-10/orders/' + order_id + '.json?fields=line_items', { headers: { 'X-Shopify-Access-Token' : 'HERE IS YOUR API TOKEN' } }); const json = await res.json(); let line_items = [];for( const item of json.order.line_items ) { let prop = ''; for( const p of item.properties ) { prop += p.name + ': ' + p.value + "\n"; } line_items.push({ product_id: item.product_id, name: item.name, prop: prop, variant: item.variant_title });} output = { line_items: line_items }; This code takes a Shopify order ID as input data, retrieves the data via the API, parses the line_items and converts it to the format it wants. It then sets it as output data. The line_items key is

720
T
T
testing123New
asked in Code & Webhooks
How do I turn an Microsoft Excel file in Google Drive to a JSON file?

Hi I have an excel file located in my google drive. I want to turn it into that excel file into a json file to use in a zapier “Run python by code” block. However I am not sure how to turn the excel file to a json file. If it was a google sheets I could use the “Get many spreadsheet rows”, but there I can’t find an equivalent for an excel file in google drive.

911
Troy Tessalone
B
bfabianoNew
asked in Code & Webhooks
Access Fields That Have Dynamic Names

I’m using python code to get calendar appointments so that I can use the output fields in the next step. However, the output is making the date itself a dynamic field. So the responses when choosing from the drop-down will be like this for example: 11-29-2023 11-30-2023 12-1-2023 The problem with that is that since they will always be different, I can’t select them because the next time I run the zap, it’ll be new dates. So I’m not even sure how to concatenate them or really do anything at all with the data. Is there a workaround for this? For example using some sort of text merge field instead of the dropdown or doing something with the python code? Here are some screenshots. Notice how the variables that can be selected and used in the next step are named with the date. So for example if I run this next week, it’ll be new dates, which means they won’t pull in.

1455
SamB
Community Manager
K
Kirti DarjiNew
asked in Code & Webhooks
How to integrate any webapp to Zapier

I have web app and how people integrate my app data to another app let say any LMS and any third party App if user save data on my app same data will trigger to another app with field mapping is it possible and how we can achieve using zapier integration

380
K
C
CJMMacLawBeginner
asked in Code & Webhooks
Create Card in Basecamp 3

Basecamp 3 (now actually called Basecamp 4 but it is the same product) has a card table feature that is addressable via the API. However it is not addressable via Zapier to my knowledge. I see an older now closed thread of many others asking for this addition. Just wondering if there are any plans to address this at Zapier?

3626
Troy Tessalone
D
DarkRoomBeginner
asked in Code & Webhooks
Zapier is altering numbers pulled from the Printavo items column.

So as per the title, it seems as if Zapier is altering some numbers that I’m trying to pull from Printavo. This is how the numbers are arranged in Printavo (mind you we’re only worrying about the numbers in the Items column) and this is how the numbers are being outputted in Zapier. Is there any reason that this is happening? On other examples I’ve tried the Lineitems Attributes Total Quantities field has always been the one I’ve used to get the numbers I need and they have all been correct up until this point. Thank you in advance for the help.

290
D

Quick Nav

Get Help
How Do I
Troubleshooting
Code & Webhooks
Announcements
Zapier Events
Learn and Share
For Developers

New Answers

Popular Tags

Terms & Conditions