Skip to main content

Data Structuring

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

  • 10 Topics
  • 7 Replies
10 Topics
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.

0
P
14 days 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!

0
A
1 month 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

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

2
S
3 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
4 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
4 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
7 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
8 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
11 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
1 year ago
Terms & Conditions