Introduction to APITable

APITable is an API-oriented multi-dimensional spreadsheet platform that combines visual databases, spreadsheets, real-time collaboration, and low-code development capabilities. It enables users without programming knowledge to build custom business systems and manage data efficiently through a visual interface.

Deploying APITable with Docker

Before installation, ensure your system meets the following requirements:

• Docker and Docker Compose v2 installed
• Minimum 4 CPU cores and 8GB RAM recommended
• Bash shell with curl utility available
• Note: ARM64 container images may have performance limitations

Open a terminal and execute the installation script:

curl https://apitable.github.io/install.sh | bash

The initialization process may take several minutes to start all services. Once completed, access the application at http://localhost:80.

For testing purposes, you can also use the all-in-one Docker image:

sudo docker run -d -v ${PWD}/.data:/apitable -p 80:80 --name apitable apitable/all-in-one:latest

After deployment, navigate to localhost:80 in your browser to access the APITable login interface.

Installing Cpolar for Network Tunneling

Cpolar enables secure tunneling to expose local services to the public internet. Install it using the automated script:

curl -L https://www.cpolar.com/static/downloads/install-release-cpolar.sh | sudo bash

Start the cpolar service:

sudo systemctl start cpolar
sudo systemctl enable cpolar

Verify the installation:

cpolar version

Authenticate with your account token (obtained from the cpolar dashboard after registration):

cpolar authtoken YOUR_AUTH_TOKEN

Access the cpolar web interface at http://localhost:9200 and log in with your credentials.

Creating a Public Tunnel for APITable

Navigate to Tunnel Management → Create Tunnel and configure the following parameters:

• Tunnel Name: apitable-remote (or your preferred name)
• Protocol: HTTP
• Local Address: 80
• Domain Type: Random domain (free tier)
• Region: Select nearest server

Click Create to establish the tunnel. Navigate to Status → Online Tunnel List to view the generated public URLs (both HTTP and HTTPS variants).

Use the HTTPS URL to access your APITable instance from any device. The tunnel provides public access without requiring a dedicated cloud server.

Configuring a Fixed Public Domain

Free tier tunnels generate random URLs that change on restart. For a stable address, upgrade to a paid plan and configure a reserved subdomain or connect your custom domain. In the tunnel configuration, select Reserved Subdomain or Custom Domain as the domain type, then enter your chosen subdomain or domain name.