📄 README

UiPath - Nova2FilArkiv Validation and Update Robot

Nova2FilArkiv Validation and Update is a UiPath process developed for Teknik og Miljø, Aarhus Kommune.
It validates whether documents have been uploaded correctly to FilArkiv, retrieves and compares metadata, and updates a SQL Server database with the processing results.

---

🚀 Features

✅ Case Number Extraction

• Extracts the CaseNumber from each queue transaction

✅ Database Integration

• Connects to SQL Server to retrieve reference data from the Nova2FilArkiv table
• Updates records to reflect validation status and any issues detected

✅ FilArkiv API Integration

• Retrieves case and document metadata from FilArkiv via REST API
• Checks whether all expected documents have been successfully uploaded

✅ Validation Logic

• Compares documents found in FilArkiv with those in the database
• Marks records as complete or flags them for manual follow-up

✅ Structured Logging

• Logs all processing steps and validation outcomes for traceability

---

🧭 Process Flow

1. Queue Transaction Start

   • Assigns CaseNumber from the incoming transaction item

2. Retrieve Reference Data

   • GetDatabaseData.xaml
     • Connects to SQL Server using Orchestrator credentials
     • Runs query: SELECT * FROM dbo.Nova2Fil
     • Loads results into out_dt_DatabaseInfo

3. Retrieve FilArkiv Data

   • GetFilArkivData.xaml
     • Gets access token via GetFilArkivAccessToken.xaml
     • Performs REST API call to fetch case metadata
     • If case is found, extracts CaseID
     • Retrieves associated document metadata
     • Builds a datatable out_dt_FilArkivData listing all documents

4. Validation

   • CheckIfDataUploadedToFilArkiv.xaml
     • Compares documents retrieved from FilArkiv with expected records
     • Logs status for each document and overall case

5. Database Update

   • UpdateDatabase.xaml
     • Connects to SQL Server
     • Iterates through all validation results
     • Runs UPDATE queries to mark documents as processed, failed, or pending

---

⚙️ Dependencies

• UiPath Studio 2021.10+ (or newer)
• UiPath.System.Activities
• UiPath.Excel.Activities
• UiPath.Database.Activities
• UiPath.WebAPI.Activities

---

🗂️ Main Workflows

Workflow File	Purpose
Process.xaml	Dispatcher and main logic
GetDatabaseData.xaml	Loads reference data from SQL Server
GetFilArkivData.xaml	Retrieves document metadata from FilArkiv API
GetFilArkivAccessToken.xaml	Retrieves FilArkiv API token
CheckIfDataUploadedToFilArkiv.xaml	Compares FilArkiv data to database expectations
UpdateDatabase.xaml	Updates processing results back into SQL Server

---

👷 Maintainer

Gustav Chatterton
Digital udvikling, Teknik og Miljø, Aarhus Kommune