Select An Org
How to work with $top and $skip queries in ODATA
Publish Date: Aug 6, 2025
Task
GOAL:
This article will help you in working with $skip and $top.$top and $skip are used to limit the amount of data.
This is done by calculating an offset and the number of records to return.
The offset is set using the $skip system query option and the number of items returned via the $top system query option.
If only the first n items are required then it is sufficient to omit the $skip directive.
$top is used to get the list of elements from the top based upon the number that you pass.
$skip is used to skip the first n element based upon the value to specify in there.
Steps
- Follow the document -> https://docs.mulesoft.com/apikit/4.x/creating-an-odata-api-with-apikit to create an OData API.
- Use the following endpoint to use the $skip and $top:
http://localhost:8081/api/odata.svc/customers?$format=json&$top=2&$skip=10
It will give the 11th and 12th elements as a result.
Knowledge Article Number
001116136
Did this article solve your issue?
Let us know so we can improve!
