Large amount of data extraction From data base with pagination

hello, I would like to know please, if it is possible to extract 300k rows with REST calls, with pagination and each page will return as 1000 rows

Hi @alex_niro,

We would need more information to provide you with an answer.

What product/components do you use and which version/fix level?
Are you using a free trial or a product with a license?
What are you trying to achieve? Please describe it in detail.
Have you installed the latest fixes for the products?

1 Like

In WebMethods Integration Server, there is support for WmJSONAPI which has pagination support for the REST API results.

Thanks,
Sree

Also try OData - OData Adoption in webMethods - YouTube, it works like a charm for JDBC based calls.

1 Like

Hi
What product/components do you use and which version/fix level?
WM 10.5
Are you using a free trial or a product with a license?
product with a license
What are you trying to achieve? Please describe it in detail.
j exposes a Rest Webservice which returns data in the form of json from a database
Have you installed the latest fixes for the products?
yes.
actually i want to know , can with rest service i can return a large amount of data either as paging or some other way.

thank you Sreekanth