DATA Source REST API: How to call pagination wise records through REST API

SN Emy
Tera Guru

‎03-12-2023 01:48 PM - edited ‎03-12-2023 03:00 PM

Hey,

I am trying to retrieve all records for a Paginated API using the REST Data source type and the integration works fine and returns the first 500 items (off 780). However, I am not sure how to gain all the records from each page without defining a new REST call for each one? PAYLOAD --- {"category":"server-hardware","count":500,.....,"start":0,"total":784,"prevPageUri":null,"nextPageUri":"/rest/server-hardware?count=500&start=0500&sort=name:asc"

SNEmy_0-1678658429515.png

 

Thanks,

0 Helpfuls
  • 734 Views
3 REPLIES 3

Community Alums
Not applicable

‎03-12-2023 02:25 PM

Have you attempted with stream writer ?

https://developer.servicenow.com/dev.do#!/reference/api/tokyo/server/sn_ws-namespace/c_RESTAPIRespon...

0 Helpfuls

SN Emy
Tera Guru
In response to Community Alums

‎03-12-2023 03:01 PM

I am using a data source with flow design. 

Thanks,

 

0 Helpfuls

Community Alums
Not applicable
In response to SN Emy

‎03-13-2023 05:14 AM - edited ‎03-13-2023 05:17 AM

Got it,

I tested with this KB article last December and it worked fine for us (but for data stream) - https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0756552 .

As of data source - here is another KB - https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0952044

0 Helpfuls