ConstructConnect today: from sandbox extract to Storage

ConstructConnect is often the first screen a Canadian construction BD team opens. Reconn2’s constructconnect-today automation logs into LeadManager, scopes to today’s public bid list, and returns structured projects for downstream graph projection.

Runtime choices

The Python service can run the OpenAI Agents SDK sandbox path (credentials injected as sandbox environment variables, never echoed into prompts) or optional alternate extractors when enabled. If the OpenAI sandbox flag is off, the automation returns a skipped status with a clear reason — better than silently writing empty files.

Artifacts

Every successful upload lands at raw-artifacts/constructconnect-today/.json. That file is the evidence you can diff when a column disappears or a filter stops applying.

Manual runs

Trigger exposes constructconnect-today-manual so operators can pass target_date and dry_run. Dry runs exercise the connector without committing storage or CRM side effects — ideal when validating credentials after a password rotation.

Why this matters for Alberta teams

Even when the data is “just” another SaaS portal, treating it like pipeline infrastructure — scheduled, audited, and projected into the same CRM as ARHCA tender scrapes — means fewer spreadsheets and fewer handoffs between research and sales.