> For the complete documentation index, see [llms.txt](https://docs.erathos.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.erathos.com/connectors/apis/runrun.it.md).

# Runrun.it

## Using the Erathos platform

When selecting Runrun.it as a new connector on the Erathos platform, you will need to name your connection and fill in the following form:

* **App-Key** — your Runrun.it application key, used to identify your account
* **User-Token** — your personal API token, used to authenticate API requests on your behalf

With this connection created you can seamlessly move your Runrun.it data to your BigQuery, Redshift or Postgres data warehouse.

### How to find my token?

To authenticate with the Runrun.it API, you need two credentials: an **App-Key** and a **User-Token**.

To find your **App-Key**, log in to Runrun.it and navigate to **Manage → Integrations → API Integration**. The App-Key identifies your Runrun.it account and will be displayed on the integrations page.

To generate your **User-Token**, click on your profile avatar in the top-right corner, then select **My Account → API**. Generate a new personal token if you haven't already and copy it.

Paste both credentials into the **App-Key** and **User-Token** fields on the Erathos platform and click **Save and close** to complete the setup.

## Endpoints and fields

### boards

Sync type availability: Full-refresh

Parent of [board\_stages](#board_stages)

| Field       | Type      |
| ----------- | --------- |
| id          | integer   |
| name        | text      |
| created\_at | timestamp |
| updated\_at | timestamp |

### board\_stages

Sync type availability: Full-refresh

Child of [boards](#boards)

| Field       | Type      |
| ----------- | --------- |
| id          | integer   |
| name        | text      |
| board\_id   | integer   |
| created\_at | timestamp |
| updated\_at | timestamp |

### clients

Sync type availability: Full-refresh

| Field            | Type      |
| ---------------- | --------- |
| id               | integer   |
| name             | text      |
| is\_active       | boolean   |
| organization\_id | integer   |
| created\_at      | timestamp |
| updated\_at      | timestamp |

### manual\_work\_periods

Sync type availability: Full and incremental refresh

[Cursor](https://docs.erathos.com/platform/connections/sync-types#understanding-cursors): `created_at`

| Field             | Type      | Cursor |
| ----------------- | --------- | ------ |
| id                | integer   |        |
| user\_id          | integer   |        |
| task\_id          | integer   |        |
| started\_at       | timestamp |        |
| ended\_at         | timestamp |        |
| duration\_seconds | integer   |        |
| created\_at       | timestamp | ✓      |
| updated\_at       | timestamp |        |

### projects

Sync type availability: Full-refresh

| Field       | Type      |
| ----------- | --------- |
| id          | integer   |
| name        | text      |
| client\_id  | integer   |
| is\_active  | boolean   |
| is\_public  | boolean   |
| created\_at | timestamp |
| updated\_at | timestamp |

### tags

Sync type availability: Full-refresh

| Field       | Type      |
| ----------- | --------- |
| id          | integer   |
| name        | text      |
| created\_at | timestamp |
| updated\_at | timestamp |

### task\_types

Sync type availability: Full-refresh

| Field       | Type      |
| ----------- | --------- |
| id          | integer   |
| name        | text      |
| is\_active  | boolean   |
| created\_at | timestamp |
| updated\_at | timestamp |

### tasks

Sync type availability: Full and incremental refresh

[Cursor](https://docs.erathos.com/platform/connections/sync-types#understanding-cursors): `updated_at`

| Field                      | Type      | Cursor |
| -------------------------- | --------- | ------ |
| id                         | integer   |        |
| title                      | text      |        |
| desired\_date              | timestamp |        |
| desired\_start\_date       | timestamp |        |
| desired\_delivery\_date    | timestamp |        |
| delivered\_at              | timestamp |        |
| current\_estimate\_seconds | integer   |        |
| time\_worked               | integer   |        |
| is\_working\_on            | boolean   |        |
| is\_overdue                | boolean   |        |
| project\_id                | integer   |        |
| user\_id                   | integer   |        |
| type\_id                   | integer   |        |
| board\_id                  | integer   |        |
| board\_stage\_id           | integer   |        |
| created\_at                | timestamp |        |
| updated\_at                | timestamp | ✓      |

### teams

Sync type availability: Full-refresh

| Field       | Type      |
| ----------- | --------- |
| id          | integer   |
| name        | text      |
| created\_at | timestamp |
| updated\_at | timestamp |

### users

Sync type availability: Full-refresh

| Field       | Type      |
| ----------- | --------- |
| id          | integer   |
| name        | text      |
| email       | text      |
| avatar\_url | text      |
| is\_active  | boolean   |
| is\_admin   | boolean   |
| is\_master  | boolean   |
| type        | text      |
| language    | text      |
| timezone    | text      |
| created\_at | timestamp |
| updated\_at | timestamp |

## Entity Relationships

```mermaid
erDiagram
    boards ||--o{ board_stages : "id = board_id"
    clients ||--o{ projects : "id = client_id"
    projects ||--o{ tasks : "id = project_id"
    users ||--o{ tasks : "id = user_id"
    boards ||--o{ tasks : "id = board_id"
    board_stages ||--o{ tasks : "id = board_stage_id"
    users ||--o{ manual_work_periods : "id = user_id"
    tasks ||--o{ manual_work_periods : "id = task_id"

    boards { integer id PK }
    board_stages { integer id PK }
    clients { integer id PK }
    projects { integer id PK }
    tasks { integer id PK }
    users { integer id PK }
    manual_work_periods { integer id PK }
    tags { integer id PK }
    teams { integer id PK }
    task_types { integer id PK }
```