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:

  1. Connect to an external provider.
  2. Authenticate using credentials.
  3. Fetch or receive data.
  4. Process and transform the incoming payload.
  5. Map records to Sprinto entity types.
  6. Save or remove entities.
  7. 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:

  1. Authenticate with an API.
  2. Fetch records.
  3. Transform data.
  4. Save entities.

File-Based Ingestion

Data is imported from files.

Supported examples include:

  • CSV files
  • Excel spreadsheets
  • Downloaded reports

Typical flow:

  1. Download or receive a file.
  2. Parse file contents.
  3. Transform rows.
  4. 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.

StageDescription
ConnectAttach credentials and providers
FetchRetrieve data from external sources
ProcessParse, transform, or filter data
MapMatch incoming records to entity types
StoreInsert or update Sprinto entities
EvaluateTrigger downstream checks or monitoring

Use Cases

Use CaseDescription
Import incident recordsSync incidents from external systems into Sprinto
Sync training completion dataImport user training records from LMS providers
Process downloaded reportsConvert files into structured Sprinto entities
Maintain external inventoryKeep Sprinto aligned with external asset systems
Build custom integrationsConnect 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