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

(1) Share

Report

Posted on by Ken Manhattan

390

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,

All responses (4)

Answers (0)

Kevin Xia Microsoft Employee on at

Like (0)

Report

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 390 on at

Like (0)

Report

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 390 on at

Like (0)

Report

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 Microsoft Employee on at

Like (1)

Report

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

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

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Announcing Our 2024 Season 2 Super Users!

Community Spotlight for September 2024

more Community News

Leaderboard

Featured topics

Product updates

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

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Announcing Our 2024 Season 2 Super Users!

Community Spotlight for September 2024

more Community News

Subscribe to

Leaderboard

Featured topics

Product updates