There is a requirement to query records in a batches of 5000 by using Odata client operation in a dynamic way. In the first batch 1-5000 records need to be fetched and in second batch 5001-10000 records need to be fetched and so on. I used "CustomFilter" field with "Custom Expression" to fetch the records, but there is a format issue in the query. I tried several scenario's but didn't work out any.
Sample query : $top=99
Any one of you have worked on this? Does Boomi support querying records by passing $top & $skip in dynamic way in OData client connector? Appreciate any help