Skip to main content

Hi,

I'm really wrestling with finding a solution here and I am sure I am not the only one who has the issue.  
I have 2 tables in Airtable:
1) Skills Table - fields include SkillId, Name, Description, Link to Skill Definition table via DefinitionId
2) Skill Definition Table - fields include DefinitionId, Definition, Level (Level is either Beginner, Intermediate or Expert)

When I call the API and GET a skill from the Skill Table I would like the Skill Definition to nest as an object in the response.  I noticed this behavior is possible with the Collaborator type, shown below for the Assigned field

At the moment when I link the Skills Definition table to the Skills table and add lookup columns from the Skills Definition table, then call the API from Postman, the fields are shown in a flat structure as an array

Is there any way I can nest this object linked by the Definition Id like the Collaborator type?

Thanks in advance.  

 

 

 

Just providing some more info here.  
I saw another post which suggested using BaseSql which worked the way I wanted.  Here's the output I'm after from the airtable api. Is there any way to do this natively in airtable or do I have to use a 3rd party tool?

 



  

Reply


Terms & Conditions