Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Code & Webhooks

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

  • 2,633 Topics
  • 8,639 Replies
Video

Code steps 101 (session from ZapConnect 2021)

  • 2
  • 1
2633 Topics
C
cothraw1New
asked in Code & Webhooks
Consolidate duplicate fields and aggregate corresponding values as outputs

Troy Tessalone,Is there a way to identify unique specific fields and then aggregate their corresponding values for records with duplicate specified fields and output that sum with the respective specified field? I’m horrible at explaining things so below is an example.I have a Get request that pulls all records from a view in Airtable and below is a sample Test Action:records:     1:          id: rec1234567890          fields:               Username: Sam               Value: 1     2:           id: recasdg654896          fields:               Username: Bob               Value: 1     3:           id: recaga54asg64          fields:               Username: Sam               Value: 1     4:           id: rec987654135          fields:               Username: Sam               Value: 1Basically I would want it to output Username: Sam ; Value: 3 and Username: Bob ; Value: 1 because Sam is in there 3 times, each time with a Value of 1 and Bob is only in there 1 time with a value of 1.

2929
C
T
tictagNew
asked in Code & Webhooks
Trigger a Microsoft Power Automate Flow using API call?

New to Zapier.Is it possible to initiate a Microsoft Power Automate flow based on an existing app integration trigger with the free version of Zapier?Existing Zapier App Integration > Event Trigger > Action > Power Automate flow runsI don’t mind building the action myself e.g. REST call to the Power Automate API endpoints.

14083
Troy Tessalone
michael291
michael291Builder
asked in Code & Webhooks
How to count values in Code step?

Hello, I am trying to count the quantity of several products in a line item order (WooCommerce). I.e. the line items in the order look like: Product 1 × 3, Product 2 × 1, Product 3 × 2 So: Product 1 was ordered 3 timesProduct 2 was ordered onceProduct 3 was ordered 2 timesAnd the result/output should be: 6 I am trying to count all quantities together. I already tried to solve this with the Formatter, but didn’t have success. Is it possible to do this with JavaScript or Phyton? Or is there another way? Thanks a lot for your support, M.

2584
michael291
J
Jan.WeskampNew
asked in Code & Webhooks
Is it possible to create instagram story if going live on twitch?

Is it possible  to create instagram story if going live on twitch?

831
Troy Tessalone
B
BrittanyNew
asked in Code & Webhooks
Extracting hours after day in a string using connector

I have data for hours coming in this format {Sun|07:00-13:00}{Tue|07:00-13:00}{Wed|07:00-13:00}{Thu|07:00-13:00}{Fri|07:00-13:00}{Sat|07:00-13:00} I need it in an output that I can map to 7 separate fields (Monday hours, Tuesday hours, etc.)I can’t just use a separator because not every day is always represented. I need someway to say Find SUN and give me back the next 11 characters and if it doesn’t find SUN, to give back blank or 00:00-00:00

162
Troy Tessalone
M
mcbNew
asked in Code & Webhooks
How to set a value in an array field

Hi,It’s probably a basic question , however I can’t find the solution for this.I’m using a webhook and want to update an array field with one single value.I’ve tried different variations, with or without brackets, quotes, etc, and still end up with this “Invalid array” error. A little help is welcome!

2312
M
Y
yasinyasoBeginner
asked in Code & Webhooks
Rest-API GET Request in Zapier / Json Output

Hi i was not able to make a test Get- Request from the Provider with following demo account informations curl -H "X-CLIENT-ID:9971557793fdf19f4bf96de5d48be46547bdc5ec" -H "X-CLIENT-SECRET:f5dd4d8943a51447ef63b061ccd0aab43e98e1f0" -X GEThttps://leads.around.technology/v201805/leads What iam doing wrong? in Zapier iam creating a new Zap i choose “Retrieve Poll”.How it should look like? I entered all information in the URL Section.Thanks a lot

5425
GetUWired
N
NoahMartin17Beginner
asked in Code & Webhooks
Looking for an example of a Vervante API (Wanting to set up a look up of shipping and order data)

Has any one worked with the Vervante API to retreive order status?  I am attemping to set up a GET to retrieve order info from vervante and wanted to know if anyone has had success with this and would be willing to share the way the set up the Zap.  ThanksNoah

612
N
A
a.mitchellBeginner
asked in Code & Webhooks
Multiple custom webhook requests - JSON formatting

