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.

Data Structuring

Questions about structuring data when building integrations on the Zapier platform.

  • 13 Topics
  • 23 Replies
13 Topics
C
Chipl71New
asked in Data Structuring
Defining SearchOrCreate from Search and Create methods in a Resource

I have a resource with a key of artistResource and a noun of ‘famous painter’.  My resource has a list, search and create operation.  In my main index.js file I would like to have a SearchOrCreate action that leverages the search and create operations from my artistResource resource.  Unfortunately I get a validation error with any combination of references to the resource’s operations.Error:== PropertyApp.searchOrCreates.artistResource== Messagerequires property "search"== PropertyApp.searchOrCreates.artistResource== Messagerequires property "create"== Links== PropertyApp.searchOrCreates.artistResource.key== Messagemust match a "key" from a search (options: artistResourceSearch)== PropertyApp.searchOrCreates.artistResource.key== Messagemust match a "key" from a create (options: artistResourceCreate)Version 1 - index.js: searchOrCreates: { [artistResource.key]: { key: artistResource.key, display: { label: 'Find or Create an artist.', description: 'Find o

171
Troy Tessalone
27 days ago
K
knarikBeginner
asked in Data Structuring
Use the data from previous zap in the next one by one click.

I have two zaps one for create client and one for client project. After the created client action I have the data in my create project action. How can I have all the data in one field. Is there some dynamic field or some field  or function to retrieve the data from the previous zap in my next zap. I dont want to use client name, email, etc, separately in different field for my project. I need the whole data at once in one click.Thank you.

192
K
30 days ago
A
Andrew MarcroftNew
asked in Data Structuring
Testing /validating and tidying/ensuring correct format for email address

Is there a built in way in Zapier to test for the validity of an email addresses format?I’m not trying to test the validity of an actual email address, ie that it is an active mailbox, rather just that it’s a legislate format.So that the SAAS I’m trying to send it to won’t reject it.I’d rather avoid building a Python function to do this if possible.tThanks in advance.

1128
Badger
1 month ago
A
andrismalnaNew
posted in Data Structuring
Web form Json payload structure conversion to Zapier required structure

Hi Looking for a possible way to use an existing Json payload from a webform where the strucutre is different from what Zapier’s required structure is, please see below the examples: Our web forms provided structure: {   "Fields":[{ "key":"firstName","value":"Michael" },{"key":"lastName","value":"Scott" },{"key":"email","value":email@domain.com }]}Zapier required structure:  {    "name": "Example Name",    "email": “example@gmail.com”,}Would it be possible to convert the structure in Zapier to the required one??Thanks!

231
Badger
1 month ago
P
Priya MishraNew
posted in Data Structuring
Regarding Parsing JSON data

I am calling an API that produces a sizable JSON response. Zapier is trying to output most of the leaf nodes as values, but I want to just take the entire body into the next step.If i am using Code by Zapier also and trying to get input data as an json i am not able to do so...as in my previous webshook step i am geeting output as JSON but Zapier is automatically spliting them and combining them in one instead of parsing same data as an json.

181
Badger
1 month ago
A
Alex IlkevychBeginner
asked in Data Structuring
Cli create action: the "headers" field in z.request is ignored

Hi all.Maybe someone has already encountered the same problem, when the headers are ignored, and I always get "text/plain;charset=UTF-8".The body was received as expected, but the headers were not.const perform = async (z: ZObject, bundle: Bundle) => { const response = await z.request({ method: "POST", url: API_URL(bundle), // headers: { // "content-type": "application/json" // }, headers: { "content-type": "application/x-www-form-urlencoded", "some-header": "exist", }, // json // if `body` is an object, it'll automatically get run through JSON.stringify // if you don't want to send JSON, pass a string in your chosen format here instead body: JSON.stringify({ access: `{{bundle.inputData.access}}`, account: `{{bundle.inputData.account}}`, summary: `{{bundle.inputData.summary}}`, }), // body: { // access: `{{bundle.inputData.access}}`, // account: `{{bundle.inputData.account}}`, // summary: `{{bu

143
A
2 months ago
matthewcharlesb
matthewcharlesbBeginner
asked in Data Structuring
Paginating results from a trigger

I’m trying to determine best practices when a user sets up a trigger. Instead of polling ALL records from our platform, shouldn’t we limit the query in some way? Perhaps limiting to new data since the last poll or at least the last 24 hours. I know Zapier de-duplicates based on ID. Here’s my code:const options = { url: `https://XXX/${bundle.authData.event_id}/sales-report?checkout_time[gt]=2000-01-01&per_page=2000`, method: 'GET', headers: { 'Accept': 'application/json', 'Authorization': `XXXX` }, 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.data; const lists = results["data"].map((item) => { return { ...item, id: item["record_id"], }; }); return lists; });Shouldn’t I limit my 2000-01-01 to perhaps yesterday? Then, I can limit my per_page to 100 or so. Last

441
M
7 months ago
D
DNAmonNew
asked in Data Structuring
Zapier only outputs first json object, having troube useing looping

I have been given the assignment to connect our company's API to Zapier with custom connectors. This appears to be working although it only returns the first item of the JSON object (fig 1) which seems to be the norm for zapier. I added the option (fig 2) to output all data with 0.Name 0.Sequence 1.Name 1.Sequence. etc. form (fig 3), however neiither yield what we want. We have a use case that loops over all applications in our software and performs some actions with each application but zapier only does all the steps with the first one I tried to add looping and formatting but I'm just a bit to novel to really be able to apply it to our own API.Does anyone know how I would be able to accomplish our goal of having one run loop over each application available? 

1562
S
7 months ago
H
hungry-pikachuBeginner
asked in Data Structuring
Make `,1` work in line itemizer?

Currently building a private integration where data extraction is performed Screenshot  Problem is from step 3 to step 4, I tried to line-itemize a `,1` line item output from 3, with config as belowNote this `,1` means empty `` for product A, `1` for product BPay attention to `Quantity` value - `,1` When testing, it converted into `productA: 1; productB: none` instead Here’s the bug - if I manually input `,1`, it works as expected Does anyone know how do I fix this? Should I avoid using Zapier line-itemizer and create my own with string manipulation? Thanks a lot! 

461
O
8 months ago
M
Martin SkaarupNew
asked in Data Structuring
Zapier Platfom Build Trigger (Cannot read properties of undefined (reading 'map')

Hello! :)Need help to understand this issue.I want to build this Trigger in my build:API configurations:const options = { url: 'https://api.telavox.se/calls', method: 'GET', headers: { 'Accept': 'application/json', 'X-USERNAME': bundle.authData.username, 'X-PASSWORD': bundle.authData.password }, params: { 'username': bundle.authData.username, 'password': bundle.authData.password, 'fromDate': bundle.inputData.fromDate, 'toDate': bundle.inputData.toDate }}return z.request(options).then((response) => { response.throwForStatus(); let items = response.data.items; return items.map((item) => { item.id = item.newID; return item; }); });API docs: https://developer.telavox.com/documentation/calls/ The reasion why im tryin to make a custom ID Field is because the array from the API don’t give me any id. Error:Cannot read properties of undefined (reading 'map')What happened (You are seeing this because you are an admin): Starting GET request to

710
M
11 months ago
M
markemalyNew
asked in Data Structuring
How do I lookup a specific row (3rd from the last) in a Google Sheet using Zapier?

Im wanting to lookup a specific row that is the 3rd row up from the last row in a google sheet. So for example, if the last value input into a row is in row 10, I want to look up what the data is that is 3 rows up from this, so in row 7, in a specific column. Is this possible?

1571
Troy Tessalone
1 year ago
F
flinfjardNew
asked in Data Structuring
Need help with actions and nested objects

Hi, ive been trying for a very long time creating my first action for the test integration im building as a MVP.I managed to setup authentication and triggers. But im stuck at atction :(The user case. Something happen in salesforce, then zapier creates. a quote in the stystemUnfortunately ive been stuck for a while on actions. I can't seem to figure out how the setup the input designer to allow for both Line items as well as nested objects. And it all stops when im trying to test the action.This is the code i have in api conifg const options = { url: 'https://api.fastspring.com/quotes', method: 'POST', headers: { 'Content-Type': 'application/json', 'Accept': 'application/json' }, body: JSON.stringify({ 'coupon': bundle.inputData.coupon, 'currency': bundle.inputData.currency, 'expirationDateDays': bundle.inputData.expirationDateDays, 'items': [{ 'product': bundle.inputData.product, 'unitListPrice': bundle.inputData.unitListPrice, 'quantity': bundle.

1620
F
1 year ago
TourialDevCody
TourialDevCodyBeginner
asked in Data Structuring
Webhooks that send varying data

Hey!I am creating a Zapier Integration that attaches to forms in our application. Each customer of ours has many forms, each with varying fields. How do we dynamically handle fiends. I’d love to just send JSON over with the fields in key/value pairs, but since this varies from request to request and the possibilities are infinite, how do zapier users access that data in their zaps?  Ie.) if the output doesn’t define the field “first_name” is there a way to access that in actions for when it exists? Thanks in advance!

552
TourialDevCody
1 year ago
Terms & Conditions