Data Structuring

Hi guys, The Zaps are possible to order in Folders. The tables though are not easy to filter/order. When I have 100 tables that is going to be a difficult to organize and find them. I suggest a folder structure like the apps is very important.  

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! 🙏

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  

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

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.

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

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.

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.

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!

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.

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

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

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? 

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! 

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

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?

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.

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!