The Standard API limits GET requests to 100 records. To get more records, you must submit multiple requests with the page offset. The details are in the api documentation.
The server returns one page of records at a time. Each page will contain
pageSizerecords, which is 100 by default.
If there are more records, the response will contain an
offset. To fetch the next page of records, include
offsetin the next request’s parameters.
Pagination will stop when you’ve reached the end of your table. If the
maxRecordsparameter is passed, pagination will stop once you’ve reached this maximum.
If you need to get all of your data, it will take multiple requests to piece it all together, and you will have to deal with the rate limit.
If you can get by with only some records, you can reduce the number of records the records returned by view or by filterByFormula. You may also be able to reduce calls to linked records by adding lookup fields to your initial table.
If the page size and rate limit combination is going to be a problem, you might need to look at a different platform.