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.