Skip to main content

Code & Webhooks

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

  • 2,369 Topics
  • 7,953 Replies
Video

Code steps 101 (session from ZapConnect 2021)

  • 2
  • 1
2369 Topics
R
RBaileyBeginner
asked in Code & Webhooks
Trouble creating spreadsheet-style-formula to compare data. Error: “The app returned "Invalid Syntax: Only numeric values are allowed"

Hi.  I am trying to take some data from some output of two people and compare to see if they are the same person.  I need to compare the name in addition to the birthdate.  I am using a formatter with spreadsheet-style-formula to do it but I am getting an error that says “The app returned "Invalid Syntax: Only numeric values are allowed".  I am not sure how to format the input to get the result I need.  Can someone help?  I am pretty new to this syntax.  I can’t tell if it needs quotes or not.  I have tried both ways.Formula=IF(AND(Rhonda Bailey=Suzy Q,01-08-1972=10-11-1990), “true”, “false”)Thanks,   

5
R
2 years ago
L
luoxinBeginner
asked in Code & Webhooks
I use webhook to get the BODY: string, which cannot be broken down and written to Google sheets.

I use webhook to get the BODY: string, which cannot be broken down and written to Google sheets.Using formatter, please describe exactly the steps, and how to set up google sheets, has been bothering me for a long time. Thank you!

4
L
2 years ago
raehill
raehillNew
asked in Code & Webhooks
How to Search for a Google Contact when you have a large number of contacts (timing out)

Hi Everyone,Issue: When creating the action “Find Contact” for the App Google Contacts, it times out because I have 13,000 contacts. Zapier Support says this is a known issue with Google Integration but did not offer a solution.What I’m Trying to Do: Create a Zap that Creates or Updates a Google Contact when a record is created/updated in my database (Crelate ATS). I first want to search to see if the Contact already exists in Google Contacts but I can’t because the Zap times out.Any suggestions/workaround?Thank you!

1
Troy Tessalone
2 years ago
A
AmirKatzNew
asked in Code & Webhooks
Updating module in Zoho CRM

Hello,I want to create a Zap with the event “Create/Update Module Entry in Zoho CRM”,in which when two specific fields already exists, it will update the module instead of creating a new one.The problem is that when I define 2 “duplicate check fields” it checks if only one of them exists, and then updates if it does. I want the zap to update the module only if BOTH of the fields in a specific module are the same as the ones entered.Is there a way to do that? Thank you.

1
Troy Tessalone
2 years ago
E
EddieNew
asked in Code & Webhooks
Split Line Items in Shopify Order by product

I created a zap so that I can output shopify order information to a spreadsheet, but when multiple products are purchased, they are combined into one line.In the example in the attached image, five products named Test and three products named Test2 were purchased, and the output to the Google sheet is summarized in one line.I would like to change this so that the output is for each product purchased.Does anyone know of a solution?

2
jesse
2 years ago
M
monitoreo_hauscomBeginner
asked in Code & Webhooks
How to get a Token ID from a Get request from a Webhook by Zapier

I hace to send contact info to SAP, and for that was created a Webservice.To be able to POST info into the platform previously I need to GET a Token ID.And as I´m checking the webhook It only retrieves body data. Is there a way obtain this information from the HEADER? 

6
jesse
2 years ago
I
IvanStaykovBeginner
asked in Code & Webhooks
How to create a Code Step which would split multiple input strings?

Hello all, I am trying a Code Step which would split multiple input strings.But the issue I have is the following.In this case I have 3 sets of data. So each key string contains 3 values, delimited by “,”The code however returns correctly the 1 value, and does not return the other values. Any ideas what I am doing wrong?

1
I
2 years ago
V
vanessaBeginner
asked in Code & Webhooks
Sharing a Zap containing action Looping by Zapier

Hello, I am about to publish my app on Zapier and I’ve come across an issue regarding a Beta Action: the Looping by Zapier. The issue is that I cannot share the zap since it uses a beta action. Does it mean I will not be able to use that action even when my app will be public?  Are Beta Actions not allowed in ‘production’??

3
Troy Tessalone
2 years ago
J
JcabshearNew
asked in Code & Webhooks
Charge a customer's credit card

Use case: End of day I have a Google Sheet with a list of all orders that were sent out that day. I would like a solution that allows me to tokenize cards and then charge each customer on the list through a loop.I cannot find any integrations that allow me to securely store a customer’s credit card or charge it later via an API trigger. Please help

