Skip to main content

Code & Webhooks

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

  • 2,404 Topics
  • 8,054 Replies
Video

Code steps 101 (session from ZapConnect 2021)

  • 2
  • 1
2404 Topics
Z
ZoBro23Beginner
asked in Code & Webhooks
Cannot send to Google Sheets: Parse Error

I am getting the above error. Here is my Zap link: https://zapier.com/shared/4a86e88543da34463ac31ffce5c710184c6832e1. Please help me.

1
Troy Tessalone
3 years ago
K
KinoquixNew
asked in Code & Webhooks
Accessing nested JSON array in Zap Webhook

Hello,I'm trying to get some fields from a JSON webhook to send to active campaign, but I'm not succeeding. I create a ZAP to run a JavaScript, but I'm not getting it, can you help me?My json Data: {  "type": "sale",  "event": "saleUpdated",  "sale": {    "code_url": "https://www.xxx.xxx.xxx",    "barcode": "123 1234 1234",    "expiration_date": "2021-10-02T03:00:00.000000Z"   "amount": 397, "proposal_id": null, "paid_at": null, "updated_at": "2021-09-29T17:27:53.000000Z",      "created_at": "2021-09-29T17:27:52.000000Z", "id": 16395,  },  "client": {    "name": “myname”,    "email": "test@gmail.com",    "cellphone": "+5519987654321",    "cpf_cnpj": “123.456.789-06","status" : "approved","age": "xxx"  }} I need get name, email, cellphone, cpf_cnpj fields on client key, and code_url, barcode, expiration-date, amount on sale key. Can you help me? My ZAP Flow:  

3
Troy Tessalone
3 years ago
S
slalonde00New
asked in Code & Webhooks
Zap to check site status, return value to Google Spreadsheet, run loop until all sites checked

hi, so i want to use zapier to create a zap that check if a website url taken from a google spreadsheet cell return an error when you try to visit them and then put a value like “To Verify” in the column to the right of it. But i’m not sure if there is an app that check if a website is still working or not. i also want that to repeat itself until the zap goes through a whole column. does somebody knows how to do this ? i have friday as a deadline to do this and i just started using zapier today, so i’m not sure what to use to be able to do this.

15
Troy Tessalone
3 years ago
M
Morkus
posted in Code & Webhooks
Uploading POST data as new file to DropBox

I created a web hook (instant) and copied the Zapier webhook URL to the program that will POST data to it.When I test that URL in that other application, I get a “status:success” back from Zapier.So far so good.However, when I try to set up the Zap, Zapier does get the POSTed request, but it appears to be looking for a QueryString even though this is POST data so the “file” referenced is empty. I don’t see any parameters I sent in the POST data to select from and the “Insert Data: Catch Hook” is not select-able in the DropBox setup.The format of my POST data (evaluated to work correctly at runtime) is this:"--X POST " &"--header \"Content-Type: text/plain\"" &"--data upload_file=" & Base64Encode(file_to_upload)I can’t use Zapier’s RAW hook since that’s limited to 2 MB.Suggestions to make this work?Thanks.

6
M
3 years ago
M
Morkus
asked in Code & Webhooks
URL streaming with webhook?

How exactly does Zapier get “notified” via a defined zap web hook when an app has new data? I don’t understand how the “new record” notification works since I only have a URL to that application to query data or whatever.Possible use-case:Say I want to be notified when there is a new record in MySQL. Then I want to take that record and copy it to DropBox or log some information in a spreadsheet.How does Zapier “know” there was a new record created via the web hook?

6
M
3 years ago
W
WAV-TechBeginner
asked in Code & Webhooks
Is there any Google Docs Line Item support coming?

Is there an easier way to include line items into our Google Docs templates than having to run custom scripts on everything? I’ve looked, and it seems to me that it would make sense if it was a default part of Zapier’s Google Docs actions, but no such luck. I have many sets of line items that need to be referenced in the template on what is already a very complex Zap, adding several more steps to break all of the data apart and utilize it seems like it should’ve been made unnecessary early on in Zapier’s lifetime. - Any developments coming? Does the dev team read these and make improvements? If nothing else, is there a leaner, more efficient way to handle this?

9
SamB
Community Manager
2 years ago
M
MarcKraakBeginner
asked in Code & Webhooks
Looking for a working example to update fields in Jira using rest api

I tried a lot of different options to update a Jira (Server) issue but it still isn't working. Can someone post an example?Current url I am using: https://MYURL/rest/api/2/issue/MYISSUEKEYI am looking for the right values for:Payload type: Json? Raw? Data? what to put where in which formatWrap request?Headers? I now use Content-Type application/jsonThe call now if being authenticated but complains about “fields” or “update” required, but I am sending it with the request. Maybe I have to put I somewhere else…?  

8
jayeshkumarbhatia
3 years ago
danielajk
danielajkBeginner
asked in Code & Webhooks
Webhook to register a User in WebinarJam dosen't work

