{"ok":true,"airtable":{"bases":{"finance":{"baseIdPrefix":"app","configured":true,"detectedTables":["Revenue Records","Expense Records","Customer Invoices","Vendor Bills","Payments","Refunds","Purchase Orders","Margin Records","Quote Profitability","Monthly P&L Snapshots","Cash Flow Forecast","QuickBooks Sync Log"],"errors":[],"expectedTables":["Vendor Bills","Cash Flow Forecast","Expense Records","Customer Invoices","Margin Records","Payments","Monthly P&L Snapshots","Purchase Orders","QuickBooks Sync Log","Quote Profitability","Refunds","Revenue Records"],"mappings":[{"actualTableName":"Vendor Bills","logicalName":"bills","missingRecommendedFields":[],"status":"mapped","title":"Vendor Bills"},{"actualTableName":"Cash Flow Forecast","logicalName":"cash-flow","missingRecommendedFields":[],"status":"mapped","title":"Cash Flow Forecast"},{"actualTableName":"Expense Records","logicalName":"expenses","missingRecommendedFields":[],"status":"mapped","title":"Expense Records"},{"actualTableName":"Customer Invoices","logicalName":"invoices","missingRecommendedFields":[],"status":"mapped","title":"Customer Invoices"},{"actualTableName":"Margin Records","logicalName":"margins","missingRecommendedFields":[],"status":"mapped","title":"Margin Records"},{"actualTableName":"Payments","logicalName":"payments","missingRecommendedFields":[],"status":"mapped","title":"Payments"},{"actualTableName":"Monthly P&L Snapshots","logicalName":"pl-snapshots","missingRecommendedFields":[],"status":"mapped","title":"Monthly P&L Snapshots"},{"actualTableName":"Purchase Orders","logicalName":"purchase-orders","missingRecommendedFields":[],"status":"mapped","title":"Purchase Orders"},{"actualTableName":"QuickBooks Sync Log","logicalName":"quickbooks-sync-log","missingRecommendedFields":[],"status":"mapped","title":"QuickBooks Sync Log"},{"actualTableName":"Quote Profitability","logicalName":"quote-profitability","missingRecommendedFields":[],"status":"mapped","title":"Quote Profitability"},{"actualTableName":"Refunds","logicalName":"refunds","missingRecommendedFields":["Approval Status","Approved By"],"status":"mapped","title":"Refunds"},{"actualTableName":"Revenue Records","logicalName":"revenue","missingRecommendedFields":[],"status":"mapped","title":"Revenue Records"}],"metadataAvailable":true,"missingTables":[],"reachable":true},"marketing":{"baseIdPrefix":"app","configured":true,"detectedTables":["Table 1","Campaign Writers","Email Activity Tracker","Loyalty Program Tracker","Customer Feedback","Content Management","Campaign Performance","Content Performance","Partnerships Impact Tracker","Reward Claims","CRM (Master)"],"errors":[],"expectedTables":["Campaign Performance","Campaign Writers","Content Management","Content Performance","Customer Feedback","Email Activity Tracker","Loyalty Program Tracker","Partnerships Impact Tracker","Reward Claims","CRM (Master)"],"mappings":[{"actualTableName":"Campaign Performance","logicalName":"CAMPAIGN_PERFORMANCE","missingRecommendedFields":[],"status":"mapped","title":"Campaign Performance"},{"actualTableName":"Campaign Writers","logicalName":"CAMPAIGN_WRITERS","missingRecommendedFields":[],"status":"mapped","title":"Campaign Writers"},{"actualTableName":"Content Management","logicalName":"CONTENT_MANAGEMENT","missingRecommendedFields":[],"status":"mapped","title":"Content Management"},{"actualTableName":"Content Performance","logicalName":"CONTENT_PERFORMANCE","missingRecommendedFields":[],"status":"mapped","title":"Content Performance"},{"actualTableName":"CRM (Master)","logicalName":"CRM_MASTER","missingRecommendedFields":[],"status":"mapped","title":"CRM (Master)"},{"actualTableName":"Customer Feedback","logicalName":"CUSTOMER_FEEDBACK","missingRecommendedFields":[],"status":"mapped","title":"Customer Feedback"},{"actualTableName":"Email Activity Tracker","logicalName":"EMAIL_ACTIVITY","missingRecommendedFields":[],"status":"mapped","title":"Email Activity Tracker"},{"actualTableName":"Loyalty Program Tracker","logicalName":"LOYALTY_PROGRAM","missingRecommendedFields":[],"status":"mapped","title":"Loyalty Program Tracker"},{"actualTableName":"Partnerships Impact Tracker","logicalName":"PARTNERSHIPS","missingRecommendedFields":[],"status":"mapped","title":"Partnerships Impact Tracker"},{"actualTableName":"Reward Claims","logicalName":"REWARD_CLAIMS","missingRecommendedFields":[],"status":"mapped","title":"Reward Claims"}],"metadataAvailable":true,"missingTables":[],"reachable":true},"operations":{"baseIdPrefix":"app","configured":true,"detectedTables":["Product Dataset","Active Orders Tracker","Customer Issues","Returns & Refunds","Purchase Orders","Feedback","Master Orders","Bill of Laden","Packaging List","CS&X Team","Policy Question Log","Web Issues","Case Reviews & Learning Log","Production Tracker (Item-Level Status Table)","Manufacturer Directory"],"errors":[],"expectedTables":["CRM Failure Events","Follow-Up Tasks","Promise Validation Queue","Proposal Gate Queue","Quote / Supplier / Payment Blockers","Revenue War Room Items","Weekly Sales Review Items"],"mappings":[{"actualTableName":null,"logicalName":"CRM_FAILURE_EVENTS","missingRecommendedFields":["Failure Type","Severity","Account","Opportunity","Recovery Status","Final Lesson"],"status":"missing","title":"CRM Failure Events"},{"actualTableName":"Customer Issues","logicalName":"CUSTOMER_ISSUES","missingRecommendedFields":["Customer","Owner","Status","Priority","Notes"],"status":"mapped","title":"Customer Issues / CRM Failures"},{"actualTableName":null,"logicalName":"FOLLOW_UP_TASKS","missingRecommendedFields":["Account","Contact","Task Type","Owner","Due Date","Status"],"status":"missing","title":"Follow-Up Tasks"},{"actualTableName":"Manufacturer Directory","logicalName":"MANUFACTURERS","missingRecommendedFields":["Category","Primary Contact"],"status":"mapped","title":"Manufacturers / Suppliers"},{"actualTableName":"Active Orders Tracker","logicalName":"ORDERS","missingRecommendedFields":["Order Number","Customer","Status","Owner","Due Date"],"status":"mapped","title":"Orders / Fulfillment"},{"actualTableName":null,"logicalName":"PROCESSING_NOTES","missingRecommendedFields":["Related Order","Owner","Status","Note","Updated At"],"status":"missing","title":"Processing Notes"},{"actualTableName":"Production Tracker (Item-Level Status Table)","logicalName":"PRODUCTION_TRACKER","missingRecommendedFields":["Item","Order","Supplier","ETA","Notes"],"status":"mapped","title":"Production / Supplier Flow"},{"actualTableName":null,"logicalName":"PROMISE_VALIDATION_QUEUE","missingRecommendedFields":["Account","Opportunity","Promise Text","Risk Level","Validation Owner","Validation Status"],"status":"missing","title":"Promise Validation Queue"},{"actualTableName":null,"logicalName":"PROPOSAL_GATE_QUEUE","missingRecommendedFields":["Account","Opportunity","Requested Asset","Approval Status","Approved By","Notes"],"status":"missing","title":"Proposal Gate Queue"},{"actualTableName":null,"logicalName":"QUOTE_SUPPLIER_PAYMENT_BLOCKERS","missingRecommendedFields":["Opportunity","Blocker Type","Revenue at Risk","Owner","Status","Next Action"],"status":"missing","title":"Quote / Supplier / Payment Blockers"},{"actualTableName":null,"logicalName":"REVENUE_WAR_ROOM_ITEMS","missingRecommendedFields":["Item Type","Priority","Account","Opportunity","Assigned Owner","Due Date","Status"],"status":"missing","title":"Revenue War Room Items"},{"actualTableName":null,"logicalName":"WEEKLY_SALES_REVIEW_ITEMS","missingRecommendedFields":["Week","Metric","Value","Owner","Decision","Due Date","Status"],"status":"missing","title":"Weekly Sales Review Items"}],"metadataAvailable":true,"missingTables":["CRM Failure Events","Follow-Up Tasks","Promise Validation Queue","Proposal Gate Queue","Quote / Supplier / Payment Blockers","Revenue War Room Items","Weekly Sales Review Items"],"reachable":true},"sales":{"baseIdPrefix":"app","configured":true,"detectedTables":["Table 1","Opportunity Tracker","Lead Intake","QB Quote / PO #","Customer Feedback Tracker","Customer Management","Objection Management","Opportunity Analysis"],"errors":[],"expectedTables":["CRM (Master)","Leads","Opportunities","Accounts","Contacts","Sales Activities","Follow-Up Tasks","Proposal Gates","Quote Events","Promise Events"],"mappings":[{"actualTableName":null,"logicalName":"ACCOUNTS","missingRecommendedFields":["Account Name","Owner","Segment","Status","Notes"],"status":"missing","title":"Accounts"},{"actualTableName":null,"logicalName":"CONTACTS","missingRecommendedFields":["Contact Name","Email","Phone","Account","Owner","Role"],"status":"missing","title":"Contacts"},{"actualTableName":"Customer Management","logicalName":"CRM_MASTER","missingRecommendedFields":["Email","Phone Number","Company Name","Assigned Luzione Rep","Relationship Stage","Next Action Due","Follow-up Notes","VIP Flag"],"status":"mapped","title":"Customer Management / CRM"},{"actualTableName":null,"logicalName":"FOLLOW_UP_TASKS","missingRecommendedFields":["Account","Contact","Owner","Task Summary","Due Date","Status"],"status":"missing","title":"Follow-Up Tasks"},{"actualTableName":"Lead Intake","logicalName":"LEADS","missingRecommendedFields":["Lead Name","Phone","Company","Status","Assigned Rep"],"status":"mapped","title":"Lead Intake"},{"actualTableName":"Objection Management","logicalName":"OBJECTIONS","missingRecommendedFields":["Objection","Context","Owner","Status","Recommended Response","Notes"],"status":"mapped","title":"Objection Management"},{"actualTableName":"Opportunity Tracker","logicalName":"OPPORTUNITIES","missingRecommendedFields":["Account / Customer","Contact","Stage","Amount","Next Step","Next Step Due"],"status":"mapped","title":"Opportunity Tracker"},{"actualTableName":null,"logicalName":"PROMISE_EVENTS","missingRecommendedFields":["Account","Opportunity","Promise Type","Promise Text","Risk Level","Status"],"status":"missing","title":"Promise Events"},{"actualTableName":null,"logicalName":"PROPOSAL_GATES","missingRecommendedFields":["Account","Opportunity","Requested Asset","Total Gate Score","Approval Status","Approved By"],"status":"missing","title":"Proposal Gates"},{"actualTableName":null,"logicalName":"QUOTE_EVENTS","missingRecommendedFields":["Opportunity","Quote Status","Owner","Next Action","Due Date","Notes"],"status":"missing","title":"Quote Events"},{"actualTableName":null,"logicalName":"SALES_ACTIVITIES","missingRecommendedFields":["Activity Type","Account / Customer","Contact","Opportunity","Owner","Date","Notes"],"status":"missing","title":"Sales Activities"}],"metadataAvailable":true,"missingTables":["CRM (Master)","Leads","Opportunities","Accounts","Contacts","Sales Activities","Follow-Up Tasks","Proposal Gates","Quote Events","Promise Events"],"reachable":true}},"hasToken":true,"message":"At least one Airtable base is configured and reachable.","ok":true,"tokenSource":"env"},"cards":[{"configured":true,"key":"Airtable Sales","lastEvent":null,"lastTest":"Connected","missingEnvVars":[],"nextAction":"Map additional sales tables as the CRM deepens.","reachable":true},{"configured":true,"key":"Airtable Marketing","lastEvent":null,"lastTest":"Connected","missingEnvVars":[],"nextAction":"Keep marketing fields aligned with the normalized cockpit views.","reachable":true},{"configured":true,"key":"Airtable Operations","lastEvent":null,"lastTest":"Connected","missingEnvVars":[],"nextAction":"Add War Room and blocker tables when the command layer is ready.","reachable":true},{"configured":true,"key":"Airtable Finance","lastEvent":null,"lastTest":"Connected","missingEnvVars":[],"nextAction":"Create Quote Profitability and Margin Records first.","reachable":true},{"configured":true,"key":"Shopify","lastEvent":null,"lastTest":"Connected • Last order sync 2026-07-12T03:23:12.000Z","missingEnvVars":[],"nextAction":"Sync stale domains: products, orders.","reachable":true},{"configured":false,"key":"n8n","lastEvent":null,"lastTest":"Not connected","missingEnvVars":["N8N_WEBHOOK_CRM_EVENT_URL"],"nextAction":"Add the n8n webhook URL and secret for live event delivery.","reachable":false},{"configured":false,"key":"Gmail / ESP","lastEvent":null,"lastTest":"Placeholder","missingEnvVars":[],"nextAction":"Connect Gmail or an ESP before moving from manual draft generation to real sequence sending.","reachable":false},{"configured":false,"key":"LinkedIn Manual Assist","lastEvent":null,"lastTest":"Manual only","missingEnvVars":[],"nextAction":"Keep this as human-in-the-loop assist. Do not automate scraping or policy-breaking behavior.","reachable":false},{"configured":false,"key":"QuickBooks","lastEvent":null,"lastTest":"Placeholder","missingEnvVars":["QUICKBOOKS_CLIENT_ID"],"nextAction":"Wire invoices, bills, payments, and sync logs after finance base lands.","reachable":false},{"configured":false,"key":"Google Analytics","lastEvent":null,"lastTest":"Placeholder","missingEnvVars":[],"nextAction":"Connect sessions, conversions, and attribution once the marketing performance model is ready.","reachable":false},{"configured":false,"key":"Pinterest","lastEvent":null,"lastTest":"Placeholder","missingEnvVars":[],"nextAction":"Wire publishing and performance after calendar workflows settle.","reachable":false},{"configured":true,"key":"Postgres","lastEvent":null,"lastTest":"Configured","missingEnvVars":[],"nextAction":"Apply the shadow-ledger migration and start writing integration events there.","reachable":true}],"recentEvents":[],"recentEventsMode":"memory","shopifyConnected":true}