What is the record limit for a remote table in servicenow

[sanga2]

HI all,

We have created a remote table to pull the data from an external source dynamically. However, only 1000 records are being created on the remote table, where as when we check the response from the REST message the data is more than 2000 records.

Please let me know if there is a record limit of 1000 on the remote tables?

[sanga2]

So is it a configuration set up from ServiceNow not to add more than 1000 records? 

[Pradeep Sharma]

Hi @sanga - It is not a configuration setup from ServiceNow. It is recommendation/best practice to not add more than 1000 rows to avoid longer query time.

I hope this answer your question.

- Pradeep Sharma

[Pradeep Sharma]

@sanga  - Just a clarification on re: Also you cannot increase or decrease the value for it. If you want to handle this there is a possible option to do this via business rule (**only if required per use case**)

I hope this answers your question.

[Ankur Bawiskar]

@sanga 

As already mentioned in my earlier response and also from Pradeep it is not configuration but recommendation.

Also you cannot increase or decrease the value for it

Regards
Ankur

[abhijitkhewale]

Hi Sanga,

Refer below details:

sysparm_offset and sysparm_limit parameters

If you want to retrieve 10 records (sysparm_limit=10) in the record set starting from the beginning (sysparm_offset=0) of the record set.

/api/now/table/<tablename>?sysparm_limit=10&sysparm_offset=0

Then for next 10 records, you would simply increment the value of sysparm_offset by the value of your sysparm_limit

/api/now/table/tablename?sysparm_limit=10&sysparm_offset=10

/api/now/table/tablename?sysparm_limit=10&sysparm_offset=20

/api/now/table/tablename?sysparm_limit=10&sysparm_offset=30

.

.

/api/now/table/tablename?sysparm_limit=10&sysparm_offset=n

Regards,

Abhijit