Code & Webhooks

Hey there,I’ve got a Zap that takes Shopify order data and routes that to an API, using a code step to properly format the data.I need to be able to grab the line item fields and use them as arrays in my code step. Currently, I’m using the Input Data fields, and separating the line items by comma in JS, but I’d like to know if there is a way to get arrays of the line items as a direct input.Separating by comma becomes problematic as soon as there are other fields like SKU or Variant, which might not have a value assigned, so Zapier removes the comma, and I’ll have an array of say, 5 products titles, and a SKU array that only has 4 items, because one of the products didn’t have one assigned in Shopify.

In a Code by Zapier task, how to I get the local time of a date/time provided in UTC. I am in time zone Europe/London. At the time of posting, owing to daylight saving, 8 AM UTC is 9 AM London time. But the following both return 8 when used in a Code by Zapier task.var myDateTime = new Date("2020-09-01T08:00:00.000Z");var utcHours = myDateTime.getUTCHours(); // returns 8var localHours = myDateTime.getHours(); // returns 8More generally, in the following, Code by Zapier returns the same for localHours and utcHours, always:​var myDateTime = new Date();var utcHours = myDateTime.getUTCHours();var localHours = myDateTime.getHours(); // localHours == utcHours, always 

Hello I am new to Zapier so forgive me if this is something obvious.  I am using a Webhook to post information to create a new Quote in our Saleforce system.  Once I create the Quote I get the ID of the new Quote.  How can I pass the ID of this new Quote back to the user so they can then add Line Items, Attachments, etc… using additional Zap Webhooks (which require the Quote ID to attach to the proper object)Unfortunately, every method I have tried will not return any data in the HTTP response, only the Successful receipt from Zapier.  How can I pass the ID back to the User that made the request so they can further build out the Quote and add the necessary attachments?Thank you for your attention 

when i give {“name”:”something”} then the task will show in task history.if i give anyother thing on the place of name then the task will not show in task history  .how to setup the webhook’s  request payload format in zapier cli. 

Hi friends, I have a Squarespace commerce account that I am trying to grab data from via a webhook GET. The flow currently is:New order in stripe Webhook to take stripe metadata ID for stripe order and connect to Squarespace Commerce API for full order data at that metadata ID Take order data from SS and map fields to airtable record When I am doing this in test with the Zap off, it is able to grab the appropriate data from the webhook and pushes it to Airtable. However, when the Zap is on and live, it doesn’t grab the actual webhook data. All the fields are blank. I took a look at the same Squarespace endpoint in Postman and it looks like the data it is grabbing in Zapier in the test is correct and the same JSON. When I contacted Support, they said that it might be actually a step nested further under “Result”, but I’m not seeing that in Postman, and adding “restult__” to my pills didn’t do it. Anyone have any ideas here? Happy to provide any other data that’s helpful. 

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

Hello there, I have a data sample from a webhook with custom values, now i try to convert this into a big data set (in google sheets), but whenever I do so (or try to adjust the data set before), the “null”-values disappear. So I would like to put the data (you can see below) exactly like this into google sheets:Now when I do it, i get this: Someone know a fix?

I have an URL that returns JSON, however I don’t know what to use as the Key. The data looks like this:{ "drinkName": "Bacardi Special", "glass": "Martini glass", "glass_url": "https://xxxxxxxxxxxxxx", "directions": "SHAKE all ingredients with ice and fine strain into chilled glass.", "measure": [  {   "amount": "1 1/2 fl oz",   "selection3": "Bacardi Carta Blanca light rum"  },  {   "amount": "3/4 fl oz",   "selection3": "Rutte Dry Gin"  },  {   "amount": "1/2 fl oz",   "selection3": "Lime juice (freshly squeezed)"  },  {   "amount": "1/4 fl oz",   "selection3": "Giffard Grenadine Syrup"  },  {   "amount": "1/6 fl oz",   "selection3": "Giffard Sugar Cane Syrup"  },  {   "amount": "1/3 fl oz",   "selection3": "Chilled water (omit if using wet ice)"  } ], "image": "https://xxxxxxx/contrib/stock-images/2016/x/xx/xxxxxxxxxxxxxxxxxxxx.jpg"}I am a complete rookie when it comes to webhooks so looking for some guidance. Thanks.

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.

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

Hello,I’m creating a custom webhook zap with Spotify and I believe I put in a valid token, but I am receiving this error -  “Only valid bearer authentication supported". 

I need to get raw JSON from a Webhook GET request.  I’ve tried various options, and Zapier always parses the JSON, rather than allowing me access to it. (I’ve tried a simple webhook GET, and a webhook Custom Request GET)  I was able to get to the raw JSON in a different zap that used “Catch Raw Hook” as the trigger, but that won’t work for this new zap that I’m building.  Ideas?

Hello friends! I want to send an API request and need to include date in the DateTime format. I am not sure what does that mean, but let me know if Zapier formatter can convert a date into this format? Or is there any alternative? 

Hi,Our business is migrating from an old exchange server to gsuite.  A number of users have saved old emails to the old file server in .msg format.  These .msg files are now saved in google drive and I’m looking for a method to convert these files to a format google recognises or convert them to a .pdf format.I can create a ZAP to find the .msg file (I think), but Im looking for a means of converting the file once found.  Any ideas or suggestions, please?Hope that makes sense.CheersSimon

→ I am using python in zapier and I want to debug … it seems some particular data aren’t being passed through… so i wanted to use a test … print(“I AM HERE”) … to test how it returns as an output.   → i see the output from a ‘print’ call should be returned to my  runtime_meta but I don’t see my data there   Help please and Thank you, Emeka

Hi, so we created a private CRM tu use for our business and we need to connect to Facebook Ads in order to store our leads there instead of Google Sheet.Is it possible to use Zapier to connect the 2 ?Thanks you.

I’m connecting several apps to Asana. In Asana I have set my project where these integrations occur as read only to limit users ability to change the data in Asana. The issue with this is that it’s going to take more time to assign tasks to users since the users will not be able to assign themselves to tasks.I can easily pass URL links that include the Asana Task ID into the Asana task description field. Would there be a way to make it so that if a user clicks one of these URL links it actually triggers a Zap? The idea being that I could have one URL for assigning themselves to a task. Another option would be a URL that would move the Asana task from one section to another.The simple way to get this done is to just have the URL point to a form that needs to be filled out and once the form is submitted it would trigger a Zap, but I want to avoid forcing the user to have to fill out a form. It would be better if it was just a simple clickI have been researching webhooks but I’m not famil

Hi there,in one of my zaps I connect to hubspot, pull data and send it with a zapier webhhok to an Endpoint. of our CRM system. Now - how can I make sure that utf-8 is used in the post action. Currently the receiving endpoint receives “Mller” in stead of “Müller” with a special character.  The name is correctly shown in Zapier but somehow not correctly posted by the post action. Helpful hints are really appreciated!Florian

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

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!

How to using zapier webhook to get data from sendy api.   Thanks to everyone for help. Thank you

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.

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

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!

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