Dynamic Content: External Collections

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

100

100

100

A single collection's data

N/A

20MB

20MB

20MB

Rows

500

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:

  1. In the left panel, click Content, and then click Collections.

  2. Click + New Collection, and select External Database.

  3. Type the Endpoint URL and click Fetch collection.

  4. Click Continue.

  5. Type a name for the collection.

  6. Select the correct data type for each field in the collection.

  7. (Optional) Add additional fields.

  8. Click Continue.

  9. Import the collection.