SubZap - Return from SubZap after Loop

@Financial Admin 

Unclear about what you mean by these:

is this also working for line items?
or does it give just raw record lines?

The output is the same as the Find Record(s) action.

Airtable API: https://airtable.com/developers/web/api/introduction

@Financial Admin 

You would use these 2 sections:

• URL
• Query String Parameters

Hi @Troy Tessalone ,

in general that worked, but it seems that the date gets mixed up entirely.
i have records in airtable that store all information, also sometimes columns not filled depending of the product involved.

when i request those records i guessed i will have empty colums that will reflect just as ,,,value,,,

while others reflect as ,value,,value,value,,, for example.

The request seems ok yet. But then i want to loop them (create loop from text with delimeters “,”) and create then entries in my Zapier Table.

The result mixes values from different records, column values from a third record are also included in first and so on….
I am not sure how i can manage to keep them all like they are intended to be…

Hi @Troy Tessalone ,

of course i will send updated Screenshots.

I used the one config you mention above before, but the issue then was, the values have not been separated but only taken together in one long string with the “,” in between.
So i was trying to get the one with text instead of by lineitems.

Here is the Whole in a nutshell for now:
 

Here are the details from the API Request:

Here are the records that comes in the “data” section of the requests return (put in a spoiler so you can hide it due to long text.

and for one of the items here the screenshots (last field overlaps to new screenshot to show where it continues):
 

Then the Step for the loop:

Example of the fields that are getting looped:

There are more , depending of the product

Here are the further settings

and here you get the first loop as the preview and not all of the fields had to be filled. some of the data is already mixed with the data from other records.

Does that fit for you to give me maybe more ideas?

Thank you so so much for taking your time at all, really appreciated!

Hi @Troy Tessalone ,

i tried again, here is the result when i switch to Loop from line items, first the setup:

Then, the result in the test:
 

Somehow it seems the linked IDs etc. would be kept all in one field, the data that is just from this record in other fields stay like it should be.

Can you tell me why the linked data is stored this way and how to prevent this?

Thank you and regards

Hi @Troy Tessalone ,

i tried, but even when i use the response data record the data that is not directly included but linked is not getting listed in the line item but then it takes all from this one “lower” level together and packs all values in one field.

That is always when you see above my post and picture, when you have the one below the field cause it is linked.

What i recognized is, when i have data linked over a single select field for example the categorie or the product group, i could not use them when they have been linked but… when i use a formula field in the table and just put the single select field as source so that i have the name in the formula field, this works for me. And this way i can use the really neccesary fields for the selection.
This way i need to put the name of the product also in addition in a single select and then get the name via Formula field but this is all i can do now.

I guess this is a shabby solution, but for now it works and hopefully i will be able to refine it someday.

Thank you for your help with this Troy, much appreciated, even when the solution needed to be this way :)

Have a good evening!