BIM X – Rule ValidatorInstall

Summary

Validate tabular data from an XLSX file or JSON input against multiple user-defined rules, and generate reports summarizing validation results.

Inputs

• Source (required) — Choose the input data source: a binary XLSX file or JSON data from the previous node.
• Binary Property (required) — Specify the binary property name containing the XLSX file when using the 'Binary XLSX' source.
• Rules (required) — Define one or more validation rules, each specifying a title, JSON path field, operator (e.g., contains, equals, regex), a pattern or value to match, an optional IFC type filter (CSV list), and a highlight color for reporting.
• GUID Field (required) — Field name used to identify unique records (default is 'GlobalId').
• Report Title (required) — Title used for generated reports.
• Generate XLSX Report (required) — Toggle to generate a detailed XLSX validation report (default true).
• Generate JSON Meta (required) — Toggle to generate a JSON metadata summary of the validation results (default true).
• Generate CSV (per Rule GUIDs) (required) — Toggle to generate separate CSV files listing GUIDs for each rule's matching records (default false).

Output shape

a single JSON object with validation summary and optional binary files (XLSX, CSV)

The output JSON includes counts per rule and overall. If enabled, binary properties contain the XLSX report and CSV files named by rule. Validation runs on the first worksheet for XLSX source, or JSON array structures for JSON source, applying all defined rules to each row or item.

Examples

Example 1: Validate an uploaded IFC element spreadsheet

Load XLSX binary in property 'xlsx', define several rules targeting fields like 'Type' or 'GlobalId', enable XLSX and JSON outputs for detailed reports.