Code & Webhooks

Hi I’m recieving a webhook from a lead link in GoogleAds:  Now I need to extract the “user_column_data” as usable data. Such as:  User_column_data : User Phone:+1234567                                  User Email:test@example.com                                  First Name:Firstname                                  etc.    This is so I can use it to send in a post message.    Anyone that has any idea?   /Karl   

I am trying to build a webhook zap where it posts to my CRM agencybloc and i have the following items that needed to be added.   No parameters should be in the URL or querystring. The body of the request must contain the security credentials, as well as the method-specific parameters. For example: sid=mySID key=myKey lastName=Doe firstName=John I am trying to figure out how i do this on the webhook function as i am trying to take information from formstack and push it to this webhook. I have the formstack intgration down as that was easy, but i am having trouble with building the recieving webhook.

I have a Zap where I import a CSV and then later down the line I want to filter out some rows depending on the values within that row.Example CSV:id,name,color1,john,red2,mary,blue3,sam,redIn this CSV, I only want to proceed with people who are tagged as red. I tried to accomplish this using the "Run JavaScript" app, but even though I return an array of data, it seems to only return 1 row. Does anyone know how to do this? Thanks.

Hi,it's been several times that I got stuck with this one: I don't understand how to output Line-Items with a Code step?Is it even possible?For example:I build Line-Items from a JSONIn these Line-Items, I would like to remove some of them, based on various criteriaThen output Line-Items and use them in a further stepHere is something I tried: But, on a further step, I don't get Line-Items but separate values:So, how to manipulate Line-Items into a Code step and get Line-Items as the output?I feel like I'm missing something...Thanks,AlexPS: more explanation on the "why".I got my data from a Typeform entry in which I can get b

Hello Zapiers!In our system we generate orders and we want to let to our customers to automatically generate few docs related to such orders. All docs has templates (customisable) and we need to fill different templates with dynamic data.For example, we need to put {ORDER_NUMDER} {ORDER_DATE} {CLIENT_NAME} {ORDER_SUM} to different docs, like: contract, invoice and report. Contract is Google Doc, Invoice – Google sheet, and report is Google Doc too. Then we need to generate PDFs from this docs and email it all to few emails.1. Is it possible to solve this complicated logic with Zapier?2. How would you do that? (any advice or examples, if possible)Thank you so much!

Hi - I've got 3 line items (Item, Qty, Price) from WooCommerce via the WooCommerce-Zapier extension.I'm trying to output these in columns with a header (Item, Qty, Price), but I can't see how to do it.The line items come in as 3 separate comma delimited listsAny clues or pointers anyone?Many thanksSeamus

