Runrun.it

Connect your Runrun.it platform to your data warehouse. Sync tasks, projects, clients, users, and boards to BigQuery, Redshift, Postgres, Databricks, and more.

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

Field	Type
id	integer
name	text
created_at	timestamp
updated_at	timestamp

board_stages

Sync type availability: Full-refresh

Child of 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: 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: 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