Customers with a custom plan can create a collection from an external database through the API.
External database collections have the following limitations:
| External | |
|---|---|
| Collection Number per Site | 100 |
| A single collection's data | 20MB |
| Fields (columns) | 100 |
| Inner collection fields | 15 |
| Collection name character limit | 50 |
| Field name character limit | 50 |
| Page item URL | 350 characters |
| Update data | Automatically |
Connect to an External Database
To connect to an external database:
- In the left panel, click Content, and then click Collections.
- Click + New Collection, and select External Database.
- Type the Endpoint URL and click Fetch collection.
- Click Continue.
- Type a name for the collection.
- Select the correct data type for each field in the collection.
- (Optional) Add additional fields.
- Click Continue.
- Import the collection.
The next step is to create or convert a Dynamic Page and connect it to your newly created collection. For more information, see Create Dynamic Pages. Or, you can connect the collection rows to regular pages. To learn how, see Connect Collection Rows to Regular Pages.