How is 1000 record limit on Remote Table defined?

[Foster Hardie]

The documentation stipulates that we should not add more than 1000 records to a remote table. There is also a hard limit, but it is not documented. It is not clear if the limit is from a sys_properties record or if it is hard-coded somewhere.

BTW, our use case is to show data from cmdb_ci, then call an API to embellish it. We will have other use cases when we don't call an API at all, but want to take advantage of the on-read manipulation available in Remote Tables. We can add our own throttle to make sure we're using the API reasonably, and providing adequate performance for the user and would like the option of showing more than 1000 records in certain circumstances.

[MMeyer]

Thanks Foster Hardie, you saved my day 😀

[michaeltillman]

Tried this and it didnt work. a litle late but any suggestions?

[gauravdharm]

If the data size that is retrieved from the external source is small, use the 1000 rows default limit in a remote table to minimize query times. You can use the Extended Capacity feature if the retrieved data size is large and can be less performative.

ServiceNow Doc: https://docs.servicenow.com/bundle/xanadu-servicenow-platform/page/administer/remote-tables/task/cre...