Ingestion
Overview
Learn how the Ingestion module in Sprinto helps you collect, process, transform, and store external data using configurable workflows and integrations.
Overview
The Ingestion module in Sprinto allows you to import, process, and manage structured data from external systems.
It acts as a workflow engine that connects external providers, retrieves information, transforms incoming data, and stores it within Sprinto for downstream monitoring, evaluation, and automation.
Ingestion is designed to support flexible integrations with APIs, files, and external systems through configurable plans.
You can use Ingestion to:
- Fetch data from external APIs
- Connect providers and credentials
- Transform and map records into Sprinto entities
- Parse files such as CSV or Excel
- Store or remove records based on defined logic
- Trigger evaluations and downstream workflows
- Build repeatable ingestion pipelines
The module is primarily configured using Plans, where each workflow is built through reusable steps.
How Ingestion Works
Ingestion follows a structured workflow model.
Each ingestion workflow is configured as a plan that defines how data moves from an external source into Sprinto.
The process typically follows this sequence:
- Connect to an external provider.
- Authenticate using credentials.
- Fetch or receive data.
- Process and transform the incoming payload.
- Map records to Sprinto entity types.
- Save or remove entities.
- Trigger evaluations or monitoring.
This modular structure allows you to build workflows for different integration use cases.
Key Components of Ingestion
Plans
Plans define the ingestion workflow.
Each plan contains:
- Workflow configuration
- Providers
- Credentials
- Execution steps
- Processing logic
Plans determine how external data is collected, transformed, and processed.
Entities
Entities are structured records created or updated during ingestion.
They act as the destination schema for imported data.
Entity mapping allows external records to align with Sprinto data models.
Examples include:
- Incident records
- Training records
- Asset records
- User-related data
- Custom entity types
Entities allow imported information to become usable across monitoring, workflows, and reporting.
Webhooks
Webhooks allow external systems to send data directly into Sprinto when specific events occur.
Unlike scheduled fetching workflows, webhooks enable real-time ingestion.
Webhooks can be used to:
- Receive event-driven updates
- Trigger ingestion workflows automatically
- Push data into Sprinto without polling
- Reduce dependency on scheduled API calls
Webhook-based ingestion is useful when external systems support outbound notifications or event callbacks.
Common Ingestion Workflow Types
Ingestion supports multiple workflow patterns.
API-Based Ingestion
Data is retrieved directly from external APIs.
Typical flow:
- Authenticate with an API.
- Fetch records.
- Transform data.
- Save entities.
File-Based Ingestion
Data is imported from files.
Supported examples include:
- CSV files
- Excel spreadsheets
- Downloaded reports
Typical flow:
- Download or receive a file.
- Parse file contents.
- Transform rows.
- Save mapped entities.
Scheduled Synchronisation
Plans can run repeatedly to keep Sprinto aligned with external systems.
This helps ensure data remains updated without manual intervention.
Incremental Updates
Ingestion workflows can insert, update, or delete records depending on workflow logic.
This prevents duplicate or outdated data.
Typical Ingestion Flow
Below is a common ingestion lifecycle.
| Stage | Description |
|---|---|
| Connect | Attach credentials and providers |
| Fetch | Retrieve data from external sources |
| Process | Parse, transform, or filter data |
| Map | Match incoming records to entity types |
| Store | Insert or update Sprinto entities |
| Evaluate | Trigger downstream checks or monitoring |
Use Cases
| Use Case | Description |
|---|---|
| Import incident records | Sync incidents from external systems into Sprinto |
| Sync training completion data | Import user training records from LMS providers |
| Process downloaded reports | Convert files into structured Sprinto entities |
| Maintain external inventory | Keep Sprinto aligned with external asset systems |
| Build custom integrations | Connect unsupported external systems using APIs |
Benefits of Ingestion
Using Ingestion provides:
- Centralised data processing
- Flexible workflow design
- Reduced manual imports
- Consistent data mapping
- Integration extensibility
- Improved monitoring accuracy
- Better automation support