Web Api response to be stored in Airtable

Questions about Thunkable
1

Hi,

Wanted to add all food item into the airtable one after another as how its displayed in List viewer.

List Viewer snapshot:

image
image1280Ă—720 87.3 KB

but its storing into airtable as per below snapshot:

image
image1280Ă—720 182 KB

sharing the block snapshot as well

image
image1280Ă—720 147 KB

Kindly assist.

2

Why are you trying to store a whole list into the Airtable column?

In every iteration of for each item loop you will be storing the content of the list and therefore you will see it growing with every record.

Instead store only this part in the Airtable
image

3

Yes Muneer. It worked.

image
image1920Ă—1080 179 KB

sharing the airtable screenshot too:
image
image1920Ă—1080 221 KB

Now, one more thing. When the screen opens the existing information in the airtable should be deleted .
Sharing the block snapshot.

image
image1920Ă—1080 176 KB

Its not correct… Kindly assist.

4

Try this:

5

Thank you .

I tried this way…

Sharing the blocks… Its deleting but not all at one go. Example 20 entries are there then its deleting 10 and then have to livetest then deleting the remaining one.

image
image1920Ă—1080 223 KB

Why its not deleting all the records at one go?

6

It seems you are using 2 connection methods for the same Airtable.

You have to choose one and stick to it.

7

I did not understand Muneer.

8

How are you connecting your app to Airtable?

Are you using Data Source or using the Airtable component?

Each method has different ways of dealing with data and should not be mixed.

9

Airtable component

10

image
image1920Ă—1080 232 KB

Here is the corrected block snapshot

Found the cause of not deleting all entries. Increment was put above to for loop, now changed and also understood what you meant as connection. I replaced the Data Source to Airtable delete row.

Thank you so much for bringing clarity and guidance as always. Much Appreciated!