Hi @Financial Admin 

Zap action: Airtable - API Request

This can be used to return up to 100 records.

Hi Troy,

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

I will test it out, if that works, you are my savior :D

BR

FA

@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

Hi @Troy Tessalone ,

thank you very much, i tried the request, but i am not that much familiar with the correct syntax.

May i ask you, if this is correct?

I setup the Formula like you see here:

and Record ID should be the value out of a previous step in Zapier.

And in Zapier the only field i wanted to fill is this one here, right?
 

I am not sure what i do wrong, but when i try to filter on a specific value on a record, i can not get the correct records.

If you have any hint for me, would be awesome….

Thank you in advance.

BR

@Financial Admin 

You would use these 2 sections:

• URL
• Query String Parameters

@Financial Admin

Try this filterByFormula

Change {FIELD} to the desired field.

Change [RECORD_ID] to be mapped in from a previous step.

{FIELD} = '[RECORD_ID]'

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…

@Financial Admin 

We would need to see updated screenshots with how your Zap steps are configured.

Showing screenshots with how the data is returned from Airtable will be helpful too.

Since the data returned from Airtable is an array, make sure to use this Zap action: Looping - Create Loop from Line Items

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!

@Financial Admin 

Since the data returned from Airtable is an array, I recommend using this Zap action: Looping - Create Loop from Line Items

If you only want records that meet certain conditions (e.g. Field X must have a value), then specify an Airtable View (with Filters criteria configured) in the Airtable API Request action.

Or you can use a Filter step after the Looping step to limit which records continue to run based on configured Filter conditions.

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

@Financial Admin 

Looks like you are mixing values from different steps.

Try removing the mapped values from step 2 and step 3.

Instead map those directly to the desired step after the Looping step.

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!