Hi, all - I’m working on a Notion integration for a client that requires me to pass a complex API GET call, modify the return payload, and then pass that modified result into a PATCH call. (I’m trying to collect the body of one Notion page, then append it to another).Initially, I thought about doing one Custom Request for the GET, a step to modify the return payload, then another Custom Request to PATCH. However, I need the solution to be scalable as the size/length of what the GET returns will vary significantly.I settled on trying to do the entire thing via a Custom Code (Python). Here’s what I have so far:source_id = input_data['source_id']destination_id = input_data['destination_id']headers = { 'Notion-Version': "2021-08-16", 'Authorization': "REDACTED", 'Content-Type': 'application/json'}get = requests.get(f"https://api.notion.com/v1/blocks/{source_id}/children", headers=headers).json()new_payload = {'children': get['results']}patch = requests.patch(f"https://api.notion.c

3501
SamB
Community Manager
J
JayKBeginner
asked in Code & Webhooks
Calls returning data ID vs actual data

Hi, So I have an API call that I make to look to see who is scheduled. But instead of it it returning me the actual data, it returns me IDs. So when I really want to get Who: JohnStart Time: 09:00End Time: 12:00 Who: FredStart Time: 12:00End Time: 13:00etc Instead I get Who: 12355Start Time: 09:00End Time: 12:00  Who: 12356Start Time: 12:00End Time: 13:00etc Needless to say, to me, 12355 is meaningless to me as a human Thankfully I can call another API call that contains a reference of people and similar for places. So 12355 : John12356: Fredetc My questions is, how can I smash these together in Zapier? As what I want is the first thing, that tells me in English, who the person is!   I’ve made the zap work, by manually hard coding the data in the second API call myself using a lookup table.But this fails whenever we get new people added to the list.  I thought maybe I could dynamically populate the lookup table from the API, but I dont think this is possible? The other work around woul

544
GetUWired
A
Anonymous
asked in Code & Webhooks
Error when sending GET request to Stripe

Hi all,First time I’m trying to use webhooks by Zapier, and I”m running into a problem - I’m trying to retreive the ‘hosted_invoice_url’ paramter using the webhook, but i’m not sure what to fill in the ‘Query String Params’ fields in order to get the info.The authorization and url parts seem to work fine.I’ve attached a screenshot - any idea what am I doing wrong?Thanks. This is the error message I’m getting  

576
GetUWired
M
MattDeskROMNew
asked in Code & Webhooks
Post webhook to Google Cloud function via HTTP request

Hi all,I’m experimenting with zapier webhooks and wondering if anyone has successfully done a POST webhook to a google cloud function (http request). Use case is someone submitting a form along with a CSV file via airtable. When the new airtable record is created, zapier webook POST will send a json payload along with the CSV file to my google cloud function URL. The google cloud function has python code that will then manipulate the CSV file. When it is done, the updated CSV file and a confirmation will be sent back to airtable. Thanks. Matt

18825
M
F
freshmandeveloperBeginner
asked in Code & Webhooks
Nested ID

I am trying to integrate with the QuickBooks Time API, specifically with time off requests. The API docs are found here: https://tsheetsteam.github.io/api_docs/?java#retrieve-time-off-requests   Here is the code I have in Zapier. Note, I had to put a [] around the results to remove the “Results must be an array, got: object,” error.const options = { url: 'https://rest.tsheets.com/api/v1/time_off_requests', method: 'GET', headers: { 'Accept': 'application/json', 'Authorization': `Bearer ${bundle.authData.access_token}` }, params: { }}return z.request(options) .then((response) => { response.throwForStatus(); const results = response.json; // You can do any parsing you need for results here before returning them return [results]; }); Here is a typical output according to the API docs. Note this is sample data:{ "results": { "time_off_requests": { "1546922": { "id": 1546922, "user_id": 423, "time_off_request_notes": [96024],

17810
GetUWired
N
Noel CNew
asked in Code & Webhooks
Mailchimp interest group to Slack

I have a Zap working to send a message to Slack when there’s a new Mailchimp subscriber.  Would it be possible to include the Mailchimp Interest Group in the Slack message Zap? Thanks

171
Troy Tessalone
M
mmartelli2022New
asked in Code & Webhooks
How to use Zapier Formatter to generate GUID?

I need to create a unique customerID for each customer that is unique and looks like this:4025ad92-3515-4153-b621-54e7e18e3dfa Can anyone provide an example using the Zapier Formatter step. Thaks in advance!

12625
Troy Tessalone
S
SeanWilsonBeginner
asked in Code & Webhooks
Storage by Zapier Issue with clearing keys and values

Hi everyone,I have a very interesting use case that some others might have run into as well. The use case is for Hubspot contacts and deals and updating these in a third party app or other database. Here is the issue: There is no way to have a trigger that notices a change to hubspot associations. That is, if you change a contact associated with a deal - there is no trigger for that.A workaround I have created is to use the trigger ‘update on property change’ and use the property change ‘last modified time’. But now there are a LOT of triggers that are created. Every chat, conversation, email, phone call, everything is a trigger.So then I dealt with it in three parts:A trigger system that sends a webhook A catcher system that sorts and filters these triggers and passes on to the actual updater The updater that updates the database with all sorts of interesting things (looping through associated contacts to get their details and update them for example) but this is not a concern for the

8495
GetUWired
S
ShuggyNew
asked in Code & Webhooks
Dialpad message not saving to Google Sheets

I am trying to setup so that each time I receive a text message to a dialpad number that the text message is saved in a Google Sheet. Everything works EXCEPT there is never any content in the message saved. When I test the trigger the text always populates in the Sheet the way it should. however, whenever I run the Zap with a live text it logs everything EXCEPT the message. It’s driving me NUTS. Has anyone else had this experience and figured out a way round it?

543
Troy Tessalone
layki
laykiNew
asked in Code & Webhooks
How to transfer pictures and videos from my website to Instagram?

merhaba: benim wep sitep var  bu wep sitesinden instegrama yeni resim ve vidyo aktarmak istiyuromTranslation (by Google): hello: I have a web site I want to transfer new pictures and videos from this web site to instagram

291
J
M
matt_Beginner
asked in Code & Webhooks
Amazon SQS 403 permissions error

Spinning my wheels with support on this one. I’m getting 403 error when trying to connect to an Amazon SQS instance with Zapier, however I can successfully connect to the queue with Python and boto3.I don’t have access to the AWS instance as the queue is auto-generated and embedded in software I’m using, so I can’t see the permissions and SQS setup.So I’m stuck, with the application developers saying it works as I can connect to it with boto3 and Zapier support saying check my AWS settings, which I can’t access as it’s not my AWS instance…Anyone have any advice? If you run Zapier Amazon SQS connections, could you list you permission config so I could pass to the app developers?

605
Troy Tessalone
P
parawolf firmNew
asked in Code & Webhooks
Use API to add new Formstack submissions into Filevine?

Trying to API new submissions into formstack to filevine for my firm, looking to create new client contacts and create projects linked to the type of case and post case summary from answers in  formstack to filevine. 

291
Troy Tessalone
A
a.mitchellBeginner
asked in Code & Webhooks
Passing complex nested JSON via custom request

Hello! I am working on a Zap that will require me to make a quite complex API POST using nested JSON (the sample I’ve been working with in Postman is ~425 lines of code). Within that JSON request, I need to populate specific fields from a previous step in my Zap (some custom Python code that’s outputting a nested dictionary). I’m comfortable formatting the Python output to isolate the variables on their own, but I’m having trouble navigating the complex JSON code to place the variables where they belong, because of the small edit window and the lack of the ability to add spacing/tabs.Would it be easier to somehow create a template of text with MOST of the JSON code, and then somehow inject the variables within it? Is this something that really should be a custom built integration via the Developer Tools? Is there an easier way to map values in a heavily nested JSON request?Thanks in advance!

44935
christina.d
L
lolombibiBeginner
asked in Code & Webhooks
Formatter not sending Google Sheets all the data from the Webhook

Hi ,I am new to Zapier and I am working with The webhook app to pull data from my warehouse.  I am tring to get a simple list of model number and quantity available. The webhook pulls all data form the warehouse and is a large data dump.  When I use formater to pull the fields into google sheets I get all of my items but only three quarters of the quantity available field. My question is , does the formater have data limits?  if so can I send quires with the webhook to filter out the data that I actually need so I am not pulling in a massive amount of data? 

17824
L
S
ScooterNew
asked in Code & Webhooks
Automatically calculate end date for Google Calendar events

I have an app that returns start and end date data of a booking and as well as a duration field with text that includes the number of hours or days for the duration (ex. 4D). I would like calculate the end date for Google Calendar insertion which is in the format yyyy-mm-ddThhssss-0000.I can use the Formatter in advance of the Google Calendar portion and manually enter a value … like ‘+4 days’ to the start date field, but since it would be anything from a 1 to say 14 days, would really like to do something like a string conversion like: VALUE(MID(string),2) but the formula reference doesn’t seem to have any text formulas other than VALUE.There must be a way to do this … any suggestions? I do have hour durations as well, so would likely need to test with an IF state if I see 4H vs a 4D.Thanks. 

1611
robschmidt
J
jadamconnorNew
asked in Code & Webhooks
Posting File Attachments to Webhooks

There have been a few posts here that have gone unanswered in reference to whether file attachments can be posted to webhooks. I’m using Axios. The key is the formData: formData.append('fileName', e.target.files[0])axios({ method: 'POST', url: 'https://hooks.zapier.com/hooks/catch/xxxxx/xxxxx/', data: formData}) 

22482
J
K
Kev LawrenceBeginner
asked in Code & Webhooks
How to pass data from Webhook to run Javascript?

Hi allHoping someone with Javascript expertise can help me out. What I am trying to do is send the final output data into an Airtable field. I have done this in another Zap where the trigger is a webflow form and basically have tried to adjust the code to work with a webhook instead.I have the following setup:Trigger: Catch HookAction: Code by Zapier. In the input data I have the following; Then I have the following code:var hookBootcamps = inputData.bootcampvar hookPrenatal = inputData.prenatalvar hookPostnatal = inputData.postnatalvar hookMentalHealth = inputData.mentalHealthvar hookLifestyle = inputData.lifestylevar hookBodyTransformation = inputData.bodyTransformationvar hookBodybuilding = inputData.bodybuildingvar hookStrengthConditioning = inputData.strengthConditioningvar hookNutrition = inputData.nutritionvar bootcampvar prenatalvar postnatalvar mentalHealthvar lifestylevar bodyTransformationvar bodybuildingvar strengthConditioningvar nutritionif (hookBootcamps == "true") {

131216
K
Terms & Conditions