External Integrations

This section explains how to extend Struktural to communicate with external systems. It covers consuming external REST APIs, mapping JSON payloads to internal entities, and executing raw SQL queries against external legacy databases.

Please navigate through the following sub-sections:

• 6.1 API Consumers (External Web Services) How to define and import OpenAPI/Swagger specifications, and configure authentication strategies (OAuth2, API Keys) for external services.

• 6.2 Data Mapping Instructions on configuring ServiceDataMapping to translate Struktural Entities into External DTOs automatically, reducing boilerplate script code.

• 6.3 Service Invocation How to trigger these configured services programmatically via C# Scripts (Services.ServiceName) or visually using Workflow nodes.

• 6.4 External Databases Guide on utilizing the IExternalDatabaseService to query legacy SQL Server or PostgreSQL databases directly from scripts, complete with dynamic data obfuscation rules.

• 6.5 REST API & Data Integration Documentation on how external systems should format payloads to interact with the standard CRUD APIs, the Pagination/Search endpoints, and the Bulk Data Import API.