Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Pages - General Discussions
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.

  • Verified answer
    oliver.rodrigues Profile Picture
    9,315 Most Valuable Professional on at
    Re: How to skip the first N data in Portal Web API?

    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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >