ServiceNow Connection - data request URL too long for pagination

Hi,

So we've encountered an issue after setting up a connection between data-factory and ServiceNow. Our team has been trying to query a really big table (alm_asset) from our ServiceNow instance - and when we try to add Pagination to be anyhting but empty, for some reason DataFactory lists all of the columns to be queried.

Now that column query list we couldn't find, and our REST request could not be executed because of the too long url, so pagination could not fit.

The API request to ServiceNow failed. Request Url : -- removed -- , Status Code: BadRequest, Error message: {"error":{"message":"Pagination not supported","detail":"The requested query is too long to build the response pagination header URLs. Please do one of the following: shorten the sysparm_query, or query without pagination by setting the parameter 'sysparm_suppress_pagination_header' to true, or set 'sysparm_limit' with a value larger then 4182 to bypass the need for pagination."},"status":"failure"}

This 4182 is just a on a sub-production instance, on produciton instance we have significantly more data.

Can somebody help how to edit the params sent for the REST API through that connector?