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,489 Topics
  • 8,354 Replies
Video

Code steps 101 (session from ZapConnect 2021)

  • 2
  • 1
2489 Topics
D
dropbeardanBeginner
asked in Code & Webhooks
Inbound email attachment expiry

Hi, I noticed that inbound emails linked to webhooks can process attachments as direct links to Zapier.I was wondering if anybody knew how long the email details and attachment link would be valid for?(e.g. if I store this link in my DB and try to access that file in a year from now, would it still work?)

2313
Troy Tessalone
4 years ago
N
NTXdigitalBeginner
asked in Code & Webhooks
Catchhook is showing disabled - Please Help

my zaps were working fine and now the catch hooks are shown disabled. how is this fixed?

1336
N
4 years ago
D
dpitchNew
asked in Code & Webhooks
Javascript Array For Loop with If Condition

Hi, I was wondering if anyone has a javascript code example they can share or tips on how to get this array For loop working including an “if” condition. I’ve done a lot of searching with no luck. I have 3 line items coming from a GET request step that I’d like to use a code step to convert to an array, iterate through the array with a for loop and If condition to remove rows of the array where one item in the array contains a specific value, then output/return the filtered array. The code does not return an error but the “if” argument doesn’t work - all rows are returned, and the output is a single object instead of individual objects for each row (to be imported to individual cells in Google Sheets). Any suggestions on what the correct method/syntax is here? Thanks in advance! Here is my code:   output = {} const newArray = inputData.activityName.split(',') // giving a title to the new fields newArray.forEach(activityName => output[activityName] = {}) inputData.activityName

8393
AndrewJDavison_Luhhu
4 years ago
I
Ian de RijkBeginner
asked in Code & Webhooks
Webhook Tests Successful but no results show in Google Analytics

I have some sales that went through on our website during a period of server maintenance which meant that the sales were not being tracked by Google Analytics. I have retrieved the data from our CRM and removed all personal details, formatted it in a Google Sheet and created a Zap to send the data in my Google Sheet to our Analytics account. When I test each of the three steps they all work, when I turn the Zap on my task history shows that the zap retrieved the data then sent it on as completed goals to the analytics account but when I search for the transaction IDs in Google Analytics there are no results. It’s my first time using Zapier so I’m aware that my error could be a rookie error of mis-entering one field or the entire Zap needs rebuilding. Not bothered which solution works but I could do with getting the problem solved quickly and support are so far un-responsive. 

1996
steph.n
4 years ago
R
ronaldo.witzelBeginner
asked in Code & Webhooks
Body (form-data) sending files

Hello guys!I need to do this Post in a Zap.But i don’t know how. Please someone can help me?   

1012
R
4 years ago
N
NARSNew
posted in Code & Webhooks
Feature Request - IF Condition is met, wait x mins and try previous step again

I don’t know if there is a way to do this now, but I cannot seem to find it.  I think it would be a great utility.  The logic basically already exists in different places but would be needed in a utility. This would combine:  Filter, Delay, and ReplayAfter an Action, If a Condition is Met (i.e. ID is NULL), Delay X Minutes, and replay prior step.  This can be limited to 5 times

851
Liz_Roberts
4 years ago
S
sweepbrightBeginner
asked in Code & Webhooks
issue with post Json webhhook

Hi there,I am having an issue with posting to a webhook URL. It seems the header get “filled” with a bunch of code but that stops the 3d party app from accepting our request. Any idea how to work around this ? tnx

412
Danvers
4 years ago
J
JimBeginner
asked in Code & Webhooks
How to Get the Task Payload from a failed task?

I asked this a while back (about 3 months ago) and the issue was “solved” and we put that in place, but it does not really work the way we want and I just now got tasked with it again, so I am back. I have several ZAPs that connect webhooks to CRMs and ticketing systems for clients. These are simple API integrations and have no error checking. This was done on purpose. When a ZAP fails, it shows in the ZAP history. I would like to use another ZAP to monitor those and should one be stopped with an error, then notify either me or my client with the payload from the webhook that triggered it.  The solution given to us three months ago does not give us what we are looking for. Zapier manager does “catch” errors, but …..we need access to the payload being delivered. Remember, a “webhook” always returns a success and we are using the webhook zap to simply things for our developers.  Per the Zapier Manager, this should trigger when an account encounters an error... … and it does. Below is the

