Skip to main content

Code & Webhooks

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

  • 2,370 Topics
  • 7,955 Replies
Video

Code steps 101 (session from ZapConnect 2021)

  • 2
  • 1
2370 Topics
W
wafflessunBeginner
asked in Code & Webhooks
Commas Prevent Running Line Itemizer on a Nested JSON Object

Trigger: PhantomBuster LinkedIn Profile Scraper (Zapier integration, not a Webhook)Desired Action: Insert fields from a nested JSON object into the next stepProblem: I can’t access data in the nested “jobs” array the same way I can in the first-level “resultObject” array show below:Specifically, the output I’d like to achieve would look like this:Vice President, OperationsABC CompanyJun 2020 - PresentDirector, OperationsXYZ CompanyJan 2015 - Jun 2020etc. I’ve spent hours pouring over Zapier documentation and this forum and have tried many things none of which work:Line itemizer (format utility):  comes very very close to doing what I need here, except for this incredibly painful problem with commas inside the line items. Any/all of the fields inside the jobs array could contain commas and completely break everything.  Code block to parse a nested JSON object -- I don’t see a way to pass the output from PhantomBuster into the code block to be parsed, but even if I did … I pasted in a fu

8
Troy Tessalone
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
Relick
RelickNew
asked in Code & Webhooks
Test works but not automatically pulling leads

Hi allI have created a zap from a lead supplier’s API to fluent CRM.When I test the zap, it does pull test data through which is visible in FluentCRM. However, it does not seem to be active, despite lots of leads coming in regularly by email.I have given days and there has been no improvement and the zaps are switched on. Any ideas how i could troubleshoot this please?Thanks in advance.

8
AugustineJulien
1 year 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

8
jesse
2 years ago
Z
zap-ss-adBeginner
asked in Code & Webhooks
Problem with using nested line items

Hello, We have a use case were we have an order which contains order lines, and each of those order lines may or may not have 1 or more “applied discounts” in a nested array. For example, here is a snippet from the output order:products:1:id: 79code: abase_total: $10 applied_discounts: 1: amount: $1 2: amount: $22:id: 80code: bbase_total: $5 applied_discounts: 1: amount: $53:id: 80code: cbase_total: $10 applied_discounts:When we use the loop from lines functionality, it would show the above input value as:[“1”,”2”],[“5”],nullHowever, when we actually loop though the lines, it treats it like “1,2,5,”. As you can imagine, this creates problems, because we only have 3 products, and each discount can easily become misaligned with it’s correct pairing. Ultimately, we want to add values together for each product to get a total discount amount, then pass those values to line items, which seems to be achievable with some JavaScript. However, when we use JavaScript, the input value seems to not

8
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

8
jesse
2 years ago
A
ApolloTimBeginner
asked in Code & Webhooks
send webhooks error

Our first time using Zapier, we have used two other products with the JSON payload below and it has worked fine but fails in Zapier.  With zapier using the same json we get invalid request.  Any reason why the json below would be an issue in zapier? { "planId": 1, "primaryEntityAttributes": { "_ZipCode": "12345", "_EmailAddress": "2@2.com", "_FirstName": "tim", "_LastName" : "jag", "_PhoneNumber" : "123456789", "_LiquidCapital" : "100K", "_City":"Tampa", "_StateLeadForm":"florida" } }

8
Troy Tessalone
2 years ago
V
varun_VNUSPLBeginner
asked in Code & Webhooks
Webhook multiple attachments

I am following https://help.zapier.com/hc/en-us/articles/8496288690317#1-add-a-webhook-trigger-0-1 to create a webhook which will be triggered from our app. The challenge is that there are multiple attachments which could be sent as “File” object in POST request and we don’t know how many could be passed; but when I tried in Zapier, it only gets 1st file.Can any one help me with achieving our requirement? We need Zapier to receive multiple attachments in one parameter, like in below image, we are passing 2, but Zapier receives only 1.ThanksVarun

8
Troy Tessalone
1 year ago
santoshnuli
santoshnuliNew
asked in Code & Webhooks
How to read file attachments from Microsoft Outlook Connector webhook

From Microsoft Outlook Email Connector webhook , we are getting file attachments as below in JSON body result.Please help in how to read the “hydrate” content type , how to decode and how to download attachments ? files:    hydrate|||.eJx1jkFPg0AQhf_LnInBwlog8QCCpE1BUWyVC6HLVrbAbssuNrThv7vUXp3LJO-9781cAHMmCZO5HA4EHHBBA8qELBgmOS3BMSxk3FsIaYB7IXnbC9JdDdt-mNv6TIMCY96rhpuIdDTXYEdJU-asaKfSkvzkO9oQ1V2fiu5bgHOB28Gb3hJZcVUA1VB2heSduFNPiCpoC9o89wxLypnKbXtWKkDxZHIWE-K6Ue366yrbrGmm9iqN9CytZRxGs4jq6CXM6GqzQHGY6NHsy4zTZRsnXuhex9uKY-APklhvS-OcbMxPLAPsnTzfx83--KqH7wfCvf0pTM3h448JIsX94wfrJ6OxVegRxnH8BaIFcsA:1pljxf:b9cSwgZLNZIVZA2uYM4Vo5MH0VY|||hydrate  

