Timely

Prerequisites

1. Please follow these steps to obtain Bearer_token for your account.
2. Login into your https://app.timelyapp.com portal, fetch the account-id present in the URL (example: URL https://app.timelyapp.com/12345/calendar and account-id 12345).
3. Get a start-date to your events. Dateformat YYYY-MM-DD.

Tables in the Timely connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	events	39		Full Refresh

Table: events

No	Column Name	Type	Notes
1	note	VARCHAR
2	locked_reason	VARCHAR
3	created_at	INTEGER
4	project	VARCHAR
5	external_id	INTEGER
6	duration	VARCHAR
7	uid	VARCHAR
8	billed	BOOLEAN
9	billed_at	VARCHAR
10	draft	BOOLEAN
11	invoice_id	VARCHAR
12	entry_ids	VARCHAR
13	from	VARCHAR
14	id	INTEGER
15	locked	BOOLEAN
16	hour_rate_in_cents	DOUBLE
17	day	VARCHAR
18	timer_stopped_on	INTEGER
19	cost	VARCHAR
20	updated_from	VARCHAR
21	suggestion_id	INTEGER
22	label_ids	VARCHAR
23	user_ids	VARCHAR
24	estimated	BOOLEAN
25	estimated_duration	VARCHAR
26	billable	BOOLEAN
27	timer_started_on	INTEGER
28	manage	BOOLEAN
29	timer_state	VARCHAR
30	created_id	INTEGER
31	sequence	INTEGER
32	deleted	BOOLEAN
33	estimated_cost	VARCHAR
34	updater_id	INTEGER
35	hour_rate	DOUBLE
36	to	VARCHAR
37	user	VARCHAR
38	forecast_id	VARCHAR
39	created_from	VARCHAR

External Resources

• Steps

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.