api

# Glide API

## API Overview

### Two Ways to Access Data

1. **REST API v2** - Direct HTTP calls to `api.glideapps.com`
2. **@glideapps/tables** - Official npm package (simpler for JavaScript/TypeScript)

### Important Limitations

- **Big Tables Only**: API v2 only works with Glide Big Tables, not native app tables
- **Team Scope**: API operates at team level, not app level
- **Quota Costs**: Read/write operations consume updates from your plan
- **Row Limits**: Big Tables support up to 10 million rows
- **Aggregation Limits**: Rollups/Lookups limited to 100 matching rows in Big Tables
- **Computed Column Limits**: Some computed column types can't be filtered/sorted (see below)

## Getting Your API Token

1. Open any app in Glide Builder
2. Go to **Data** tab
3. Click **Show API** button (bottom of data grid)
4. Click **Copy secret token**

Store token securely - never commit to version control.

## REST API v2

### Base URL
```
https://api.glideapps.com/
```

### Authentication
```
Authorization: Bearer YOUR_API_TOKEN
```

### Endpoints

| Method | Endpoint | Description |
|--------|----------|-------------|
| GET | `/tables` | List all Big Tables |
| POST | `/tables` | Create new Big Table |
| GET | `/tables/{tableID}/rows` | Get rows |
| GET | `/tables/{tableID}/rows/{rowID}` | Get single row |
| HEAD | `/tables/{tableID}/rows` | Get table version |
| POST | `/tables/{tableID}/rows` | Add rows |
| PATCH | `/tables/{tableID}/rows/{rowID}` | Update row |
| PUT | `/tables/{tableID}` | Overwrite table |
| DELETE | `/tables/{tableID}/rows/{rowID}` | Delete row |

### Example: List Tables

```bash
curl -X GET "https://api.glideapps.com/tables" \
  -H "Authorization: Bearer YOUR_API_TOKEN" \
  -H "Content-Type: application/json"
```

### Example: Get Rows

```bash
curl -X GET "https://api.glideapps.com/tables/TABLE_ID/rows" \
  -H "Authorization: Bearer YOUR_API_TOKEN" \
  -H "Content-Type: application/json"
```

### Example: Create Table

Create a new Big Table with