Web service integration with specific paging

Hi Community, 

I need to create a record type based on an external Airtable table. AirTable provides a REST API for querying the data, so I decided to create a Web Service based record type. 

I already created a connected system and confirm that is returning data. 

The issue here is the paging (due to the expected number of records) - Airtable does not accept a page number as (query) parameter, only the page Size. 

In each response, beside the record list, there is an attribute called "offset" that should be used in next request (send as a query parameter) to get the next page (and so on). 

When we get the last page, the offset attribute will be empty. Additionally, there is no way to know (in advance) the number of records in the Airtable. 

As the Appian paging is based on batch number, I do not have any idea how to proceed.  

Hope that somebody knows a way how to handle this type of paging. 

Thanks in advance