# Sisjuri plugin
Integration plugin for Sisjuri (opens new window) legal case management system. Parses JSON exports from Sisjuri REST API and synchronizes client, matter, and case information into SharePoint.
DLL: Epona.Sisjuri.dll
# What it does
- API polling — periodically polls Sisjuri REST API for updates
- JSON parsing — parses case, client, and matter data from API responses
- Field mapping — maps Sisjuri properties to SharePoint columns
- Code formatting — pads client/matter codes with configurable leading characters
- Client sync — imports or updates client information
- Matter sync — imports or updates case/matter information
- Scheduled execution — runs at configurable times of day
- Credential management — securely manages API authentication
# Prerequisites
- Sisjuri REST API endpoint accessible
- Sisjuri user account with API access
- Sisjuri API credentials (username and password)
- Target SharePoint site collections
# Configuration
# Url
Type: string | Required: Yes
Sisjuri REST API base URL
# UserName
Type: string | Required: Yes
Sisjuri API username
# Password
Type: string | Required: No
Sisjuri API password (encrypted)
# Disabled
Type: boolean | Default: false | Required: No
Disable Sisjuri synchronization
# IntervalInMinutes
Type: int | Required: No
Polling interval in minutes
# StartTime
Type: TimeSpan | Required: No
Optional: earliest time of day to run
# EndTime
Type: TimeSpan | Required: No
Optional: latest time of day to run
# ClientCode
Type: string | Default: CasoClienteCodigo | Required: No
JSON property name for client code
# ClientName
Type: string | Required: No
JSON property name for client name
# ClientCodeLeadingChars
Type: string | Required: No
Code padding format (e.g., 0:4 pads to 4 chars)
# ClientFieldMapping
Type: string | Required: No
Maps JSON properties to SharePoint columns
# MatterCode
Type: string | Default: CasoCodigo | Required: No
JSON property name for case/matter code
# MatterName
Type: string | Required: No
JSON property name for case/matter name
# MatterCodeFormat
Type: string | Required: No
Custom format (e.g., {ClientCode}-{MatterCode})
# MatterCodeLeadingChars
Type: string | Required: No
Matter code padding format
# MatterFieldMapping
Type: string | Required: No
Maps JSON properties to SharePoint columns
# MatterFilter
Type: string | Required: No
Filter matters (format: fieldname=value;)
# TestMapping
Type: boolean | Default: false | Required: No
Store results in test directory instead of production
# Code formatting examples
Client code padding:
- Input:
1with padding0:5→ Output:00001 - Input:
42with padding0:5→ Output:00042
Matter code format:
- ClientCode:
001, MatterCode:123→001-123(using format{ClientCode}-{MatterCode})
# Example configuration
| Property | Example value |
|---|---|
Url | https://api.sisjuri.com/v1 |
UserName | epona_user |
Password | EncryptedPassword |
IntervalInMinutes | 120 |
ClientCode | ClienteCodigo |
ClientCodeLeadingChars | 0:5 |
MatterCode | CasoCodigo |
MatterCodeFormat | {ClientCode}-{MatterCode} |
MatterFilter | Status=Active; |
# Scheduling behavior
- Interval: polling runs every N minutes
- StartTime: only poll after this time of day (optional)
- EndTime: only poll before this time of day (optional)
# Security
Sisjuri API credentials are encrypted using the provisioning service's encryption key:
- Password encrypted at configuration time
- Decrypted only when establishing API calls
- Never logged or exposed in files
# Troubleshooting
| Issue | Cause | Resolution |
|---|---|---|
| Cannot connect to API | Wrong URL or credentials | Verify Sisjuri API URL and username/password |
| No data imported | API not returning data or filter too restrictive | Check API connectivity and MatterFilter |
| Code format incorrect | MatterCodeFormat syntax wrong | Verify format uses {PropertyName} syntax |
| Fields missing | Field mapping incomplete | Ensure all required SharePoint columns are in mapping |
| Sync not running | StartTime/EndTime excludes current time | Check time window or disable time restrictions |