Customers with a custom plan can create a collection from an external database through the API. This can be done through the user interface or by following the instructions in the API Documentation.
External collections can serve as a collection allowing you to create Dynamic Pages (see Dynamic Content: Dynamic Pages) as well as enhance regular pages. Using a collection on a regular page is similar to how Connected Data is used with the site's Business Info (see Dynamic Content: Collections for Regular Pages). For more information on Connected Data with Business Info, see Dynamic Content: Business Info, Text, and Images.
|
Internal Collections |
Google Sheets |
Airtable |
External |
|
|---|---|---|---|---|
|
Collection Number per Site |
100 NoteLegacy Pro and Team plans are limited to 1 |
100 |
100 |
100 |
|
A single collection's data |
N/A |
20MB |
20MB |
20MB |
|
Rows |
500 NoteLegacy Pro and Team plans are limited to 10 |
N/A |
N/A |
N/A |
|
Fields (columns) |
50 |
100 |
100 |
100 |
|
Collection name character limit |
50 |
50 |
50 |
50 |
|
Field name character limit |
50 |
50 |
50 |
50 |
|
Page item URL character limit |
350 |
350 |
350 |
350 |
|
Text field character limit |
5000 |
N/A |
N/A |
N/A |
|
Inner collection Rows |
Not supported |
Not supported |
Supported |
N/A |
|
Image Collection |
Supported |
N/A |
N/A |
N/A |
|
Update data |
Site/content library publish |
Automatically |
Automatically every hour |
Automatically |
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.
Note
You can use multi-language content from a single external collection using the API. For more information, see the Developer Portal.