# Web Api response to be stored in Airtable

**URL:** <https://community.thunkable.com/t/web-api-response-to-be-stored-in-airtable/1711893>\
**Category:** Questions about Thunkable X\
**Tags:** beginner\
**Created:** [February 2, 2022, 4:44pm UTC](https://community.thunkable.com/t/web-api-response-to-be-stored-in-airtable/1711893 "2022-02-02T16:44:34Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![sasi.preethag3yh](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@sasi.preethag3yh](https://community.thunkable.com/u/sasi.preethag3yh)\
**Post date:** [February 2, 2022, 4:44pm UTC](https://community.thunkable.com/t/web-api-response-to-be-stored-in-airtable/1711893/1 "2022-02-02T16:44:34Z")

</div>

Hi,

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

List Viewer snapshot:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/0/407156ecd3f4edb0966c4fb3368fc977accfaeab.jpeg)

but its storing into airtable as per below snapshot:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/9/9997718315e44caf892f6881327cc3094b63c579.jpeg)

sharing the block snapshot as well

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/e/2eb543fef2e23378eee4ceea8361c33adf3a6611.jpeg)

Kindly assist.

---

<div class="post-metadata">

**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\
**Post date:** [February 2, 2022, 5:01pm UTC](https://community.thunkable.com/t/web-api-response-to-be-stored-in-airtable/1711893/2 "2022-02-02T17:01:41Z")

</div>

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](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/6/e6b468cfb2fae26496d90c2c73941a1dba584231.png)

---

<div class="post-metadata">

**Author:** ![sasi.preethag3yh](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@sasi.preethag3yh](https://community.thunkable.com/u/sasi.preethag3yh)\
**Post date:** [February 3, 2022, 4:54am UTC](https://community.thunkable.com/t/web-api-response-to-be-stored-in-airtable/1711893/3 "2022-02-03T04:54:56Z")

</div>

Yes Muneer. It worked.

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/a/da6a7f4acd5bfb16cf0d591ec821abf14d7047d5.png)  
sharing the airtable screenshot too:  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/1/b1cfe010c8b18c3b90ea3ad251b7addc39566687.png)

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

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/8/681ff96e52896d8aee6b25d2b65437d48a567281.png)

Its not correct… Kindly assist.

---

<div class="post-metadata">

**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\
**Post date:** [February 3, 2022, 5:58am UTC](https://community.thunkable.com/t/web-api-response-to-be-stored-in-airtable/1711893/4 "2022-02-03T05:58:27Z")

</div>

Try this:

> [@How to delete a single row from airtable](https://community.thunkable.com/t/how-to-delete-a-single-row-from-airtable/1038786/2):
>
> Have you tried this: [datasourcedeleteallrows] Note: You can use it with Airtable only when you access it through Data Source drawer in the coding Blocks in the new UI (moving invisible components to block screen)

---

<div class="post-metadata">

**Author:** ![sasi.preethag3yh](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@sasi.preethag3yh](https://community.thunkable.com/u/sasi.preethag3yh)\
**Post date:** [February 3, 2022, 9:43am UTC](https://community.thunkable.com/t/web-api-response-to-be-stored-in-airtable/1711893/5 "2022-02-03T09:43:25Z")

</div>

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](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/9/79dea80bbb8983d64668039c78ddc03b1006dddd.png)

Why its not deleting all the records at one go?

---

<div class="post-metadata">

**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\
**Post date:** [February 3, 2022, 11:03am UTC](https://community.thunkable.com/t/web-api-response-to-be-stored-in-airtable/1711893/6 "2022-02-03T11:03:27Z")

</div>

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

You have to choose one and stick to it.

---

<div class="post-metadata">

**Author:** ![sasi.preethag3yh](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@sasi.preethag3yh](https://community.thunkable.com/u/sasi.preethag3yh)\
**Post date:** [February 3, 2022, 11:12am UTC](https://community.thunkable.com/t/web-api-response-to-be-stored-in-airtable/1711893/7 "2022-02-03T11:12:02Z")

</div>

I did not understand Muneer.

---

<div class="post-metadata">

**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\
**Post date:** [February 3, 2022, 11:34am UTC](https://community.thunkable.com/t/web-api-response-to-be-stored-in-airtable/1711893/8 "2022-02-03T11:34:20Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![sasi.preethag3yh](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@sasi.preethag3yh](https://community.thunkable.com/u/sasi.preethag3yh)\
**Post date:** [February 3, 2022, 1:09pm UTC](https://community.thunkable.com/t/web-api-response-to-be-stored-in-airtable/1711893/9 "2022-02-03T13:09:35Z")

</div>

Airtable component

---

<div class="post-metadata">

**Author:** ![sasi.preethag3yh](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@sasi.preethag3yh](https://community.thunkable.com/u/sasi.preethag3yh)\
**Post date:** [February 3, 2022, 1:22pm UTC](https://community.thunkable.com/t/web-api-response-to-be-stored-in-airtable/1711893/10 "2022-02-03T13:22:23Z")

</div>

![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/2/6282419c15e79f1b96c2c2e89c4bba33a6ed3ef3.png)  
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!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\
**Post date:** [May 4, 2022, 1:22pm UTC](https://community.thunkable.com/t/web-api-response-to-be-stored-in-airtable/1711893/11 "2022-05-04T13:22:26Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
