What's the size limitation for records in custom objects in Application Composer?
Use this topic to understand the size limitation on the number of records that custom objects can hold.
The total amount of records of all types of objects whether standard or custom is limited to the numbers described in the cloud service description document.
Custom objects limit for UI
You can target a maximum number of 180,000 records per user. A record is defined as a data record within standard and custom objects stored in the cloud service environment. For exact information, refer the numbers described in the cloud service description document on https://www.oracle.com/.
Custom object limit for REST API
For most
resources, the predefined query limit to retrieve the records is set by default to
500 rows or a similar value. If you need to retrieve more records than the set
limit, you can do so in batches using the limit and
offset parameters. For example, if you've about 1000 records,
you can retrieve them in batches of 200 rows using a series of GET
requests:
/crmRestApi/resources/latest/subscriptionProducts?offset=0&limit=200/crmRestApi/resources/latest/subscriptionProducts?offset=200&limit=200/crmRestApi/resources/latest/subscriptionProducts?offset=400&limit=200/crmRestApi/resources/latest/subscriptionProducts?offset=600&limit=200/crmRestApi/resources/latest/subscriptionProducts?offset=800&limit=200For more information on the limit in REST API, see Manage Collections.