Retrieving a single Airtable record ID

[msmurfitt]

Hi,
I’m trying to work out how to retrieve a single record id from airtable.

I have a column in my table in airtable which is auto populating via a forumula every time a new record is created, however I can’t figure out how to then retrieve that record ID.
So far, this is what I have:

What I was hoping to do was to use magic text and append the api url with the currently logged in user, but it doesn’t work

The airtable API Encoder shows the URL like this:
https://api.airtable.com/v0/appe82jBjYQdingsB/TableName?fields[]=+UserID

This also doesn’t work (the ‘+’ is a space, I’ve tried it with and without…no joy)

Anyone have any ideas?
They’d be very much appreciated…

[claireconza]

if you create a formula field in airtable and type in RECORD_ID() this will return the record id for each record.

You do not to add anything in the body request of the API Base URL…

Just make sure you specify ‘records’ in the Get All results key:-

You will then have access to your data from the table in Adalo as an external collection that will include the recordid of each record.

Hope this helps.

Thanks

Claire

[msmurfitt]

Thanks @claireconza, appreciate it