4014
J
4 years ago
R
rikmarisBeginner
asked in Code & Webhooks
How to remove ctrl-char code 13

Hi everyone,   I have an issue to make an post api call to HubSpot. The value that i want to send gives this Invalid input JSON on line 16, column 17: Illegal unquoted character ((CTRL-CHAR, code 13)): has to be escaped using backslash to be included in string value Does anyone have any idea or tips or scripts to remove all these?

582211
R
4 years ago
R
Rhonda_BearStone_BrokerNew
asked in Code & Webhooks
Property Base's Back Office

We are a real estate brokerage that uses various third party softwares that are necessary to do our jobs.One of those (And maybe the most important one) is Property Base’s software called “Back Office” (Previously called “Back Agent”). I would very much so like it if I could create a new transaction in Back Office that automatically creates a deal in my Hubspot account with some of the info fields auto-filled. Also, if tasks could auto-populate into Hubspot when a new required item is needed in Back Office, that would be amazing.I’m sure this would help plenty of people in the real estate industry that use Back Office. Thanks to all that read this post!Up vote or thumbs up or whatever we do to  get this post in the hands of the fantastic Zapier developers.

1911
Seun Debiyi
4 years ago
R
Robin.HBeginner
asked in Code & Webhooks
Javascript with Monday.com

Hi, Im trying to make a Zap between Monday and Followupboss. Unfortunately Monday’s side dosen’t pick up the columns that I need to send over to Followupboss. I’ve managed to get a JSON query setup to pick up the values from Monday with this:query {  boards(ids: xxxxxxxx) {    items {      column_values(ids: ["telefon", "e_post", "plats",]) {        title        text        id      }}}} With this I guess I need to setup a Javascript with Code by Zapier but Im not sure how to move forward from here. Is Javascript the way to go? If so, I have never used Javascript and is this something that requires a lot of experience?

4208
Mercology
4 years ago
Ibanez1998
Ibanez1998Beginner
asked in Code & Webhooks
Creating a Foreach Loop in Code by Zapier to create objects from a CSV file

Hi,  I am importing a CSV I get from an email and parsing that CSV, but when I go to add the data as contact records in the Mojo app (a CMS system which by the way doesn’t appear to support line items) I get funky results and errors like State: FL, FL, FL, FL (Failed to add record, state abbreviations must be 2 letters only, yours has 12).  So…  I would like to use Code by Zapier to create a ForEach Loop to overcome this issue.  I want the CSV file to be read but only sent 1 line at a time.  I’m struggling with a way to do this.  Does anyone have any suggestions?  I can write to Google Sheets if absolutely necessary, but I’d rather just do this in code and remove additional dependencies.  I have enough dependencies already.

9483
Ibanez1998
4 years ago
T
TrendSurfersBeginner
asked in Code & Webhooks
Convert text

I would like to convert a text like this: ||key = xxxxxxx||pair=btcusdt||exchange=binance||type=entry||stopLossPercentage={{plot_0}} ||exchangeAccountType=futures||leverage=2||side=long||positionSizePercentage=20||orderType=market||signalId=btclongfutures||   to something like this:   {"key":"YOU_KEY","pair":"STRATBTC","exchange":"binance","type":"entry"}   So would nee to add { } for beginning and end, and change = for : , remove || and put “ between each existing words   Is this possible?

4936
T
4 years ago
D
dan-apNew
asked in Code & Webhooks
Airtable / Zap — Manually Running Javascript Returns 0 Records

