News and Announcements icon

Power Platform CommunityForums Power Pages - General Discussions How can I use offsets ...

Power Pages - General Discussions

Unanswered

How can I use offsets and limits in Web API

(0) Share

Report

Report

Posted on by Bhargav1729

2

Hi,
I am using page & count in fetchxml .

<fetch mapping="logical" count="10" page="1">

<entity name="contact">

<attribute name="fullname" />

</entity>

</fetch>

How can I achieve the same in Web API using limit and offset

Thank You.

Categories:

All responses Img

All responses (2)

Answers Img

Answers (0)

Bhargav1729 2 on at

Like (0)

Report

Re: How can I use offsets and limits in Web API

Hi @mandela ,
Yes, I tried using 'top' and 'skip', but the issue lies with 'skip'. When I used 'skip', I encountered an error stating that the 'skip' clause is not supported. Upon reviewing the documentation, I confirmed that 'skip' is indeed not supported. Are there any other alternatives?
Akah Mandela 445 on at

Like (0)

Report
Re: How can I use offsets and limits in Web API

Have you tried with skip and stop ?
GET [Organization URI]/api/data/v9.0/contacts?$select=fullname&$top=10&$skip=0
This will return the first 10 records from the ‘Contact’ entity, starting from the first record.
or
GET [Organization URI]/api/data/v9.0/contacts?$select=fullname&$top=10&$skip=10
This will return the next 10 records, starting from record number 11.

Helpful resources

News and Announcements

Upwork and Microsoft Power Platform Partnership

Welcome to the Power Platform Communities

Check out the New Agent Creator Community

Quick Links

Leaderboard > Power Pages

#1

Fubar 69 Super User 2025 Season 1

#2

oliver.rodrigues 49 Most Valuable Professional

#3

Jon Unzueta 43

Last month Overall leaderboard

Featured topics

Solution to LinkedIn Authentication in Power Apps Portals

Product updates

Microsoft Power Platform Community release plans