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?