Can I export BPM data for reporting and analytics?

Yes. Nodinite provides complete programmatic access to BPM data through the Web API. This page explains:

• What BPM data you can export (events, metrics, metadata)
• Integration options (Power BI, Tableau, Excel, custom dashboards)
• Architecture showing data flow to analytics platforms
• Real-world reporting scenarios with examples
• Code samples for common export patterns

Export to Power BI, Tableau, Excel, or custom dashboards for executive reporting, SLA tracking, capacity planning, and business analytics.

Quick Answer

Nodinite Web API provides REST endpoints for:

• Log Events - Query by date range, process, status, correlation ID
• Process Metrics - Aggregated counts, durations, success rates
• BPM Definitions - Process structure, domains, services, steps
• Business Data - Search Field extracted values (Order ID, Invoice Number)
• Service Health - Monitoring data, resource states, performance metrics

All data is accessible programmatically—build any report or dashboard you need.

BPM Data Export Architecture

Export BPM data to any analytics platform via REST API—Power BI, Tableau, custom dashboards, or data warehouses.

Available Data for Export

Log Events (Transaction Data)

Process Metrics (Aggregated Data)

BPM Metadata (Configuration Data)

• BPM definitions (process names, descriptions)
• Domain configurations (swimlane mappings)
• Service assignments (which services in which steps)
• Search Field definitions (extraction rules)
• Correlation rules (how events link together)

Service Health (Monitoring Data)

• Resource operational states (OK, Warning, Error)
• Performance metrics (response time, throughput)
• Availability percentages (uptime/downtime)
• Alert history (triggered alerts, notifications)

Integration Options

Power BI Integration

Direct REST API Connection:

let
    Source = Web.Contents("https://your-nodinite.com/api/v2/logevents",
        [
            Headers=[
                #"Authorization"="Bearer YOUR_API_TOKEN",
                #"Content-Type"="application/json"
            ],
            Query=[
                startDate="2025-01-01T00:00:00Z",
                endDate="2025-01-31T23:59:59Z",
                bpmName="Order-to-Cash"
            ]
        ]),
    JsonData = Json.Document(Source),
    ConvertedTable = Table.FromRecords(JsonData)
in
    ConvertedTable

Features:

• Real-time data refresh
• Dynamic filtering by date, process, status
• Pre-built visualizations for cycle time, success rate
• Share dashboards across organization

Tableau Integration

REST API Connector:

• Use Tableau's native REST connector
• Point to Nodinite Web API endpoints
• Schedule automatic refreshes (hourly, daily)
• Build interactive visualizations

Example Dashboard Components:

• Process cycle time trends (line chart)
• Success/failure distribution (pie chart)
• Top error processes (bar chart)
• Geographic order distribution (map)

Excel Export

Quick Export Options:

1. Web API JSON Export → Save as .json → Open in Excel
2. CSV Export → Direct download from Log Views
3. PowerQuery → Connect Excel to Web API (auto-refresh)

Use Cases:

• Ad-hoc executive reports
• One-time compliance audits
• Data exploration for new dashboards

Custom Dashboards

