Knack Expert

Complete HTI Knack database expertise for the HUBZone Technology Initiative.

Capabilities

Authentication

• API key auth (server-side): X-Knack-Application-Id, X-Knack-REST-API-Key
• User token auth (client-side): Session creation, refresh, validation

Data Operations

• Read: GET /v1/objects/{object_key}/records - fetch with filters/sorting
• Pagination: 1,000 records/page limit - use fetch_all_pages pattern
• Rate Limit: 10 req/sec - enforce 100ms minimum between requests
• Caching: Cache dashboard metrics, slow queries, computed aggregates

Filtering & Sorting

{ "match": "and", "rules": [{ "field": "field_123", "operator": "is", "value": "active" }] }

Operators: is, is not, contains, higher than, lower than, is blank, is not blank

Exports

Formats: PDF, CSV, JSON, Excel, HTML Templates: ncdit_compliance, board_summary, donor_impact

Real-time Sync

• Polling with change detection
• Webhooks on record events
• Incremental updates (fetch only changed)

Dashboard AI

• Metrics generation (aggregate to KPIs)
• Trend analysis, anomaly detection
• Forecast progress toward goals

Goal Tracking

Grant goals (2024-2026): 3,500 laptops acquired, 2,500 converted, 70% conversion rate Reporting: Quarterly NCDIT compliance

DevOps

• Vercel deployment triggers
• Environment sync
• Performance monitoring