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

(1) Share

Report

Posted on by Ken Manhattan

558

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,

I have the same question (0)

All responses (4)

Answers (0)

Kevin Xia Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Ken Manhattan 558 on at

Like (0)

Report
Copy link

Link copied!

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 ?

Was this reply helpful? Yes No
Ken Manhattan 558 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Kevin Xia Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No