EnterWorks - ETT 140 - How to Convert Repository Validation Errors from JSON to Columns Using SQL
Business Rules, Validation
When EnterWorks validates a repository record, the details for any validation errors are stored in a snapshot validation table for the repository. This data is stored in a JSON structure. For size and performance considerations, the JSON does not have tags, making it difficult to understand and access using SQL queries. A SQL Function has been defined that converts the JSON format into discrete columns that can be joined to other tables from anywhere that uses SQL. This includes View Scheduled Exports, SQL-based activities in EPX workflow, bulk callout validation rules, and external applications having access to the EPIM database.
This session provides details on where the validation errors are stored, the JSON structure, the SQL Function that converts the JSON and how to use the function within a SQL Query.
Prerequisites - EBC 402, EBU 107, EBA 209