Creation of Dynamic Interactive Table

Dear Tulip Community,

I am trying to create a dynamic interactive table which will load different tables upon selection of different variables.

Variable A is selected → Table A is loaded into the interactive table.
Variable B is selected → Table B is loaded into the interactive table.

I was able to achieve it by making use of the Table API, Connector functions and Interactive table with data source as variable. When Variable A is selected in the app, connector function runs and stores the Table A output into object list variable which is linked to the interactive table.

However, with this approach, I am able to fetch only 100 records from the table which contains around 1000 rows as API limit is max. 100.

Could anyone help with a workaround to get all records from the table?

Is there any other efficient way to do this?