Hello Zapians,I plan to register users for my WebinarJam sessions by using a Zapier Webhook, but I always get the an error.Here is my static test setup:I use this static values to make sure that the Webhook is working correct before I handover the data from my form. This is a straight forward static test, but it fails  Here is the error that I get:Here is WebinarJam API documentation:Register a person to a specific webinar – WebinarJam and EverWebinar documentationI am looking forward to get a few tips.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.

5
danielajk
3 years ago
J
JohannesBeginner
asked in Code & Webhooks
JSON error due to special characters in message body

Hey guys,I keep getting the odd error on my JSON zap, due to special characters in the body. Can Someone take a look and let me know what exactly causes the error and what I can do about it?data:{ "ticket": { "status": "open", "comment": { "body": "Hola, la semana pasada, por medio de la página Airbnb, alquilé el apartamento "with Wi-Fi and private pool" de su propiedad por el que aboné por mi banco la cantidad de X euros.\nHoy al entrar en su página para introducir mis datos y los de mi acompañante para que ustedes me enviaran los datos de la persona de contacto en Menorca, por mi ignorancia de inglés no sé que he hecho que les he vuelto ha abonar X Euro, cantidad que mañana será anulada.\nlos datos nuestros son:\name (name)\nname de nacimiento: 25/02/1922\nDNI: 1\ncaducidad: 03/09/2029\nname\n de nacimiento: 647982483","author_id": "1902817336834" } }} BestJohannes

1
robschmidt
3 years ago
C
CLABeginner
asked in Code & Webhooks
JS Code Regex to verify Email

Hi,Does anyone have some JavaScript that can verify a valid email address in the code module?I have the following - but I cant find the right way of performing the test, I’m not a programmer but I cant see why this isn't working? Any help much appreciated. At the moment it seems to pass everything through. if(inputData.eMail == null){ return{ rv: ""}}else {  const myEmail = inputData.eMail.replace(/\s+/g, '') // remove all whitespace from string  const RegExpConst =  /(?:[a-z0-9!#$%&\'*+/=?^_`{|}~-]+(?:\.[a-z0-9!#$%&\'*+/=?^_`{|}~-]+)*|"(?:[\x01-\x08\x0b\x0c\x0e-\x1f\x21\x23-\x5b\x5d-\x7f]|\\[\x01-\x09\x0b\x0c\x0e-\x7f])*")@(?:(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])?|\[(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?|[a-z0-9-]*[a-z0-9]:(?:[\x01-\x08\x0b\x0c\x0e-\x1f\x21-\x5a\x53-\x7f]|\\[\x01-\x09\x0b\x0c\x0e-\x7f])+)\])/  if(myEmail.matchAll(RegExpConst)){     return {rv: myEmail}  }  else return {rv: ""}} 

4
C
3 years ago
G
GiladBeginner
asked in Code & Webhooks
SurveyMonkey to Mongo - Dump the full Survey

Hi there, I’d like to dump the full SurveyMonkey responses that I’m getting (a filled survey) into a MongoDB as-is (almost as-is).The issue is that my survey has 30+ questions and I don’t want to structure them item by item but rather take the entire payload that Zapier got from SM and forward it to my Mongo-Instance “as-is”.Any thoughts?GB 

5
jayeshkumarbhatia
3 years ago
E
Eduardo BargaBeginner
asked in Code & Webhooks
How do I extract UTM from a URL?

Hello there to anyone please I need some help:I have this URL:https://www.okcars.com/?utm_source=mybusiness&utm_medium=referral&utm_campaign=okcars_mybusinesI want to extract the 3 UTMs and send them to the next step:utm_source utm_medium utm_campaign¿What utility, format or webhook should i use to get this 3 UTMs and send them separetly to the next step?Thank you in advance

3
E
2 years ago
A
allegraviolanteNew
asked in Code & Webhooks
Custom e-commerce platform - Integrating Klaviyo through Zapier

Hi everyone!We have our own e-commerce custom platform (no Shopify, Magento, Wordpress, etc.) and we are looking to integrate with Klaviyo for email marketing & automation.Instead of integrating with Klaviyo API we thought about integrating with Zapier API so that we can use Zapier to connect our e-commerce and Klaviyo as well as any other apps in the future.Has anyone done that? Do you have any recommendations?Thank you so much!Allegra

3
jayeshkumarbhatia
3 years ago
S
SPMHNew
asked in Code & Webhooks
Only trigger for certain memberships in PMPRO and add to GetResponse

Hi! I am trying to connect Paid Memberships Pro (PMPRO) with GetResponse using webhooks by Zapier. On the PMPRO side, I have activated the trigger by adding the webhook to “Changed membership level” option. My trigger is working on testing, However I want to filter such that contact is added to GetResponse if Membership Level ID is 1 (monthly membership) or if MembershipLevel ID is 6 (yearly), and deleted if Membership Level ID is 0 (cancelled membership). How should I set up the trigger and action for such a configuration?

1
robschmidt
3 years ago
F
FabienKBeginner
asked in Code & Webhooks
How to use data received from a webhook notification?

hi,I have set-up a Webhook trigger tested successfully and I need to use the data in the subsequent action:how is it done ? This is not clear from the tool where the data is made available to the action and how to use it.In my case it is to be used as path parameter within a GET /employees/{id} call of a custom app/action Thanks in advance ! 

