Introduction

OneSchema helps teams collect, clean, validate, transform, and automate customer data ingestion without building brittle spreadsheet and file-processing workflows in-house. Use the Importer to embed a guided CSV and spreadsheet upload experience in your product, Multi FileFeeds to automate recurring file-based ingestion and transformations, and Templates to define the columns, data types, and validation rules that keep imported data usable.

APIs and MCP

Most OneSchema implementations combine product setup in the dashboard with API-driven workflows. The API reference documents endpoints for launching and managing importer sessions, creating and updating templates, working with Sheets, configuring webhooks, and connecting storage services such as S3 and SFTP.

OneSchema also provides an MCP Server at https://api.oneschema.co/mcp. The MCP endpoint helps AI coding assistants understand and use the OneSchema API with the same authentication method as the API itself, with more MCP-native tools planned over time.

Where to start

Product quickstarts

• Getting Started with Importer — embed OneSchema's guided importer, customize the upload experience, and ingest validated data.
• Getting Started with FileFeeds — automate recurring file mapping, transformation, validation, and delivery with Multi FileFeeds.
• Creating and Editing Templates — define expected columns, data types, validations, and template structure.

Core concepts

• Spreadsheets — understand how OneSchema represents uploaded spreadsheet data.
• Templates — learn how schemas define what valid data should look like.
• Types of Columns and Validations — choose field types and validation behavior for your templates.

Integration guides

• Importer SDKs — launch the importer from JavaScript, React, Angular, or Vue.
• Importer Headless — initialize importer sessions through the API and skip upload, header selection, or mapping steps.
• Importing Validated Data — retrieve or receive cleaned data after an import is complete.
• Events, Importer Webhooks, and Validation Webhooks — react to import progress and run server-side validation.

API references

• Importer API — create importer sessions, upload files, set headers, map columns, and import data.
• Templates API — create, update, export, and push templates across environments.
• Sheets API — upload files and work with spreadsheet rows programmatically.
• Multi FileFeeds API — manage automated file ingestion workflows.
• Connections — configure S3, SFTP, AWS Secrets Manager, and Azure Key Vault integrations.
• MCP Server — connect AI assistants to OneSchema's API and guide documentation.

To begin, request a demo if you have not yet done so.