2
Troy Tessalone
2 years ago
T
TextPowerCEOBeginner
asked in Code & Webhooks
Trigger an API call when an email arrives

I need what would seem to be a simple Zap but it’s over my head.  I need to trigger an API call when an email arrives.  I have to take a variable that will appear in the Subject line of the email and then send it to a predefined URL using predefined credentials.  If you can assist I’m willing to pay.  

6
T
2 years ago
A
anirbansheeNew
asked in Code & Webhooks
API endpoint trigger

We are currently running FB ads and adding leads to MySQL dB via Zap.  We wish NOT to give permission to live dB to the external world. Can we give an API endpoint instead of dB credentials

2
jesse
2 years ago
J
JBoozeNew
asked in Code & Webhooks
Pass Gravity Forms URL query string data and generate email link using Webhooks

Hello -  I”m trying to achieve the ability to pass Gravity Form formatted query strings into an Email that is sent to the user to then be clicked on. I’m thinking this may be possible via Webhooks.  Can anyone provide any insight to how I may achieve this.   Objective: When the user submits the webform via Facebook browser Interface my intention is to send them a query string link to their email that way they are forced to view the landing page on their standard web browser after clicking, instead of FB browsers.  Reason for this is because I’m using affiliate tracking solutions that I need to drop a cookie on to their standard web browser.  I would be including the affiliate id in one of the gravity form fields along with the Name and Email.  This will allow me to track and eliminate the user having to enter their information twice.  Steps: User submits form with Name, Email, and Affiliate ID in fields Query sting data is sent to zapier  Query sting data upends a destination URL in a

2
jesse
2 years ago
T
Taylor RNew
asked in Code & Webhooks
Searching Salesforce with webhook from Intuiface given 2 parameters

I was wondering if it is possible to search Salesforce using Zapier to find an object that equals two parameters given and return information about that object. For example, I want Intuiface to send a webhook to Zapier to search both phone number and picklist type value and if and only if both are true be able to receive that person's name and other field parameters from Sa;esforce to display on Intuiface. If one is true, I would be interested if Intuiface can get that info to let the user know which field was matched.

3
S
2 years ago
C
carls_123New
asked in Code & Webhooks
Webhook GET request “already exist in the system” error

Hello everyone,I am trying to connect via zapier: facebook ads leads with a CRM that does not appear in the list of apps, but I have a url of the CRM that I can use as a webhook.I use the GET method and put the full URL, I show screenshot (the URL is not placed due to privacy of my client, sorry). then when I click continue I get this error…  I am new and any help would help me a lot, thank you very much. 

1
Troy Tessalone
2 years ago
G
Greg DVBeginner
asked in Code & Webhooks
Create a new record in Airtable based on product quantity

Hi I would like to create a record in Airtable for each single item my customers order on my Shopify website.But I don’t know how to create a loop based on the quantity that appears in the line items.As an example, let’s say my customer has ordered 2 of the same t-shirt, I wold like to create 2 records in Airtable with quantity = 1 for each. Thanks a lot for your help!

2
G
2 years ago
T
TitineBeginner
asked in Code & Webhooks
"Missing value" error but value is shown in data out overview

Hi,I made a zap for a client with the connection of a ‘private’ app with webhook. The app’s name is Plug&Pay. It’s a check-outplatform and I send a discount code from that app to Zapier. In my Zap history I can see in the ‘data out’ overview that this discount code is visible. The discount code is a field I can select in the Zap filter.But when I run a test and filter on that value in my Zap, I get ‘missing value’ and the zap stops running. Did anyone ever encountered this? How can I solve this?Thanks in advancePS: see attachment

4
T
2 years ago
J
Jeff-KNew
asked in Code & Webhooks
How to update subscribers in Klaviyo with custom properties when they opt-in?

Hello all. I just started using Zapier. I’m having problems getting my first zap to work. I’m trying to update a customer’s marketing email opt-in status at Klaviyo. I have a webhook set up in Step 1 and and action in Step 2 to only execute if the Topic is customer.update. Step 3 is where I’m having problems. I have a Update Subscriber in Klaviyo configured with the action set to Update Subscriber but I’m not sure what data to use in the Subscriber field. I’m also not sure how to pass the Customer Marketing Opt In value as it’s not a field like Email. Do I use the Custom Properties?

13
Troy Tessalone
2 years ago
M
MattATSoCalYouthSportsBeginner
asked in Code & Webhooks
Scheduling Email Reports Based on Google Sheets Cells

