Skip to main content

Hey All! Nice to find you!


I am happy I’ve discovered Airtable as it seems to be quite a nice data management platform for my use cases. We are a team of two guys: one that manages data and me, the one who will consume this data via RESTful API in a web application.


I’ve created four tables in base and linked them appropriately. All good for now. What I want when accessing the API is to have the links fully expanded (with all the data) and not just the ID pointing to a reference ID. Would that be possible?


So, basically instead of (see Rewards key):


"records": s
{
"id": "rec2aPmtsQyMWL0gL",
"createdTime": "2022-10-10T10:23:38.000Z",
"fields": {
"Type": "type",
"ID": 2,
"Luck": 1,
"Order": 2,
"Rewards": s
"reca2ZiYRTk0rqv9x",
"recg2oisqku0f9kol"
],
...]

I will have an expanded Rewards data:


"records": s
{
"id": "rec2aPmtsQyMWL0gL",
"createdTime": "2022-10-10T10:23:38.000Z",
"fields": {
"Type": "type",
"ID": 2,
"Luck": 1,
"Order": 2,
"Rewards": s
{
id: "reca2ZiYRTk0rqv9x",
field: "Another",
other fields]
},
{
id: "recg2oisqku0f9kol",
field: "And yet another",
other fields]
}
],
...]

Would that be possible with Airtable RESTful API? Looking forward for an answer!


Thank you!


Stefan

Be the first to reply!

Reply