clari-upgrade-migration

# Clari Upgrade & Migration ## Overview Handle Clari API changes: version migrations, export schema updates, and Copilot API adoption. ## Instructions ### Step 1: Check Current API Version ```bash # v4 is the current version curl -s -H "apikey: ${CLARI_API_KEY}" \ https://api.clari.com/v4/export/forecast/list | jq . # If using v3 (deprecated), migrate to v4 ``` ### Step 2: Schema Change Detection ```python def detect_schema_changes( current_export: dict, expected_fields: set[str] ) -> dict: if not current_export.get("entries"): return {"status": "empty", "changes": []} actual_fields = set(current_export["entries"][0].keys()) new_fields = actual_fields - expected_fields removed_fields = expected_fields - actual_fields return { "status": "changed" if new_fields or removed_fields else "compatible", "new_fields": list(new_fields), "removed_fields": list(removed_fields), } # Track expected schema EXPECTED_FIELDS = { "ownerName", "ownerEmail", "forecastAmount", "quotaAmount", "crmTotal", "crmClosed", "adjustmentAmount", "timePeriod" } ``` ### Step 3: Database Schema Migration ```sql -- Add new columns when Clari adds export fields ALTER TABLE clari_forecasts ADD COLUMN IF NOT EXISTS new_field_name VARCHAR; -- Backfill historical data UPDATE clari_forecasts SET new_field_name = 'default' WHERE new_field_name IS NULL; ``` ### Rollback Keep the previous client version alongside the new one until migr...