I want to send myself a weekly report (email) based on a true false column in my sheet. I want to have anyone whose last appointment is within the next 2 weeks put in this report so i can make communicating with them easierI want it to trigger on a Monday at 6amloop through the sheet and pull all of the true rows into an email to me with the data from the customers 

3
Troy Tessalone
2 years ago
A
andrew.waitesNew
asked in Code & Webhooks
How to remove tags in NationBuilder using loop

HI, I am using the NationBuilder “Update a Person” action and it will not remove tags. It will add tags but will not remove them from NationBuilder. (Don’t ask me why)I have found another action that is to “Delete a Single Tag” from a NationBuilder person. I can compare data in/data out on the “Update a Person” action to see if the tags match (hopefully, might get caught out by order but … later)So, is there any way, with a zap, to cycle through those 2 lists of tags to determine what tags are missing from the input list that are on the NB output list. Those tags are the ones I would then need to (one by one) delete.So I need 2 things:A list comparison to find the missing tags and An iterator to perform a delete tag task on each missing tagOkay - so now I try with Zapier Looping…Read the list of tags from NB (returned from update), loop through each tag, if not in the list of tags from Amalfi then delete the tag from NB… should be simple.The loop (line item or text? - both seem the sam

4
SamB
Community Manager
2 years ago
C
CalleTheDontKnowGeekBeginner
asked in Code & Webhooks
Sending user information with GET request

Hi  well, bit new to this but: i want to send user information into whova with webhook. got that to work all good. problem is when sent over again all the information is sent once more to whova. the user information updates again. Not good since user might have updated their information in Whova becomes a lot of tasks since it senda everything over and over again. 2000 users again and againgSo, any idea how i can make it just send the latest added users from the database since the last update?

11
christina.d
2 years ago
C
C123New
asked in Code & Webhooks
Webhook POST embed to Discord not including all information for the request

I have created a custom request to POST embedded messages to Discord, as per the below:Webhook is setup and working now after using Headers: Content-Type application/json to remove the bad request errorBut the message in discord only displays at the content line - can anyone help

4
C
2 years ago
T
Thomas GeibBeginner
asked in Code & Webhooks
Webhook question field responses showing as containing “No data”

Our website has a web form that then sends the information to our CRM (Podio) for whatever reason one of the questions show the data the first time after deleting and reinserting the zap pull. But after the first time that one question zap will show “No Data”  This is also happening for the same question on our slack. We have questions with the same format that it always is showing data for any advice or suggestions?

3
Troy Tessalone
2 years ago
A
alexadagostinoBeginner
asked in Code & Webhooks
Paths "ReferenceError: detailedErrMsg" monday.com error

I have built a pretty elaborate zapier (proud of myself) with the help of many here. It launched, worked beautifully - the record was uploaded to Monday. BUT, it for some reason errored (even though everything was executed).  The logic worked beautifully all the way down to the path. It executed the path I wanted. But I cannot find what the actual error is? It just saysReferenceError: detailedErrMsg is not defined What is odd is that the data WAS actually sent to monday and it worked... So not sure what the issue is?FYI: I have the highest possible version of Zapier and Monday so is not a “plan” issue. Any ideas?

7
SamB
Community Manager
2 years ago
T
TinyEmailBeginner
asked in Code & Webhooks
How to add header response in webhook to AMP Forms

Hello,we have an issue calling  a Zapier Webhook from AMP form. After submitting the data the zap finishes its work with success, but as an response we receive CORS error.Contacting our service who builds for us AMP forms, they said that Zapier must add next response header "Access-Control-Expose-Headers": "AMP-Access-Control-Allow-Source-Origin""Access-Control-Allow-Origin": $origin"AMP-Access-Control-Allow-Source-Origin": $ampSource"Access-Control-Allow-Credentials": "true"Is it something that Zapier Team can implement on their side? Thank you in advance! Best regards,TinyEmail. 

2
T
2 years ago
R
RaphaeBeginner
asked in Code & Webhooks
Integration with real estate portal

Olá, preciso de uma ajuda. Não consigo criar uma conexão entre um portal de propriedades e o wordpress. O Zapier não possui o aplicativo diretamente do portal de imóveis (Zap Imóveis) e não sei qual ferramenta utilizo para gerar a URL xml para concluir a integração.

3
R
2 years ago
Terms & Conditions