Hey @fcicyber! What kind of pagination does your API use (e.g. cursor-based or server-side)?
For example, Stripe's API utilizes cursor-based pagination. You can use a table with server-side pagination enabled. We have some docs on getting started with that, so please do check those out!
Also, are any of these forum posts close to what you're looking to do?
http://community.retool.com/t/returning-all-results-for-a-cursor-based-paginated-api/3387
or
http://community.retool.com/t/hit-a-wall-with-rest-api-pagination/17499/6
or
http://community.retool.com/t/pagination-using-response-link-header/13768/8
Let us know if you need any additional help as you follow those steps!