1
Troy Tessalone
3 years ago
patrickmast
patrickmastBeginner
asked in Code & Webhooks
How to return value from webhook

I have a webhook set up in Zapier. Works great! The only thing is, how can I make the webhook RETURN a value? The only thing I get back from the webhook now is:{"id": "7560da36-be60-48aa-ba6c-b9f99c65bd98", "request_id": "6143458d-27b5-4283-a25b-8e65e7a18a90", "attempt": "6143458d-27b5-4283-a25b-8e65e7a18a90", "status": "success"}Thanks!

4
SamB
Community Manager
2 years ago
E
EstebanBeginner
asked in Code & Webhooks
Webhook PATCH: Validation 400 Error

I’m following Mackenzie Child’s tutorial on creating a Webflow membership program using Zap and custom webhook. I’ve followed it to the letter and looked on the forums to problem solve but I somehow keep getting a Validation error w. a webhook PATCH.  Here’s my ZapAnd Here’s the Webflow Collection it is Linked to If anyone has any ideas what I’m doing wrong I will send you a cinnabon. 

3
SamB
Community Manager
3 years ago
I
IcarusZapsBeginner
asked in Code & Webhooks
MYSQL New Line To CRM - Missing some entries

I have a zap that I thought would work but I feel like it’s missing some entries. Basically, I have my company DB. It consists of lots of tables. Order Table, Products Purchased Table, Sales Rep to Order Table.I created a VIEW that would pull from those three tables. This way I have all my data from the different tables in one lineI connected Zapier to the Database and selected the view as the “table”.  I did get a few tasks made from this but I feel like it’s missing many. Is there something I’m missing? Is it only grabbing the last line of the view or does Zapier check to see if it already collected the previous line? Should I even being using a View for this?Just trying to get my data into my CRM automatically instead of manually entering.

4
I
3 years ago
V
VarinderKBeginner
asked in Code & Webhooks
Create rows in google sheet from post request

I need to create multiple rows in google sheet in a single hit via zapier.Basically I need how to send request to zapier which can further use that to create multiple rows in google sheet problem I am facing is it is treating request a separate or first row is considered as request. For example, I use array in post to create rows: $new_arr=array();$new_arr[0]['contact']['Name']='test1';$new_arr[1]['contact']['Name']='tst1'; but Zapier take it as two request which allow me to create single row in google sheet.Please help in making proper request or recognizing multiple rows request in zapier.Thanks 

2
V
3 years ago
R
RamyBeginner
asked in Code & Webhooks
Format weird (nested) line items to proper line items

Hi!I used the webhook by Zapier and got the following data I wanted to put the data in columns using google sheet / create spreadsheet row(s) but Zapier is not finding the line items because of the weird format as shown below:  I guess I need to format it properly using Format by Zapier but I have not clue how to do this. I tried to remove the [] but it didn’t work. 

3
Troy Tessalone
3 years ago
C
CP_uyNew
asked in Code & Webhooks
Retrieve Facebook leads - Missing fields

We are trying to retrieve some fields like “Platform” but it is not coming from the Facebook lead Object.How can I debug the connection? I am the administrator of the facebook page.

2
C
3 years ago
M
michaellunsfordBeginner
asked in Code & Webhooks
Array converted to comma separated list -- `string.split` throwing off values

Webhook pulls JSON list. When I use javascript code to process the data received, the JSON list comes in as a comma separated list. In order for me to get it back into array form, I have too do a string.split(‘,’); However, some of the JSON fields contain commas! This is throwing off the array keys of the second value coming in.Is it possible to instead convert the array into a pipe-delimited list first?

1
M
3 years ago
S
SarathyNew
asked in Code & Webhooks
AMP form - redirect users to thank you page once form is filled

Dear Team,I am using a amp form with a post method that triggers a zapier webhook. it enters user infos into a Google Sheet.But Nothing happens once a user submits the form (Though the values are entered into the google sheet). How to redirect user to a thank you page after a successful Zap? Thank You

3
Troy Tessalone
3 years ago
R
rmjaskieBeginner
asked in Code & Webhooks
GET Asana custom field that is empty

Hey Community!I am learning a ton about webhooks and have learned enough just to be slightly dangerous.  I had a request from someone that manages our pipeline at our company.  We use an asana project with custom fields to manage that pipeline.The team member consistently is having to manually add placeholders in spots that the sales people fail to fill out. I’d like to create an automation that periodically checks the projects tasks for tasks that have certain custom fields that are empty.  So, in Webhook speak, I would like to GET those tasks.Once I GET those tasks, I would like to PUT a standard placeholder value in those custom fields.  Can anyone help with a good way of doing that?

1
Troy Tessalone
3 years ago
L
lcfigueiredoNew
asked in Code & Webhooks
Is there any way to update an item in monday.com when a contact is updated in Google Contacts?

Hello, I have already create a zap to create a new item, when a new contact is created inside google contacts. But I would like to know if:there is any way to update that item (already in monday)later if I update the same contact in google contacts? Thanks,Luis

5
L
3 years ago
Terms & Conditions