First off - welcome!
Secondly, the Knack API provide a query parameter for this which should be passed in the filters of the list. you can make the value of the query parameter dynamic by changing an invisible input or a record in the database with a button. So when you tap the “Next Page” button, it will update the query parameter in the list filter with that number value. If you have less than 1000 records though, you don’t need the page parameter, you can just use the rows_per_page parameter and set the value of it to 1000.