Process Service Now requests and save to database

Products

• CA Process Automation Base

Issue/Introduction

Looking for guidance on how to process ServiceNow (SNOW) requests and save them to a database

Environment

Process Automation 4.3.x and 4.4.x

Resolution

Recommended to use the REST API calls from ITPAM to get the SNOW data and then use the bulk ITPAM insert operator to insert the data into the database.

The bulk insert operator will save a number of transactions and the REST APIs with pagination and loop with delay will control the CPU usage.