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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / How to skip the first ...
Power Pages
Answered

How to skip the first N data in Portal Web API?

(1) ShareShare
ReportReport
Posted on by 5

Hey there, I'm trying to retrieve data using Portal Web API, similar to this SQL query below.

 

 

 

SELECT *
FROM table_name
LIMIT 5 OFFSET 3

 

 

 

I've tried both of these formats below but they both return an error.

 

 

 

/_api/table_name?&top=5&$skip=3
/_api/table_name?&top=5&$offset=3

 

 

 

Here is the error message.

 

 

 

{"error":{"code":"9004010D","message":"Common Data Service error occurred.","cdscode":"0x0"}}

 

 

 

Is it possible to do this in current version of Portal Web API? If so, what is the correct syntax? Thanks.

Categories:
I have the same question (0)
  • Verified answer
    oliver.rodrigues Profile Picture
    9,471 Most Valuable Professional on at

    As far as I am aware this parameter is not available in the Portals API. What you can do is skip the records when reading them in your JavaScript code

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
rezarizvii Profile Picture

rezarizvii 61

#2
Valantis Profile Picture

Valantis 46

#2
11manish Profile Picture

11manish 46

Last 30 days Overall leaderboard