question What is the record limit for a remote table in servicenow in Developer forum

What is the record limit for a remote table in servicenow

sanga2 — Wed, 28 Oct 2020 09:17:10 GMT

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?

Re: What is the record limit for a remote table in servicenow

Priyanka Vasant — Wed, 28 Oct 2020 10:39:05 GMT

Hi Sanga,

Find the below link that might help you.

Benefits of Remote Tables

Regards,

Priyanka

Re: What is the record limit for a remote table in servicenow

sanga2 — Wed, 28 Oct 2020 10:48:58 GMT

Hi Priyanka,

Thanks for the reply. I have already checked it. But nowhere it is mentioned as limit of 1000 records there.

Re: What is the record limit for a remote table in servicenow

Ankur Bawiskar — Wed, 28 Oct 2020 11:01:17 GMT

@sanga

As per docs it is recommendation not to add more than 1000 rows to remote table.

I don't think any configuration allow us to change it to lower or higher value

Regards
Ankur

Re: What is the record limit for a remote table in servicenow

sanga2 — Wed, 28 Oct 2020 11:07:29 GMT

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

Re: What is the record limit for a remote table in servicenow

Priyanka Vasant — Wed, 28 Oct 2020 11:12:45 GMT

Its mentioned as “All data that is retrieved from the external source lives in the memory, so make sure that your data set is small. To minimize query times, don’t add more than 1000 rows to a remote table.”

Re: What is the record limit for a remote table in servicenow

Pradeep Sharma — Thu, 29 Oct 2020 01:16:50 GMT

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

Re: What is the record limit for a remote table in servicenow

abhijitkhewale — Thu, 29 Oct 2020 01:40:32 GMT

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

Re: What is the record limit for a remote table in servicenow

Ankur Bawiskar — Thu, 29 Oct 2020 04:33:05 GMT

@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

Re: What is the record limit for a remote table in servicenow

Pradeep Sharma — Thu, 29 Oct 2020 04:36:31 GMT

@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.