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.

  • 17 Topics
  • 29 Replies
17 Topics
I
InsightBeginner
asked in Data Structuring
Properties

Hi everyone,I’m using the Zapier → Odoo CRM integration to create new Leads. In the “Create Lead” action I see the Properties field, but I couldn’t find clear documentation on how it should be used.Specifically, I’d like to know: Can this field be used to populate additional fields that don’t appear in the standard Zapier template (for example, fields created with Odoo Studio — x_studio_*)? Has anyone successfully filled these extra fields by passing key/value pairs? I’ve tried different combinations (e.g. Key = technical field name, Value = value), but they don’t seem to affect the created Leads. Has anyone here managed to use the Properties field to map custom fields or other Odoo fields that are not included by default in the Zapier connector?Thanks a lot! 🙏

183
Troy Tessalone
Zapier Orchestrator & Solution Partner
L
LucaMontaBeginner
asked in Data Structuring
How to handle dynamic data keys in Zapier integrations

Hello,I tried googling and searching, but wasn’t able to find a satisfactory answer.I am building an integration for my “membership” app where I’ve got dynamic fields, created by admins.Please note this is a product sold to many websites, therefore I cannot know which fields are created.I built the entire infrastructure, everything is ready to be published, but got stuck on the sample output definition. Zapier wants a fixed structure, but I can’t have one.Then I thought about passing the user ID as fixed field and a JSON string for “user_data”, but how to extract those values to be used on further Zapier steps?Any help to save me from having trashed weeks of work is welcome!Thanks  

221
L
N
nisarBeginner
asked in Data Structuring
How to implement a delete project action using the Kroolo API

we want to create action "delete project" in which  user will select an input field "Select workspace"  which is coming dynamically from kroolo api and all workspace id should be come in dropdown and then user will select that workspace then corresponding to workspace id user will select projects from projects's dropdown  and then use will "delete project" action.  Please give me  steps to implement this feature

292
N
H
hitplayBeginner
asked in Data Structuring
Understanding Rentman subprojects and the name function options

Hi there! I am new to the Rentman/Zapier integration setup and am looking for clarification on why the Subproject option has two data options for “Name” and which one relates to the project name, attached below.I imagine the answer is one of these relates to the name of the Project item and the other relates to the Subproject item but I am not sure which is which here.  Also, another question, why is the “status” data option only available under “subprojects”? I want to be able to create an automation to send a channel message when a project is canceled. We rely on the project numbers to help us search for the correct project, however, the project number is not available when using the “subproject” item in the zap. So I’m running into this loop right now where we can’t specify this with paths in the way I would like. Any help would be greatly appreciated.

250
H
C
Chipl71Beginner
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

291
Troy Tessalone
Zapier Orchestrator & Solution Partner
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.

392
K
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.

2168
Badger
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!

481
Badger
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.

461
Badger
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

283
A
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

781
M
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? 

2272
S
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! 

621
O
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

840
M
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?

2901
Troy Tessalone
Zapier Orchestrator & Solution Partner
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.

2130
F
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!

752
TourialDevCody
Terms & Conditions