Code Sample (.NET/C#):

using System.Net.Http;
using System.Text.Json;

var client = new HttpClient();
client.DefaultRequestHeaders.Add("Authorization", "Bearer YOUR_API_TOKEN");

var response = await client.GetAsync(
    "https://your-nodinite.com/api/v2/process-metrics?" +
    "bpmName=Order-to-Cash&" +
    "startDate=2025-01-01&" +
    "endDate=2025-01-31"
);

var metrics = await JsonSerializer.DeserializeAsync<ProcessMetrics>(
    await response.Content.ReadAsStreamAsync()
);

Console.WriteLine($"Total Orders: {metrics.TotalEvents}");
Console.WriteLine($"Success Rate: {metrics.SuccessRate:P}");
Console.WriteLine($"Avg Cycle Time: {metrics.AvgDurationMinutes} min");

Code Sample (Python):

import requests
import pandas as pd

headers = {"Authorization": "Bearer YOUR_API_TOKEN"}
params = {
    "bpmName": "Order-to-Cash",
    "startDate": "2025-01-01",
    "endDate": "2025-01-31"
}

response = requests.get(
    "https://your-nodinite.com/api/v2/logevents",
    headers=headers,
    params=params
)

df = pd.DataFrame(response.json())
print(f"Total Events: {len(df)}")
print(f"Success Rate: {(df['status']=='Success').mean():.1%}")

Data Warehouse / ETL

Scheduled Data Pipeline:

1. Extract - Nightly Web API call for previous day's events
2. Transform - Enrich with business context, calculate metrics
3. Load - Insert into data warehouse (SQL Server, Snowflake, etc.)

Benefits:

• Historical data retention beyond Nodinite log retention policy
• Combine BPM data with other business systems (CRM, ERP)
• Complex cross-system analytics
• Regulatory compliance with long-term archival

Real-World Reporting Scenarios

Scenario 1: Executive Dashboard (Order-to-Cash)

Business Need: CFO wants monthly Order-to-Cash performance report.

Power BI Dashboard Components:

• KPI Cards:

  • Total Orders Processed: 45,239
  • Average Cycle Time: 47 hours (target: 48 hours)
  • Success Rate: 98.3%
  • Orders > 72 hours: 127 (0.3%)

• Charts:

  • Cycle time trend (last 12 months)
  • Order volume by region (map)
  • Process step duration breakdown (waterfall chart)
  • Top 10 error types (bar chart)

Data Source: Web API query filtered to "Order-to-Cash" BPM, aggregated by month.

Result: CFO shares dashboard at board meetings—process improvement initiatives based on data.

Scenario 2: SLA Compliance Report

Business Need: Track SLA compliance for insurance claim processing (target: 80% within 5 business days).

Tableau Dashboard:

• Time Period: Rolling 90 days

• Metrics:

  • Claims within SLA: 84.7% ( Above target)
  • Claims breaching SLA: 15.3%
  • Average processing time: 4.2 days
  • Longest claim: 23 days (investigation required)

• Drill-Down:

  • By claim type (auto, home, life)
  • By adjuster (identify training needs)
  • By submission channel (web, phone, agent)

Data Source: Web API query for "Claim Processing" BPM, filtered by date range, calculate duration between "Claim Submitted" and "Claim Closed" steps.

Result: Identify adjusters needing training, optimize channel performance, meet regulatory reporting requirements.

Scenario 3: Capacity Planning (Peak Season)

Business Need: E-commerce company planning for Black Friday/Cyber Monday.

Excel Analysis:

• Historical Data: Last 3 years of order volume from Web API

• Peak Analysis:

  • Max orders/hour: 2,847 (last year)
  • Expected growth: 20%
  • Projected peak: 3,416 orders/hour

• Infrastructure Planning:

  • Current capacity: 3,000 orders/hour
  • Required scaling: +15% additional servers
  • Budget impact: $18K for 4-day event

Data Source: Web API query for "Order Processing" BPM, aggregated by hour for November/December periods.

Result: Infrastructure team provisions additional capacity before peak season—no outages during Black Friday.

Scenario 4: Customer Segmentation Analysis

Business Need: Marketing wants to understand customer order patterns.

Custom Python Dashboard:

• Segmentation:

  • High-value customers (> $10K/month): 342 customers
  • Medium-value ($ 1K-$10K): 1,847 customers
  • Low-value (< $1K): 8,934 customers

• Insights from BPM Data:

  • High-value customers use express shipping 73% of time
  • Medium-value customers prefer standard shipping (62%)
  • Return rate correlates with discount percentage (inversely)

Data Source: Web API query for log events, extract Search Field values (Customer ID, Order Value, Shipping Method), join with CRM data.

Result: Marketing creates targeted campaigns—express shipping offer for high-value customers increases retention 12%.

API Endpoint Reference

Get Log Events

GET /api/v2/logevents
Authorization: Bearer YOUR_API_TOKEN

Query Parameters:
- startDate (required): ISO 8601 date
- endDate (required): ISO 8601 date
- bpmName (optional): Filter by BPM
- statusCode (optional): Filter by status
- correlationId (optional): Filter by business ID
- limit (optional): Max results (default: 1000)
- offset (optional): Pagination offset

Get Process Metrics

GET /api/v2/process-metrics
Authorization: Bearer YOUR_API_TOKEN

Query Parameters:
- bpmName (required): BPM name
- startDate (required): ISO 8601 date
- endDate (required): ISO 8601 date
- groupBy (optional): hour|day|week|month

Get BPM Definitions

GET /api/v2/bpm-definitions
Authorization: Bearer YOUR_API_TOKEN

Returns:
- BPM names, descriptions
- Domain configurations
- Service assignments
- Process step definitions

Next Step

Ready to build your first BPM dashboard? Explore the Web API documentation for complete endpoint reference, or check the Troubleshooting Overview for more FAQs.

Related Topics

• Business Process Model (BPM) - Main BPM overview
• Web API - Complete API documentation
• Log Views - Filter and export log data
• Search Fields - Extract business identifiers
• All FAQs - See all BPM FAQs