My requirement is to fetch the XXX records (Sometimes 100+) from DB, convert into json and send response thru setresponse as this is rest call. My question is how to achieve pagination for sending large amount of data in response? My Source is third party vendor and they want the response to be paginated in webmethods if the response data contains large amount of data.
Can someone please help me to how to achieve this? Do I need to write java service or Can I handle it in DB/setresponse calls?