8
M
3 days ago
Aylee
AyleeBeginner
asked in Code & Webhooks
Failed to find a file in Google Drive: Error from halted execution: Nothing could be found for the search.

Hello, I want to automate Twitter posts by using OpenAI and using Content from my Google drive. Unfortunately I stuck on the Google Drive part.This is my current process:  Here the Details for Step 2-4:  All tests been successful until this point, but the test for step 5 failed and I don’t understand why:  It says “Failed to find a file in Google DriveError from halted execution: Nothing could be found for the search.”  Can someone please help me? Regards Aylee

8
Aylee
1 year ago
RashidatO
RashidatOBeginner
asked in Code & Webhooks
How to set up Webhooks workaround for ClickUp

Hi @mari12h7, @RashidatO and @CardManc! 👋 We’ve got all of you added to the list of affected users so we’ll be sure to send you an email notification as soon as it’s resolved.@RashidatO - For the workaround Zsambi and others have mentioned I believe you’d need to create an automation in ClickUp that runs for the same events as the ClickUp trigger that’s erroring. This would need to be set up to send a webhook (use the Webhook Call option for the Automation) through to a Zap that uses a Catch Hook (Webhooks by Zapier) trigger. That way ClickUp can still send the desired information over to Zapier without running into that same error. Hope that helps! 🙂 This post was split from topic:  Hi @SamB!  Thanks so much for replying!I’m very new to creating webhooks, so I have some follow-up questions. So when I go into automations in ClickUp am I just entering the web hook URL from Zapier or do I need to also be specifying which information I want to send?Then, when I’m in Zapier, I created

8
RashidatO
1 year ago
R
RahulGuptaBeginner
asked in Code & Webhooks
As I am trying to create a product on Bigcommerce using Sheets with the help of Webhooks, I am confused about what fields to fill in.

API PATH: https://api.bigcommerce.com/stores/**********/CLIENT ID: ga4r71*******223ad2un**************gACCESS TOKEN: qsnx04u**********8***cool I have these all but I don't know what to fill in which field

8
R
1 year ago
sgee
sgeeBeginner
asked in Code & Webhooks
ReferenceError: fetch is not defined

Hi! I’m building an Action and trying to use `fetch` via code mode. However, when doing so I receive a “ReferenceError: fetch is not defined”. In doing some research, it appears that Node.js needs to be v18 in order to use this. Is this correct? Is there a workaround?const options = {method: 'GET', headers: {accept: 'application/json'}};fetch('https://api.portal.scanifly.com/api/v1/designs/', options) .then(response => response.json()) .then(response => console.log(response)) .catch(err => console.error(err)); 

8
sgee
1 year ago
Siddharth Basker
Siddharth BaskerBeginner
asked in Code & Webhooks
Error handling Mechanism and Calling of REST Service

Hello Team, I have recently started exploring Zapier and wanted to know the answers for these following questions:How do we generate specific errors such as Bad request, Unauthorized (400 and 401 for example )and is there any specific error handling mechanism we can use to handle that error. How do we connect to a 3rd party URL for instance if I have a URL that is from SAP and want to fetch it into Zapier(https::datafromsap.com) , which component can I utilize to perform the mentioned action.Please do guide me on the same , thanks in advance, looking forward to the replies Warm Regards Siddharth  

8
Troy Tessalone
1 year ago
onlinedaniel
onlinedanielBeginner
asked in Code & Webhooks
401 - 'Invalid API Key' error when updating a Shopify order via Zapier webhooks

