Skip to main content

Code & Webhooks

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

  • 2,398 Topics
  • 8,046 Replies
Video

Code steps 101 (session from ZapConnect 2021)

  • 2
  • 1
2398 Topics
brianswichkow
brianswichkowBeginner
asked in Code & Webhooks
Does anyone know how to convert markup text for Slack?

Hey All,I’m pulling source data from an app that only outputs markup text. The markup text has zero or many links and needs to be formatted for Slack’s annoyingly specific markeup language.For example, changing all links in a body of text from this:[Text to make into a link](http://www.zapier.com)To this:<http://www.zapier.com|Text to make into a link>I’ve tried using Formatter > Extract Pattern, but that only works for the first match (this thread suggested this is possible with a code block which brought me here).Thanks~Brian

5
brianswichkow
4 years ago
T
trevorSkyCivBeginner
asked in Code & Webhooks
Phantombuster to Snov.io Zap question

Hi Zappers,I am wanting to fully automate my LinkedIn prospecting and emailing process to cold leads. I use Phantombuster to Automatically Connect with Linkedin users Scrape those users’ emails using Phantombusters discovery service (max 20 emails per day)I want to automate the import of my leads information into Snov.io, so that I don’t need to constantly import CSV files. Setting up the Zap between these two apps, I don’t have an issue filling out or mapping the information, but I am getting errors because the JSON object contains every single email/lead that I had scraped in the most recent Phantom that was run. Other than changing my Phantom to run just a single email per launch, is there a way to get around this? Or are Zaps only able to handle one set of information each run?

8
PaulKortman
3 years ago
F
funguyNew
asked in Code & Webhooks
Connecting to an app through an API

Would anyone know how to implement what this website is asking?https://help.agencybloc.com/hc/en-us/articles/115003836391#section3 I have the API key and SID key. I’ve tried a few different things as well as asked support. No luck yet. I’m grateful for any advice!

1
andywingrave
4 years ago
J
JuphyNew
asked in Code & Webhooks
How to trigger my subscribeHook when Zapier zap is on

I completed the Subscribe Hook settings for receive hook url which is triggers zap. I think I have to make a change in Perform section for this Subscribe hook request to go whenever the Zap is On. But I have no idea exactly how to do it.

1
nicksimard
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

1
steph.n
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.

3
Ibanez1998
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

3
nicksimard
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

3
AndrewJDavison_Luhhu
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?

5
T
4 years ago
J
JohnBBeginner
posted in Code & Webhooks
How to Loop Over Items Using Zapier Code

I found there to be a handful of tricks when I was trying to do this so I made a video:   

2
J
4 years ago
M
MC-PresenceBeginner
asked in Code & Webhooks
Stripe Connect

I need to connect a form to a Stripe account to make a subaccount via Stripe's Connect API. I can easily add a Stripe account here, I just need to now interact with Stripe to make the Connect account. I think I need a custom workflow, and I'm not sure where to look to find out how to manually integrate with an API. Thoughts? Thanks!

3
ikbelkirasan
4 years ago
A
ahmedmohamedBeginner
asked in Code & Webhooks
Response to the Source from Zap with Webhook Trigger

Hi guys, when i have a zap of more than 1 step, and the trigger is Webhooks by Zapier with Catch Hook. When i send the response to the webhook, it provides back to the source this kind of payload response   {"id": "548299ef-bb3a-4769-885a-fb001407c049", "request_id": "5f197542-b118-4fe9-9b45-f1e10b4ac710", "attempt": "5f197542-b118-4fe9-9b45-f1e10b4ac710", "status": "success"}   Is there a way that the connection of the Zap is kept alive and rather than providing the response up, it provides the response of the last step of the Zap?   Thank you, Ahmed

3
ikbelkirasan
4 years ago
N
NitinNew
asked in Code & Webhooks
How to schedule a catch hook within Webhooks by Zapier?

Scheduling a catch hook seems impossible in Zapier. When i select scheduling while creating the Zap, i have options to select GET, PUT and POST hooks. But no option to select a Catch hook. Is there any way i can achieve scheduling a catch hook?

1
ikbelkirasan
4 years ago
S
simpledcpBeginner
asked in Code & Webhooks
Converting an image to Base64

I’m trying to pass an image from a URL to a POST Webhook. The API endpoint will only accept an image payload in Base64. Looking to use Code by Zapier to accomplish the translation, but I’m coming up short. Has anyone managed to devise a similar solution?

5
S
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.

21
F
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

3
TimS
4 years ago
M
MarianNew
asked in Code & Webhooks
App with Webhook and REST -> Zoho Campaigns

Hi there,   I have an app which I would like to integrate with Zoho Campaigns and I hope that this works with Zapier, maybe you can help me answer the question IF and maybe also HOW that works; The app called pretix (https://www.pretix.eu) creates orders to events and people should get the option to subscribe to our newsletter. pretix offers webhooks to notify when a new order is placed but delivers only the order code with the hook. It also offers a REST API with all the stuff you can expect from an API including access to all order details. What I’d like to do is pretix to trigger Zapier via Webhook to extract data via REST API from pretix and push these data into Zoho Campaigns. Does that sound realistic or have I understood Zapier wrong?   Thanks in advance! Regards, Marian   edit: There are Zaps for Zoho Campaigns.

1
nicksimard
4 years ago
J
Jakub ZiolkowskiBeginner
asked in Code & Webhooks
How can I create an array of JSON objects?

Hello! I am creating a zapier integration for our invoicing software. I am however not sure how can I create a nest an array of JSON objects inside a jSON. "invoice": { "seller_name": "name1", "seller_tax_no": "123456789", "buyer_name": "name2", "buyer_email": "some@email.com", "buyer_tax_no": "987654321", "positions":[ {"name":"Product 1", "tax":23, "total_price_gross":10.23, "quantity":1}, {"name":"Product 2", "tax":0, "total_price_gross":50, "quantity":3} ] } I have no problem adding fields, I am however stumped with “positions”. I have tried making it a Line Group Item, but when I tried inputting some test data I realized it gets turned into a regular array of strings, rather than an array of JSON objects. "positions": [ "name: product 1", "vat: 23", "total_price_gross: 100", "quantity: 1" ] Is it possible to make it work in either zapier dev

4
J
4 years ago
K
kpiercyBeginner
asked in Code & Webhooks
Code Steps Ran thousands of Times

Hello, I have 9 Code steps all with the same structure as below, but with different input data and variables being used. I am triggering this zap with a webhook from TallyFy. When I triggered this zap yesterday, it proceeded to run the entire zap 6,400 times. I am thinking it may be due to not having a Callback in the last Code step. The Code step presented below is the first of nine that are identical other than inputs and variables, in order to pull out only the human readable values I need in order to store them into a document for client digestion. Can anyone give me some idea as to why the zap ran 6,400 times and how to implement the Callback in the structure below, if that is indeed the problem? HUGE THANKS.     inputData: addrSvcs: id: 1 required: True selected: True text: Return Service Requested value: None id: 2 selected: True text: Address Service Requested value: None id: 3 selected: True text: NCOA value: None   JavaScript Code: var addrSvc = inputData.addrSvcs.ma

2
K
4 years ago
T
TchinkatchukBeginner
asked in Code & Webhooks
Webhook and custom get request

Hi ! This is nice on a webhook. But how could I do the same with a custom get request ? My workflow is :  Webhook POST on api to get a Bearer GET to retrieve Data Send raw data to another solution. I can not do the last step as I can’t find a solution to retrieve raw body from the 3rd step. Do you have a solution ? Thanks

5
T
4 years ago
J
joesciNew
asked in Code & Webhooks
Reddit -> Discord via Webhook not firing, no errors given

Hey, I’ve set up a Reddit → Discord via webhook zap that is supposed to fire when a new post is found from certain search terms. (subreddit:soccer) (url:streamable.com OR url:streamja.com OR url:clippituser.tv) (Arsenal OR Brighton OR (Manchester City) OR Southampton OR (Manchester United) OR Liverpool OR Everton OR Wolves OR (Crystal Palace) OR (Sheffield United) OR Tottenham OR Spurs OR Leicester OR Villa OR (West Ham) OR Norwich OR Bournemouth OR Burnley OR Watford OR Chelsea OR (Leeds United)) The webhook uses POST to send the following via the Discord webhook API The following is sent with application/json headers { "embeds": [ { "title": "{{Title}}", "url": "{{PostURL}}", "description": "\n{{Content}}\n\n", "color": 28056, "thumbnail": { "url": "{{ImageURL}}" }, "fields": [ { "name": "-", "value": "Posted at {{PostedAt}} by [{{Author}}](https://reddit.com/user/{{Author}})", "inline": true }

1
PaulKortman
4 years ago
C
Chris LNew
asked in Code & Webhooks
Get Raw Json From Webook Post Response

I have successfully set up a “Custom Request” - Webhook Post request. I want to access the entire raw data response, but the response is parsed by Zapier. How can I get the entire unparsed json passed to further steps?

1
steph.n
4 years ago
M
mayerzineNew
asked in Code & Webhooks
Instagram API: Fetched source code seems to have changed(?)

Hi! I have a zap that was working for a long time, but it appears it’s running into errors now. My code is below. The first part about captions you can ignore - it just strips away hashtags from the post. The second part pulls the source code for the page and extracts an image using a regex pattern. But I no longer get a match for my regex search. But when I run that snippet on my laptop, it works fine. import redelim = '\n.\n.\n.\n.\n.' # five periods in a row on new linesdelim_2 = '.\n.\n.\n.\n.'caption = input_data['caption']if delim in caption: caption = caption.split(delim)[0].strip()elif delim_2 in caption: caption = caption.split(delim_2)[0].strip()else: caption = caption.strip()# get image from linkthe_link = input_data['the_link']response = requests.get(the_link)text = response.textimg = re.search('"og:image" content="(.*?)"', text).group(1)output = [{'caption': caption, 'img': img, 'cap_length': len(caption)}] Any suggestions? Thanks!

1
steph.n
4 years ago
C
CalyhreNew
asked in Code & Webhooks
Null filter / webhooks

Hey, did you managed to get this working? I’m stuck with a webhook answer like this: { "data": { "completed_at": "<Some date here>" }, "updated_from": { "completed_at": null, }} The whole `updated_from` is not there if the update does not impact the completed_at. The only option here is to filter on `data__updated_from is blank` but then it’s triggers for way more than I would like.

2
steph.n
4 years ago
F
FrancisBeginner
asked in Code & Webhooks
need some help to finish a Pyhton script !

Hi !  I created a first Python code to try to organise datas for a table. It works well so I am able to organize datas in the right order. The pb is that I need to split this big table in sub tables grouped by the value DOSSIER and i don’t know how to do that ! If someone gets an idea !  Many thx Francis import datetimedates_obj = []for i in input_data['dates'].split(','): dates_obj.append(datetime.datetime.strptime(i, "%d/%m/%Y").date())event_list = list(zip(input_data['events'].split(','),input_data['dossiers'].split(','),dates_obj,input_data['descriptions'].split(','),input_data['qte'].split(','),input_data['avocats'].split(','),input_data['types'].split(',')))sorted_events = sorted(event_list, key=lambda item: (item[1],item[2]))out = []for e in sorted_events: out.append({'event': e[0],'dossier': e[1],'date': e[2].strftime("%d/%m/%Y"),'types': e[6],'description': e[3],'qte': e[4],'avocats': e[5]})return { "events": out, }  

3
nicksimard
4 years ago
Terms & Conditions