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 to skip the first ...
Power Pages
Unanswered

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,368 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

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