List marketing data sources

{
  "type": "object",
  "required": [
    "has_any_data",
    "integrations",
    "issues_summary",
    "overall_status"
  ],
  "properties": {
    "has_any_data": {
      "type": "boolean",
      "description": "True if any integration synced rows in the last 7 days"
    },
    "integrations": {
      "type": "array",
      "description": "One health entry per native integration",
      "items": {
        "type": "object",
        "required": [
          "connected",
          "diagnosis",
          "display_name",
          "fix_suggestion",
          "is_native",
          "last_error",
          "last_sync_at",
          "last_sync_status",
          "required_tables",
          "rows_last_24h",
          "rows_last_7d",
          "schema_columns_mapped",
          "schema_columns_required_missing",
          "schemas_url",
          "settings_url",
          "source_type",
          "sources_map_present"
        ],
        "properties": {
          "connected": {
            "type": "boolean",
            "description": "Whether a live source of this type is connected"
          },
          "diagnosis": {
            "type": "string",
            "description": "Human-readable diagnosis of this source's health"
          },
          "display_name": {
            "type": "string",
            "description": "Human-readable integration name (e.g. 'Google Ads')"
          },
          "fix_suggestion": {
            "type": [
              "string",
              "null"
            ],
            "description": "Suggested fix when the source is unhealthy"
          },
          "is_native": {
            "type": "boolean",
            "description": "Whether this is a native marketing integration"
          },
          "last_error": {
            "type": [
              "string",
              "null"
            ],
            "description": "Latest unresolved sync error message, if any"
          },
          "last_sync_at": {
            "type": [
              "string",
              "null"
            ],
            "format": "date-time",
            "description": "When the source last completed a sync"
          },
          "last_sync_status": {
            "type": "string",
            "description": "Sync status: ok/error/stale/tables_failed/not_connected/never"
          },
          "required_tables": {
            "type": "array",
            "description": "Per-required-table sync status for this integration",
            "items": {
              "type": "object",
              "required": [
                "last_synced_at",
                "present",
                "should_sync",
                "status",
                "table_name"
              ],
              "properties": {
                "last_synced_at": {
                  "type": [
                    "string",
                    "null"
                  ],
                  "format": "date-time",
                  "description": "When this table last completed a sync"
                },
                "present": {
                  "type": "boolean",
                  "description": "Whether the table exists as a schema on the connected source"
                },
                "should_sync": {
                  "type": "boolean",
                  "description": "Whether the table is enabled for sync"
                },
                "status": {
                  "type": [
                    "string",
                    "null"
                  ],
                  "description": "ExternalDataSchema status: Completed/Running/Failed/Paused/Cancelled, or null"
                },
                "table_name": {
                  "type": "string",
                  "description": "Name of the required source table (e.g. 'campaign', 'campaign_stats')"
                }
              }
            }
          },
          "rows_last_24h": {
            "type": "integer",
            "description": "Rows synced in the last 24 hours"
          },
          "rows_last_7d": {
            "type": "integer",
            "description": "Rows synced in the last 7 days"
          },
          "schema_columns_mapped": {
            "type": "array",
            "description": "Schema columns currently mapped for this source",
            "items": {
              "type": "string"
            }
          },
          "schema_columns_required_missing": {
            "type": "array",
            "description": "Required schema columns that are not yet mapped",
            "items": {
              "type": "string"
            }
          },
          "schemas_url": {
            "type": [
              "string",
              "null"
            ],
            "description": "URL to the per-source Schemas tab, or null if not connected"
          },
          "settings_url": {
            "type": "string",
            "description": "URL to the Marketing analytics global settings page"
          },
          "source_type": {
            "type": "string",
            "description": "External data source type key (e.g. 'GoogleAds', 'MetaAds')"
          },
          "sources_map_present": {
            "type": "boolean",
            "description": "Whether a column mapping exists for this source"
          }
        }
      }
    },
    "issues_summary": {
      "type": "array",
      "description": "Short human-readable summary of detected issues",
      "items": {
        "type": "string"
      }
    },
    "overall_status": {
      "type": "string",
      "description": "Overall: healthy/degraded/broken/no_sources"
    }
  }
}