Context: I followed this Zapier tutorial for updating an order in Shopify everytime a customer purchases a certain product.My issue is that when I test the webhook I get this error:[API] Invalid API Key Or Access Token (Unrecognized Login Or Wrong Password) This is my webhook setup:  And these are my API keys in Shopify: I also enabled all the permissions from Shopify, in case that was the reason why I get this error, but still no success.Also, when I’m logged in Shopify and I try to access manually to the URL I provided to the webhook (i.e. https://00d…etc…/orders/4911250604276.json), I can access it no problem.Why my webhook doesn’t want to work?

8
MohSwellam
1 year ago
T
testste1Beginner
asked in Code & Webhooks
Prevent slack from escaping characters in text provided by previous step

So, currently we’re facing problem where zapier processes the markdown text to format for slack. And the result of this formatting put like this in message text.But when the message is being sent the characters for link < >are actually escaped before sending to slack API and getting like this into message:As a result the links in slack channel are broken and doesn’t work. Is there any workaround to it?

8
Troy Tessalone
2 years ago
PamTurner888
PamTurner888Beginner
asked in Code & Webhooks
Need to add new opt ins (FormSpree) to Active Campaign via Webhook, and I'm stuck.

I’ve started the process of linking FormSpree & Zapier with a webhook.But I’m not clear on what I need to do to actually add the new names/email addresses coming in, as a subscriber on a list in ActiveCampaign.  I can’t find this info anywhere!Thanks for any guidance!  

8
PamTurner888
1 year ago
Sandra Hoffmann
Sandra HoffmannZapier Expert
asked in Code & Webhooks
Webhook Digistore24

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.Hi fellow experts, could you help me with a webhook?I want do create a voucher in digistore24.Here are the API basics: https://dev.digistore24.com/en/articles/3-api-basicsThat’s the documentation about createVoucher: https://dev.digistore24.com/en/articles/27-createvoucherI used Webhook - POSTBut I get the error that the first parameter data[code] is missing.I don’t see what I am doing wrong. Could anybody give me a hint? CheersSandra

8
Sandra Hoffmann
2 years ago
B
bigcatcreativeBeginner
asked in Code & Webhooks
How to separate data from Raw Webhook?

I have the option to pull a raw webhook from my affiliates list. It comes in as one string and I want to extract the First Name and Email. Yes, raw webhook is the only option I have right now. I know there’s an extract email feature in Zapier but I really need the name too and can’t figure out how to get that. This is the data I’m getting: a:3:{s:6:"f_name";s:5:"XXXXX";s:6:"l_name";s:8:"XXXXXXXX";s:5:"email";s:20:"XXXXX@XXXXXXXXXXXXXX.XXX";}Any help appreciated!This post has been edited by a moderator to remove sensitive information. Please remember to remove any personally identifiable information prior to posting as this is a public forum. 

8
B
2 years ago
E
ericAtCulinaryFlowNew
asked in Code & Webhooks
Possible to authenticate a webhook using 'Webhooks by Zapier' Trigger

Howdy!  I am new to the Zapier community and really exited about the technology.  That said, I would like to authenticate the zap I setup using the ‘Webhooks by Zapier’ type.  From what I have read, these types do not appear to support any type of authentication.  To do this, it looks like I will need to create my own Zap App and upload it as a Zap.Is this correct?  I ask in case this is wrong and I would LOVE to be able to use an existing type as our needs are not that advanced.Thoughts appreciated!

8
E
2 years ago
jeffernst
jeffernstBeginner
asked in Code & Webhooks
How do I turn multiple field values into a comma-separated string

I’ve seen a ton of articles and posts on turning a comma-separated list into separate fields, but none on the opposite. I have text values in five different fields that come from columns in Google Sheets. I want to turn them into a comma-separated string to feed to my API. The challenge is that there isn’t always a value for all five fields, one or more can be empty.So if I simply do Field1Value, Field2Value, Field3Value, Field4Value, Field5Value in the zap, and Field1 and Field 4 are blank, the result is extra commas like:, Field2Value, Field3Value,, Field4Value.Any ideas? 

8
Troy Tessalone
2 years ago
earlywork_team
earlywork_teamBeginner
asked in Code & Webhooks
Find Invoice in Xero step not finding invoice

Hey @jayeshkumarbhatia! 👋I managed to get things working so I could continue building out this workflow! As a recap I’d like to use the invoice number that we found using the JS code to find an invoice in Xero and then send it out.When I use the JS output in the “Find invoice in Xero” step, the invoice can’t be found. However when I hardcode it and input “INV-0018” directly it works. Looks like there might be a discrepancy in the formatting?Do you know how I might be able to figure out what format Xero is looking for in the invoice number field and how I could convert the JS output to match that?  

8
JohnathanTripp
1 year ago
A
alexadagostinoBeginner
asked in Code & Webhooks
Monday & Zapier: Returning Column ID so I can update a Column

Here’s what I am trying to do: I have multiple outside apps such as Acquity + Twliio that I need to use zapier to be able to update certain fields or give an update.For example, when someone reschedules or cancels their appointment, I need to update the column in Monday of what happened. The only way I can see to update is by having the Column ID. But I cannot figure out how to return the Column ID so I can update a specific item. What I have done so far is be able to return the column with all the data. But there is no column ID (I even added in Monday Column ID but it does not show in zapier). Anyone have a solution for this?  

8
Troy Tessalone
2 years ago
S
s.tBeginner
asked in Code & Webhooks
How to keep response JSESSIONID

I want to authenticate to a certain SaaS using Zapier → get information.The JSESSIONID is issued in the authentication phase, and the JSESSIONID is required in the information acquisition phase of the next step.However, I don't know how to take over the JSESSIONID included in the response of the authentication phase to the next step. Please tell me how to use the JSESSIONID of the response in the next step.

8
S
2 years ago
R
rayvoxNew
asked in Code & Webhooks
Converting JSON into individual items

Hi All,I have some JSON that I’m trying to convert into individual items so that I can use the parts in different ways later down the line in Zapier. The data is formatted as follows: {"Title": "Content","Subtitle": "Content2","Name": "John Smith","Date": 1999,"Description": "Long form text area","Summary": "Long form text area","Percentage": 80%}How can I convert each item into an individual component that I can use in other ways? Ideally to also split the heading from the content (i.e. to also split “Title” from the “Content”.  Any help is appreciated. Thanks.

8
R
1 year ago
Terms & Conditions