RowDog API Documentation

Overview

RowDog is a data quality resolution system that helps identify, suggest fixes for, and resolve data quality issues in your datasets. This API provides programmatic access to all RowDog functionality.

Quick Start

1. Health Check

curl http://localhost:3001/health

2. Get Failed Rows

curl "http://localhost:3001/api/opportunities/failed_rows?limit=10"

3. Get AI Suggestion

curl "http://localhost:3001/api/opportunities/suggestion/006ABC123DEF456"

4. Resolve Issue

curl -X POST "http://localhost:3001/api/opportunities/resolve/006ABC123DEF456" \
  -H "Content-Type: application/json" \
  -d '{
    "method": "accept_suggestion",
    "field_updates": {"industry": "Technology"},
    "resolved_by": "[email protected]"
  }'

Architecture

RowDog uses a modular architecture with:

• Generic APIs: Dataset-agnostic endpoints using recordId
• Diagnostics Warehouse: Pluggable data source (mock, Snowflake, etc.)
• AI Suggestions: Intelligent field value recommendations
• Resolution Tracking: Complete audit trail of all changes

Data Quality Checks

RowDog automatically runs comprehensive data quality checks:

• Missing Values: Identifies empty or null fields
• Format Validation: Ensures proper email, phone, date formats
• Business Rules: Validates amounts, dates, status values
• Referential Integrity: Checks relationships between records

Configuration

Set environment variables to configure RowDog:

export DIAGNOSTICS_TYPE=mock          # or 'snowflake'
export DIAGNOSTICS_SCHEMA=your_schema
export PORT=3001