Hey everyone, I recently created a reverse lookup step for HubSpot when you have a contact's phone number and want to get their name and email and thought I would share with the community. The request is limited to 1700 contacts due to Code by Zapier's 10 second time limit.The main guts of the code is a recursive fetch sequence for paginated responses (A common occurrence if you are using Webhooks to get data from APIs). You could take this sequence and augment it to handle what ever paginated response you want from an API. Have fun!!const obj = {    users: 'no user found'}let newUsers = await go();for(var x in newUsers){    for(var y in newUsers[x]){        if(newUsers[x][y].properties.phone && (newUsers[x][y].properties.phone.value.indexOf(inputData.phone) >  -1)){            let firstName = newUsers[x][y].properties.firstname ? newUsers[x][y].properties.fir

Hey there! I have no idea what I'm doing wrong when trying to send a webhook to Airtable. I've tried this in Postman and it works perfectly, but I just keep getting the following error when I send via Zapier - Can anyone help? Postman cURLZapier set upAny help would be amazing! I can't troubleshoot what Zapier are sending in the console, sadly

Reading documentation for mindbody. This is beyond my level of understanding, so I'm asking for someone more experienced than myself.If I'm understanding this correctly, I can create a webhook step with required information and create a user. Or am I over simplifying? MINDBODY Public API V6.0 Thanks!

Hello!Recently I've started the automation of my checklists. I used to have them as .csv files and used Todoist import functionality, but now I want them to unroll by a simple click. To accomplish this, I've set a Zap consisting of three steps: Webhooks by Zapier (thank you, @PaulKortman), Code by Zapier (using technique from here) and Todoist.Code from Zapier returns an array of 12 objects which then should transform into tasks created in Todoist. The problem is that several requests for tasks creation fail due to "Too Many Requests" error.Is there an option to create several tasks with a single request or some other method to avoid this issue?

I have a trigger, which returning ar array of custom fields. each element of the array have a two keys FIELD_VALUE and FIELD_NAME.When I am mapping these fields in an action there are only two field available :FIELD VALUES ==> comma(,) separated values of all custom fields key FIELD_VALUE, similarlyFIELD NAMES ==> comma(,) separated values of all custom fields key FIELD_NAMESI want to convert all of the fields in a key:value pair. So the value of FIELD_NAME will be a key and value of FIELD_VALUE will be a value.I have tried to use code by zapier but it is not working as expected:Here is my JS code:var names = (inputData.names).split(',');var v

Hi!👋 Recently in https://community.zapier.com/discussion/comment/884 discussion, I started thinking that making Zaps is similar to programming. There we have a maxim that suggests minimizing duplication as much as possible. Most of the time you will find it under DRY (don't repeat yourself) or OAOO (once and only once) names.How do you avoid logic duplication in your Zaps? I've already discovered two possible ways:Decoupling several Zaps with different beginnings and the same ends. You can do it by splitting Zap into two: unique start + Webhook as first Webhook + same end as last (thank you, @PaulKortman for the initial idea).Moving your Code by Zapier to external API and reusing it between different Zaps in case of necessity.Do you have any other optimization ideas?

Let's say I get a weekly email that has a table in it, the table has lots of information in the rows and I want to copy parts of that into a Google Sheet and Trello card. Or I receive a multiple items from a webhook - a different number of items each time - and want to run a Zap action on each of the items in the hook. Can anyone think of a way to do this using a code step rather than the old 'add everything to Google Sheets' workaround?

Zapier doesn't have an action to delete files in Google Drive. Would it be possible to achieve this using Code?

One of the many useful features of Zapier is the "Delay For" step.However, one of its limitations is that delays must be a minimum of 1 minute.In a lot of situations this might be too long, so I got to thinking about a way around this.Once again, a Javascript Code step can help.Reading the documentation, one of the limitations is as follows:Code steps can run for up to 10 seconds before your zap will throw an error. So, what if we just create a Code step that does nothing for 10 seconds, then returns a dummy result?Well, this does the job:

Is it possible to flatten line items within a Zap?

What is best way for us as Experts to get support on behalf of our clients using Zapier?I have a client who needs to request an increase in a code action that is hitting the 10 second limitation. I didn't realize the code blocks have 10 second limitations. I assumed they were 30 seconds like all the other connectors.What would best way for me to help them get a request into Zapier support that would actually turn out in getting that request granted? Should I submit it on their behalf? Or submit it from their account?

For example: Someone uses their full name in one field instead of first and last in separate fields. If you then want to split it and define the first word (name) as the first name and any other words in that field as the last name, you can do that using some JavaScript code.Option 1First name’s the same no matter what, so we can define it herevar firstname = nameArr[0]var lastnameCheck if there’s more than 2 elements in the array (i.e. a middle or multi-stage name)if(nameArr.length > 2){Remove the first item in the arraynameArr.shift()Then join that modified array up with a space in between the elementslastname = nameArr.join(" ")} else {But if there’s less than two (i.e normal name) then return the last name as you werelastname = nameArr[nameArr.length - 1]}output = [{firstname, lastname}];Option 2Here is another alternative:var full

I am trying to trigger off of a Facebook Pixel due to not being able to embed it within another app. I did try to use the JavaScript code from the Pixel in a code step within my Zap, but it didn't work.Is this possible? Are there any other workarounds?