Chain (get) a single record in AitTable table

[gm.cellinig8f]

Ciao

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

I want to get (for example) the record finID = 6
This is the block:

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

[tatiang]

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

[gm.cellinig8f]

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"}}]}

[tatiang]

“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.

[gm.cellinig8f]

Thankyou.

Like this?

Grazie

[tatiang]

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.

[gm.cellinig8f]

Excuse my ignorance… you mean:

Grazie

[tatiang]

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

[gm.cellinig8f]

Thank you.
Now it works!!

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