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
Does the JSON response start with a “records” property? What does the JSON response look like as text?
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"}}]}
“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.
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.
Excuse my ignorance… you mean:
Grazie
Yes but now you’ve removed the get object from JSON
block that needs to go in front of the green response
block.
Thank you.
Now it works!!
So, for every field I have to repeat this loop?