REST API pagination limit offset

Hi, 

I'm trying to consume REST API with limit/offset pagination

https://<>.rest.afas.online/ProfitRestServices/connectors/<connector>?skip=250&take=250&orderbyfieldids=Medewerker

skip = Offset. in the example above skip the first 250 rows 

take = limit. take 250 rows
 

seems to work in Postman
 

My approach was to use 'override pagination’

In combination with endpoint's 'query parameters’
 

 using the following expression:

SELECT ({TX_NextPage}  - 1) * 150 AS skipValue

When running the ODX tasks it seems to ingest only the first page. 

What am i'm doing wrong?