Zoho Reports - API - Limit on number of records in a page when importing into Zoho reports.

Zoho Reports - API - Limit on number of records in a page when importing into Zoho reports.

The API I'm using only allows a maximum of 500 records per page. Eventually I'm going to have 1,000's of records to import and currently I only get one page. I'd like to be able to have all the records stored in a single table.

So far the only idea I have is to have a separate table per page and then have a function which combines all the separate pages into a single table. 

I'd like to know if firstly my idea is possible and secondly is there a better way. For instance having multiple API calls per table so that all the records are imported.