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.
Limitations and Specifications per Collection Type
| Internal Collections | Google Sheets | Airtable | External |
Collection Number per Site | 100 Note Legacy Pro and Team plans are limited to 1 | 100 | 100 | 100 |
A single collection's data | N/A | 20MB | 20MB | 20MB |
Rows | 500 Note Legacy 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 |
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.
Note
You can use multi-language content from a single external collection using the API.