REST API Get URL too long with sysparm_fields getting error

[vijayanand_chid]

We are using to import the table using /api/now/v1/table/{tableName} and we specify the list of columns required comma separated in sysparm_fields. When the columns are added the REST API Get URL gets very long and its failing in ServiceNow with the error response

<error><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 358869 to bypass the need for pagination.</detail><message>Pagination not supported</message></error>

Please let us know if there is a way to send the list of columns without getting the error, any feature to POST the columns in payload in Get API request? Or any other way to overcome this.

[vijayanand_chid]

Hi Developer Community, can any one help me with this issuue?

Regards,

Vijayanand

[Manoj Kumar16]

Hi Vijay,

The error which you are getting says that the API you are trying to call does not support pagination.

If you are using any sysparm queries in the endpoint then try to remove them and call the API.

Please go through the below link for pagination details -http://wiki.servicenow.com/index.php?title=Table_API#gsc.tab=0

Hope this helps.

[tonygresko]

Did you ever figure this out? I am having the same issue.