validate_rows
Pre-checks rows against a dataset's schema without saving, returning normalized valid rows and rejection reasons. Use it to confirm which pasted records would be stored and why others fail.
Instructions
Validate rows against a dataset's schema without saving anything.
Use this to pre-check data before committing it - e.g. when the user pastes a list of records and wants to know what would be rejected and why. Valid rows come back normalized (types coerced, defaults filled) so you can show the user exactly what would be stored.
Args: dataset: Exact dataset name, e.g. "Candidates". rows: List of row objects to check (max 100 per call).
Returns: {"ok": true, "dataset", "total": , "valid": , "invalid": , "results": [{"row": , "status": "valid", "normalized": {...}} | {"row": , "status": "invalid", "errors": ["..."]}]}.
Example: validate_rows(dataset="Candidates", rows=[{"name": "Asha", "phone": "9876543210"}])
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | ||
| dataset | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||