AnsweredAssumed Answered

How do we pass $top & $skip queries in OData client operation by dynamically?

Question asked by vkarnati031172 on Aug 30, 2017

Hi,

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

Outcomes