# Chain (get) a single record in AitTable table

**URL:** <https://community.thunkable.com/t/chain-get-a-single-record-in-aittable-table/3289217>\
**Category:** Questions about Thunkable X\
**Created:** [October 21, 2024, 1:59pm UTC](https://community.thunkable.com/t/chain-get-a-single-record-in-aittable-table/3289217 "2024-10-21T13:59:24Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![gm.cellinig8f](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/gm.cellinig8f/32/163435_2.png) [@gm.cellinig8f](https://community.thunkable.com/u/gm.cellinig8f)\
**Post date:** [October 21, 2024, 1:59pm UTC](https://community.thunkable.com/t/chain-get-a-single-record-in-aittable-table/3289217/1 "2024-10-21T13:59:24Z")

</div>

Ciao

I’d like to get a single record on Airtable record linked by a unique value.  
This is te airteble table:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/7/c78676a0c36ab2d18ab6bbb5c8b35271411a31d8.png)  
I want to get (for example) the record finID = 6  
This is the block:  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/c/fcdc3b4e75b0b85d0c8993176d0a11c5c1d9a160.png)

Why in the “response” I have the record but in varATfile not?  
Grazie

---

<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:** [October 21, 2024, 2:34pm UTC](https://community.thunkable.com/t/chain-get-a-single-record-in-aittable-table/3289217/2 "2024-10-21T14:34:01Z")

</div>

Does the JSON response start with a “records” property? What does the JSON response look like as text?

---

<div class="post-metadata">

**Author:** ![gm.cellinig8f](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/gm.cellinig8f/32/163435_2.png) [@gm.cellinig8f](https://community.thunkable.com/u/gm.cellinig8f)\
**Post date:** [October 21, 2024, 3:02pm UTC](https://community.thunkable.com/t/chain-get-a-single-record-in-aittable-table/3289217/3 "2024-10-21T15:02:09Z")

</div>

That is:

`{"records":[{"id":"recGBSwVWkefT2GMy","createdTime":"2024-10-09T08:13:51.000Z","fields":{"atlResidenza":"residenza...","atlUteInserimento":"Utente che ha inserito il record","atlTelefono":"telefono...","atlID":6,"atlCognome":"Cognome","atlEmail":"email...","atlNome":"Nome","atlNote":"6","atlDataInsRec":"2024-10-09T08:13:51.000Z"}}]}`

---

<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:** [October 21, 2024, 4:35pm UTC](https://community.thunkable.com/t/chain-get-a-single-record-in-aittable-table/3289217/4 "2024-10-21T16:35:39Z")

</div>

“records” is a list of objects. So you might see [object] [object] when you try to display it in a label in Thunkable.

To get a specific value, you would need to – for example – get the property ’’records[1].fields.atlResidenza" of the JSON object.

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/3/f3c96f2b299f6fc003ff880fa59cf04dfe71eba3.png)

---

<div class="post-metadata">

**Author:** ![gm.cellinig8f](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/gm.cellinig8f/32/163435_2.png) [@gm.cellinig8f](https://community.thunkable.com/u/gm.cellinig8f)\
**Post date:** [October 22, 2024, 8:52am UTC](https://community.thunkable.com/t/chain-get-a-single-record-in-aittable-table/3289217/5 "2024-10-22T08:52:29Z")

</div>

Thankyou.

Like this?

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/a/eaf077e0c915d2536e92083bb2e23d70c364bf7d.png)

Grazie

---

<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:** [October 22, 2024, 2:22pm UTC](https://community.thunkable.com/t/chain-get-a-single-record-in-aittable-table/3289217/6 "2024-10-22T14:22:04Z")

</div>

No. The **records [1]** in the screenshot I posted means that the “records” property is a JSON array (like a Thunkable list). So you need to use list blocks to get that property’s contents. The simplest way to do that is to get the property “**records[1].fields.atlResidenza**”. Try that and see if it works for you. Just a single `get property of object` block with that whole text string as the property.

---

<div class="post-metadata">

**Author:** ![gm.cellinig8f](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/gm.cellinig8f/32/163435_2.png) [@gm.cellinig8f](https://community.thunkable.com/u/gm.cellinig8f)\
**Post date:** [October 22, 2024, 5:13pm UTC](https://community.thunkable.com/t/chain-get-a-single-record-in-aittable-table/3289217/7 "2024-10-22T17:13:42Z")

</div>

Excuse my ignorance… you mean:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/1/f106b2f8540e75d9113e67132895e8994105ba03.png)  
Grazie

---

<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:** [October 22, 2024, 5:49pm UTC](https://community.thunkable.com/t/chain-get-a-single-record-in-aittable-table/3289217/8 "2024-10-22T17:49:00Z")

</div>

Yes but now you’ve removed the `get object from JSON` block that needs to go in front of the green `response` block.

---

<div class="post-metadata">

**Author:** ![gm.cellinig8f](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/gm.cellinig8f/32/163435_2.png) [@gm.cellinig8f](https://community.thunkable.com/u/gm.cellinig8f)\
**Post date:** [October 23, 2024, 7:07am UTC](https://community.thunkable.com/t/chain-get-a-single-record-in-aittable-table/3289217/9 "2024-10-23T07:07:49Z")

</div>

Thank you.  
Now it works!!

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/5/359d9359dccc51631a5570eb091ae9d4b4f34cc3.png)

So, for every field I have to repeat this loop?

---

<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:** [January 21, 2025, 7:08am UTC](https://community.thunkable.com/t/chain-get-a-single-record-in-aittable-table/3289217/10 "2025-01-21T07:08:02Z")

</div>

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