booksOverview

Learn how the Ingestion module in Sprinto helps you collect, process, transform, and store external data using configurable workflows and integrations.

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.

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

Last updated