Hi @justingraff88
Here's a summary of approaches that might be useful:
-
Batching Requests: One common method to circumvent the row limitation is by making multiple API requests in batches. You can use pagination parameters (like start and limit ) to fetch data in chunks within the API's constraints, then consolidate these chunks on your side for reporting.
-
Incremental Sync: Instead of trying to pull all the data at once, implement an incremental synchronization mechanism. Fetch only the records that have changed since your last sync, based on timestamps or sequence numbers. This reduces the volume of data fetched in each operation.
-
Direct Database Connection: Some organizations opt for direct connections to their ServiceNow instance's database, assuming they have the necessary permissions and security measures in place. This approach can bypass API limitations but requires a more sophisticated setup for data access and security.
-
Custom Integration Solutions: Developing a custom integration solution, such as a middleware application that interfaces with the ServiceNow API, can help manage data retrieval and processing. This solution can automatically handle API limitations, batching, and error management.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
