Skip to main content

ServiceNow Incoming REST Response: handling large response with pagination

 example looping through each page of the request data set

var r = new sn_ws.RESTMessageV2('<rest_msg_name>'); var header = r.getRequestHeader("Accept"); var authorization = r.getRequestHeader("Authorization"); r.setStringParameterNoEscape("aParam", aParam); r.setQueryParameter('aParam2', aParam); r.setQueryParameter('per_page', '20'); r.setQueryParameter('page', '1'); var resp = r.execute(); var responseBody = resp.haveError() ? resp.getErrorMessage() : resp.getBody(); var httpStatus = resp.getStatusCode(); var objC = JSON.parse(responseBody); var cPagiNation = objC.pagination.pages; for (var cP = 1; cP <= cPagiNation; cP++) { var r2 = new sn_ws.RESTMessageV2(restName, '<rest_msg_name>'); var header = r2.getRequestHeader("Accept"); var authorization = r2.getRequestHeader("Authorization"); r2.setStringParameterNoEscape("aParam3", aParam3); r2.setQueryParameter('page', cP); var resp2 = r2.execute(); var responseBody2 = resp2.haveError() ? resp2.getErrorMessage() : resp2.getBody(); var httpStatus2 = resp2.getStatusCode(); ... }



see also
https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0727636
 
 

https://developer.servicenow.com/dev.do#!/learn/courses/paris/app_store_learnv2_rest_paris_rest_integrations/app_store_learnv2_rest_paris_data_stream_actions/app_store_learnv2_rest_paris_request_pagination_setup_step




(ServiceNow )


 

Comments

Post a Comment

Popular posts from this blog

Get URL Parameter - server side script (portal or classic UI)

Classic UI : var sURL_editparam = gs . action . getGlideURI (). getMap (). get ( ' sysparm_aparameter ' ); if ( sURL_editparam == 'true' ) { gs . addInfoMessage ( 'parameter passed ); } Portal : var sURL_editparam = $sp . getParameter ( " sysparm_aparameter " ); if ( sURL_editparam == 'true' ) { gs . addInfoMessage ( 'parameter passed ); }

ServiceNow check for null or nil or empty (or not)

Haven't tested these all recently within global/local scopes, so feel free to have a play! option 1 use an encoded query embedded in the GlideRecord , e.g.  var grProf = new GlideRecord ( 'x_cls_clear_skye_i_profile' ); grProf . addQuery ( 'status=1^ owner=NULL ' ); grProf . query (); even better use the glideRecord  addNotNullQuery or addNullQuery option 2 JSUtil.nil / notNil (this might be the most powerful. See this link ) example: if ( current . operation () == 'insert' && JSUtil . notNil ( current . parent ) && ! current . work_effort . nil ())  option 3 there might be times when you need to get inside the GlideRecord and perform the check there, for example if the code goes down 2 optional routes depending on null / not null can use gs.nil : var grAppr = new GlideRecord ( 'sysapproval_approver' ); var grUser = new GlideRecord ( 'sys_user' ); if ( grUser . get ( 'sys_id' , current . approver )){