I have the simple Javascript below which fetches a list of records from an Airtable view and it works just fine on my local environment. It also works fine when I am testing the Zap to fetch records.  When I manually trigger this script however it shows the following message and says it couldn’t find any new items. What I’m trying to do  1. In airtable I have a “flag” and all records show up in a custom view 2. All the flagged records are synchronized with another platform 3. The flag is cleared in airtable and removed from the view.  Thank you!       var settings = {  'method': 'GET',  'headers': {    "Authorization": "Bearer XXXXXX",  },};fetch('https://api.airtable.com/v0/XXXXXXXXXX/BASE/?view=VIEWNAME', settings).then(function(res) {  return res.text();}).then(function(body) {  body.toString();  console.log();  var jsonData = JSON.parse(body);  var output = [];      for (let i = 0; i < jsonData.records.length; i++)      {        if(jsonData.records[i])          output.push(j

2363
nicksimard
4 years ago
D
dannymoNew
asked in Code & Webhooks
Line items as array in code step?

Hey there,I’ve got a Zap that takes Shopify order data and routes that to an API, using a code step to properly format the data.I need to be able to grab the line item fields and use them as arrays in my code step. Currently, I’m using the Input Data fields, and separating the line items by comma in JS, but I’d like to know if there is a way to get arrays of the line items as a direct input.Separating by comma becomes problematic as soon as there are other fields like SKU or Variant, which might not have a value assigned, so Zapier removes the comma, and I’ll have an array of say, 5 products titles, and a SKU array that only has 4 items, because one of the products didn’t have one assigned in Shopify.

40083
nicksimard
4 years ago
C
colinpBeginner
asked in Code & Webhooks
getHours() and getUTCHours in Code by Zapier (JavaScript)

In a Code by Zapier task, how to I get the local time of a date/time provided in UTC. I am in time zone Europe/London. At the time of posting, owing to daylight saving, 8 AM UTC is 9 AM London time. But the following both return 8 when used in a Code by Zapier task.var myDateTime = new Date("2020-09-01T08:00:00.000Z");var utcHours = myDateTime.getUTCHours(); // returns 8var localHours = myDateTime.getHours(); // returns 8More generally, in the following, Code by Zapier returns the same for localHours and utcHours, always:​var myDateTime = new Date();var utcHours = myDateTime.getUTCHours();var localHours = myDateTime.getHours(); // localHours == utcHours, always 

10179
C
4 years ago
V
Vince R.Beginner
asked in Code & Webhooks
Return data in HTTP Response from a Webhook Post

Hello I am new to Zapier so forgive me if this is something obvious.  I am using a Webhook to post information to create a new Quote in our Saleforce system.  Once I create the Quote I get the ID of the new Quote.  How can I pass the ID of this new Quote back to the user so they can then add Line Items, Attachments, etc… using additional Zap Webhooks (which require the Quote ID to attach to the proper object)Unfortunately, every method I have tried will not return any data in the HTTP response, only the Successful receipt from Zapier.  How can I pass the ID back to the User that made the request so they can further build out the Quote and add the necessary attachments?Thank you for your attention 

21403
V
4 years ago
A
astha shuklaBeginner
asked in Code & Webhooks
webhook JSON format how to set

when i give {“name”:”something”} then the task will show in task history.if i give anyother thing on the place of name then the task will not show in task history  .how to setup the webhook’s  request payload format in zapier cli. 

1061
Danvers
4 years ago
Y
YFSupportBeginner
asked in Code & Webhooks
SquareSpace Commerce data via webhook

Hi friends, I have a Squarespace commerce account that I am trying to grab data from via a webhook GET. The flow currently is:New order in stripe Webhook to take stripe metadata ID for stripe order and connect to Squarespace Commerce API for full order data at that metadata ID Take order data from SS and map fields to airtable record When I am doing this in test with the Zap off, it is able to grab the appropriate data from the webhook and pushes it to Airtable. However, when the Zap is on and live, it doesn’t grab the actual webhook data. All the fields are blank. I took a look at the same Squarespace endpoint in Postman and it looks like the data it is grabbing in Zapier in the test is correct and the same JSON. When I contacted Support, they said that it might be actually a step nested further under “Result”, but I’m not seeing that in Postman, and adding “restult__” to my pills didn’t do it. Anyone have any ideas here? Happy to provide any other data that’s helpful. 

7664
Y
4 years ago
V
VinzNew
asked in Code & Webhooks
Convert JSON to CSV and then send by email

Hi all, I am pretty new to Zapier and I am trying to figure out if this kind of workflow is possible:   I have the end point of an API which I need to call and get a JSON as response I would like than to convert this JSON to a CSV I would like to email this CSV file this should be a recurring task (daily) and possibly I need to pass to the step # 1 a date dynamically.   I hope my question is clear and thanks a lot in advance to anyone who could help me,   -Vinz

32063
TimS
4 years ago
F
Frisse BlikkenBeginner
asked in Code & Webhooks
Transform "null" values into actual (placeholder)values

Hello there, I have a data sample from a webhook with custom values, now i try to convert this into a big data set (in google sheets), but whenever I do so (or try to adjust the data set before), the “null”-values disappear. So I would like to put the data (you can see below) exactly like this into google sheets:Now when I do it, i get this: Someone know a fix?

7297
andywingrave
4 years ago
K
kenitafarmsBeginner
asked in Code & Webhooks
Unsure how to use the Key field in Webhook

I have an URL that returns JSON, however I don’t know what to use as the Key. The data looks like this:{ "drinkName": "Bacardi Special", "glass": "Martini glass", "glass_url": "https://xxxxxxxxxxxxxx", "directions": "SHAKE all ingredients with ice and fine strain into chilled glass.", "measure": [  {   "amount": "1 1/2 fl oz",   "selection3": "Bacardi Carta Blanca light rum"  },  {   "amount": "3/4 fl oz",   "selection3": "Rutte Dry Gin"  },  {   "amount": "1/2 fl oz",   "selection3": "Lime juice (freshly squeezed)"  },  {   "amount": "1/4 fl oz",   "selection3": "Giffard Grenadine Syrup"  },  {   "amount": "1/6 fl oz",   "selection3": "Giffard Sugar Cane Syrup"  },  {   "amount": "1/3 fl oz",   "selection3": "Chilled water (omit if using wet ice)"  } ], "image": "https://xxxxxxx/contrib/stock-images/2016/x/xx/xxxxxxxxxxxxxxxxxxxx.jpg"}I am a complete rookie when it comes to webhooks so looking for some guidance. Thanks.

863
Liz_Roberts
4 years ago
F
Frisse BlikkenBeginner
asked in Code & Webhooks
Transform a big data sample --- Webook --> JSON --> Google Sheet

Hello there! I have 2 questions: How can I get nested JSON data from a GET zapier webhook? How can I transform this nested JSON data into a google sheet Background Information I am trying to find a way get data through a GET webhook, this can't be a “Catch hook” trigger because I can only use API Webhooks. I managed to do this but now I want to put this big data sample in google sheet in rows and columns. I see a lot of tools online to convert this with Nested JSON output, but I cant find a way to do it in Zapier, who can help me? If you know a better way to get the job done that's also fine, als long as I can import the data in a google sheet through a webhook.

209121
F
4 years ago
I
iseehowNew
asked in Code & Webhooks
Using code zap to get specific value to a webhook response

I am trying to get the alphanumeric value of my CRMs (pipedrive) custom field.  Pipedrive assigns a hash to a custom field and the values they send are numeric in the webhook as opposed to the alphanumeric value that was created for them.  You can use a webhook to look up the key pairs with an api call which returns the following. I know the ID but I need to return the label value using the code zap and i’m not sure how to do this. Thanks

2641
steph.n
4 years ago
L
labarrett22Beginner
asked in Code & Webhooks
Invalid Token

Hello,I’m creating a custom webhook zap with Spotify and I believe I put in a valid token, but I am receiving this error -  “Only valid bearer authentication supported". 

13937
Troy Tessalone
4 years ago
Terms & Conditions