Business / VERSION 1

Review contact records

Flag missing contact fields, malformed email syntax and duplicate email addresses before a CRM import.

Available via local MCP

RuntimeLocal DockerNetworkNoneRequest / result256 KiB eachProvider costNo API fees; local compute

Give it a task.

Use this MCP call after connecting Piwi. The output below is the result asserted by this tool's tests.

MCP tool call

{
  "name": "piwi_run_contacts_review",
  "arguments": {
    "input": {
      "headers": [
        "name",
        "email"
      ],
      "rows": [
        {
          "name": "Ada",
          "email": "[email protected]"
        },
        {
          "name": "Repeat",
          "email": "[email protected]"
        },
        {
          "name": "Bad",
          "email": "invalid"
        }
      ],
      "errors": [],
      "emailField": "email",
      "requiredFields": [
        "name",
        "email"
      ]
    }
  }
}

Expected output

{
  "accepted": [
    {
      "name": "Ada",
      "email": "[email protected]"
    }
  ],
  "issues": [
    {
      "record": 3,
      "reasons": [
        "duplicate-email"
      ]
    },
    {
      "record": 4,
      "reasons": [
        "invalid-email"
      ]
    }
  ],
  "structuralErrors": [],
  "summary": {
    "parsed": 3,
    "accepted": 1,
    "flagged": 2,
    "structuralErrors": 0
  },
  "readyForReview": false
}

Inputs

headers, rows and errors from csv.clean
emailField: column name
requiredFields: column names

Outputs

accepted records
issues with record numbers
summary counts
readyForReview