I am able to get data from the API request untill the different names of the sheets. But, I need to dive deeper and get the (filtered) data from a specific table on a specific sheet. And ofcourse, the output must be the one that is selected by a specific user (user A may have a different selection as user B). How to get there?
Ideally you will have a search api that takes some filters and returns only the relevant data. But, if your data set is going to stay around 30-100, you can filter it on the client without a noticable performance hit.
