TimeCamp Data Pipeline

A data pipeline to extract TimeCamp datasets from REST API (time entries, computer activities, users, tasks, application names) and load them into various destinations (Google Big Query, S3, CSV, JSONL, Parquet, MySQL, Postgres, DuckDB, SQLite - any DLT destination).

uv run --with-requirements requirements.txt dlt_fetch_timecamp.py \
   --from 2026-01-01 --to 2026-09-26 \
   --datasets entries,tasks,users,computer_activities,application_names \
   --format jsonl \
   --custom-fields \
   --output ./output

Use --destination with a dlt destination name and install its required dlt extra. For Google BigQuery setup, see Export to BigQuery.

• Export to BigQuery - load datasets and custom fields into Google BigQuery
• Fetch Project Data to S3 - write files to S3 and query them with DuckDB
• Sample Reports - estimated vs actual time report with DuckDB
• Sample Project Cumulative vs Budgeted Report - project budget report with DuckDB

MIT