web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / How can I use offsets ...
Power Pages
Unanswered

How can I use offsets and limits in Web API

(0) ShareShare
ReportReport
Posted on by 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:
I have the same question (0)
  • Akah Mandela Profile Picture
    445 on at

    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.

  • Bhargav1729 Profile Picture
    2 on at

    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?Screenshot 2023-09-17 123758.png

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Pages

#1
Jerry-IN Profile Picture

Jerry-IN 71

#2
Fubar Profile Picture

Fubar 62 Super User 2025 Season 2

#3
sannavajjala87 Profile Picture

sannavajjala87 31

Last 30 days Overall leaderboard