Component Interactions

Proposed service dependencies and data flow

INTERFACE ORCHESTRATION INTELLIGENCE 🗣 MS Copilot Teams Agent 📁 SharePoint Drop Zone ⚡ Event Grid Trigger Hub 🚀 func_ingest Parse & Validate 🧠 func_reason LLM Orchestration 🔗 func_bridge Workiva API 🤖 Azure OpenAI GPT-5.1 (Private) 🔎 AI Search Vector DB (RAG) 🔐 Key Vault Secrets 📄 Workiva B3 Energy Section 🗃 Blob Storage JSON Cache BlobCreated KVPs Draft Prompt Query Creds PUT Notification LEGEND Data Flow Event Trigger Auth Flow Cache/Query

Component Specifications

🚀

func_ingest

Azure Function - Python 3.11

Responsibilities

Parse uploaded documents (Excel/PDF), extract structured KVPs, validate data quality, and store intermediate results.

Input/Output

→
Input Event Grid blob event, raw file bytes
←
Output Structured JSON with KVPs, validation results

Dependencies

Azure Document Intelligence Pandas Blob Storage
🧠

func_reason

Azure Function - Python 3.11

Responsibilities

Orchestrate LLM prompt chain, retrieve historical context via RAG, generate variance analysis and compliant narratives.

Input/Output

→
Input Extracted KVPs, metadata context
←
Output narrative_text, variance_analysis JSON

Dependencies

Azure OpenAI (GPT-5.1) Azure AI Search LangChain
🔗

func_bridge

Azure Function - Python 3.11

Responsibilities

Handle Workiva OAuth2 authentication, map data to container IDs, execute PUT requests to update ESG sections.

API Endpoints

POST /oauth2/token
PUT /platform/v1/spreadsheets/{id}/sheets/{id}/data

Dependencies

Azure Key Vault Workiva API Requests
🤖

Azure OpenAI

GPT-5.1 Private Deployment

Model Configuration

Private deployment with reasoning capabilities. Temperature: 0.1-0.3 for consistency. Max tokens: 4096.

Capabilities

Variance Analysis Narrative Generation Regulatory Compliance Style Matching
🔎

Azure AI Search

Vector Database (RAG)

Index Contents

Historical Factbooks, style guides, previous ESG reports, regulatory templates, and approved narratives.

Search Capabilities

Semantic Search Vector Similarity Hybrid Ranking
📄

Workiva Platform

Target ESG Reporting System

Target Section

B3 Energy Section - Narrative and Data cells for automated population.

API Operations

GET /spreadsheets/{id}
PUT /sheets/{id}/data
GET /validation

Component Interaction Matrix

From \ To Event Grid func_ingest func_reason func_bridge OpenAI AI Search Key Vault Workiva
SharePoint Event - - - - - - -
Event Grid - Trigger Trigger - - - - -
func_ingest - - KVPs - - - Secrets -
func_reason - - - Draft Prompt Query Secrets -
func_bridge - - - - - - Creds PUT
Data Flow
Event Trigger
Authentication

Project Northern Lights Component Interactions v1.0 | Danta Labs for KPMG Lighthouse

Service Mesh Architecture | Azure Functions