SAGE REST API - How to get all the records of a table in single fetch/query

When I try to get all the records in a single query, I got an error from X3 folder. And also tried with $next/$last links, however, we need to call these links synchronously until we get all the records from a table.

Is there any chance to get all the records in a single query or an alternative solution with good performance?