About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces Zapier Canvas Zapier Chatbots

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

  • 8 Topics
  • 7 Replies

8 Topics

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

1
M
1 month 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? 

2
S
2 months 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.

0
A
2 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! 

1
H
3 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

0
M
6 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?

1
Troy Tessalone
7 months 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.

0
F
9 months 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!

2
TourialDevCody
11 months ago
Terms & Conditions