ServiceNow Connector: Doesn't paginate through all results with an Advanced Sync Rule

[meghanmurphy1]

Bug Description

When using a ServiceNow connector with an Advanced Sync Rule, it appears the connector only processes the first batch of documents (controlled by TABLE_FETCH_SIZE which is set to 50) and then stops. This suggests the connector makes just one API call to fetch 50 documents rather than continuing to request additional matching documents. As a result, only the first 50 matching documents are inserted, regardless of how many documents actually match your Advanced Sync Rule criteria.

To Reproduce

Steps to reproduce the behavior:

1. Create an 8.17 connector
2. Configure a ServiceNow connector
3. Add an Advanced Sync Rule
   For Example:

[
  {
    "service": "User",
    "query": "active=True"
  }
]

4. Run a Full Sync- notice there's only ~50 docs inserted

Expected behavior

The ServiceNow Connector should be able to insert all documents matching the Advanced Sync Rule

[codingogre]

@meghanmurphy1 @lorenabalan @erikcurrin-elastic Create pull request. #3659