Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

How to use OData with pagination ? and test it in Postman ?

(1) ShareShare
ReportReport
Posted on by 508
Hi all,
 
I'm new to OData and Postman. Currently I'm trying to call ReleasedProductV2 through Postman, but since it is a large volume (I have around 10k of rows) which resulted TimeOut. Some people tell me that I'm gonna need to apply pagination, may I know how to use and applying this ?
 
Thanks,
  • Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    How to use OData with pagination ? and test it in Postman ?
    Hi,
    You can refer to this official document, which explains the use of $count and examples: Query options overview - OData | Microsoft Learn.
    Best regards,
    Kevin
  • Ken Manhattan Profile Picture
    Ken Manhattan 508 on at
    How to use OData with pagination ? and test it in Postman ?
    I'm trying to use and adding $skip and $top, and it works.
     
    However if I take a look at Microsoft blog and reading this ->
    The following are the high-level features that are enabled for the OData service, per the OData specification.
        CRUD support is handled through HTTP verb support for POST, PATCH, PUT, and DELETE.
        Available query options are:
            $filter
            $count
            $orderby
            $skip
            $top
            $expand (only first-level expansion is supported)
            $select
     
    There is one which is $count, may I know how to use this ? and is this command give us the total records ? Which mean if I didn't filter at all or using $top, it will give total ALL records ?
    Tried this but currently return Timeout.
     
    Thanks
  • Ken Manhattan Profile Picture
    Ken Manhattan 508 on at
    How to use OData with pagination ? and test it in Postman ?
    Hi Kevin,
     
    Thanks for your references. So if I may sum up. For Server-driven, which mean we cannot directly use that ReleasedProductV2 once only, but it is either to modify it or create custom web service that use this OData entity and make it a loop until there is no NextPage. And for Client-driven, similar like the creation of custom web service for Server-driven, the "client" which is my external party need to create program to loop through this OData entity using $skip and $top in the URL dynamically.
     
    And for testing Postman, just browsing though the Net, we then need to use Postman Flow to try this if there is no custom as mentioned above being created .
     
    This is correct, right ?
     
     
  • Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    How to use OData with pagination ? and test it in Postman ?
    Hi,
    I found this official document on OData pagination for you: Pagination - OData | Microsoft Learn. It describes that services often rely on pagination to load the data incrementally to improve the response times and the user experience. Paging can be server-driven or client-driven. It provides a detailed introduction to both server-driven and client-driven paging, both with code.
    Of course, I also found an old thread for you that has a similar problem to you, you can refer to it: Pagination with Odata (dynamics.com).
    Best regards.
    Kevin

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans