I am wondering how people would go about this kind of scenario:
- I have several tables in baserow
- Each of those table contains references to each other using the Link to table feature in hierarchies (like Table A containing towns, Table B containing adresses Link to table towns, Table C containing people Link to table B)
- I want to use the API to be able to get for example “give me the town that person x lives in based on the persons email”
Do I really need to multiple API requests for this? E.g. first use the API of Table C to get the person x based on email, then based on the information on the linked table b that is returned I need to do a API call to either Table A or B to check the town? Any smart work arounds?