I am trying to integrate servicenow with SAP with flow designer using custom action

saylibhat08
Kilo Contributor

‎05-21-2025 12:41 AM

I am trying to integrate servicenow with SAP with flow designer using custom action but data coming from SAP is more than 5 mb and there is no paging support from SAP side..So is there any other way to fetch the data from SAP using script include ..

description: need to fetch data from SAP then store it into the staging table created by import set and then move it to the target table..(one REST message contains no of post HTTP methods having different end points that fetch differnt data fields from SAP and the input payload is already define in each HTTP method ).

input payload:{
"EmployeeAndManagerReq": {
"From": "",
"To": "",
"Condition": "EmpNumber",
"Value": "01008441",
"OrgUnitCode": ""
}
}

0 Helpfuls
  • 215 Views
1 REPLY 1

Vishal36
Mega Guru

‎06-03-2025 12:08 AM

Hi @saylibhat08, 

With no paging option, you can simulate paging by loading records created or updated in 7 days from January 1 till January 7th, (and then keep sliding the window) OR page using IDs. 

If your goal is to set up a robust, scalable integration between ServiceNow and SAP, OpsHub Integration Manager (OIM) can help.

As a ServiceNow Partner, OIM supports:

  • Structured, no-code integration with SAP and 70+ other systems
  • Bi-directional data exchange with support for large payloads, retries, and field-level mapping
  • Staging and target table management, without custom scripts
  • Audit-ready traceability and simplified ongoing maintenance

It’s designed for enterprise-grade use cases like yours—so you can avoid fragile scripts and move towards a more reliable integration framework.

Hope it helps! 

0 Helpfuls