{"endpoint": "/api/timeclock/aggregates", "group_by": ["user_id", "org_id"], "conditions": {"isdeleted": false}, "date_field": "clocked_at", "primary_key": "time_clock_aggregate_id", "upsert_keys": ["user_id", "start_date", "end_date"], "aggregations": {"end_date": "FROM_FILTER", "start_date": "FROM_FILTER", "total_net_hours": "0.0", "total_days_worked": "COUNT(DISTINCT clocked_at::date)", "total_payable_hours": "0.0", "total_regular_hours": "0.0", "total_overtime_hours": "0.0"}, "source_table": "time_clocks", "target_table": "time_clock_aggregates", "date_range_source": "filter", "require_date_filter": true}