ServiceNow - Getting all records

Solution 1:

Also see this stack overflow answer which provides info. Get ServiceNow Records Powershell - More than 250

Note that returning a large number of records can affect performance of the response and it may be more efficient to process your query in batches using offsets (i.e., get 1-100, then 101-200, ...). This can be achieved by using a sort order and offset. The ServiceNow REST Table API actually returns link headers from Get requests providing you links for the first, next and last set of records making it easy to know the url to query the next batch of records.

See: http://wiki.servicenow.com/index.php?title=Table_API#Methods and look under 'Response Header'.

Solution 2:

Have u tried to pass/override __limit parameter?

Google / wiki / Users manual / Release notes are always helpful