Export & Import Decision Table

How to Import or Export Decision Table in DecisionRules
Export & Import Decision Table in native JSON format
Export Decision Table to JSON
Import Decision Table from JSON
Export & Import Decision Table in XLSX
Export Decision Table to XLSX
Import Decision Table from XLSX
Export & Import Decision Table in CSV format
Export Decision Table to CSV
Import Decision Table from CSV
File Structure of JSON format
Imported & Exported files need to have some mandatory structural information:
name: name of the decision table
description: description of the decision table
type: type of the decision table
status: status of the decision table​
inputSchema: input schema of the decision table
outputSchema: output schema of the decision table
decisionTable: rules of the decision table
Type: there are two types:
"decision-table" - for decision tables
"complex-rule" - for scripting rules
Minimal File Structure Example:
{
    "name": "",
    "description": "",
    "type": "",
    "status": "",
    "inputSchema": {
    },
    "outputSchema": {
    },
    "decisionTable": {
        "columns": [
        ],
        "rows": [
        ]
    }
}
File Structure Example:
{
    "name": "Sample rule",
    "description": "Sample package delivery rule",
    "type": "decision-table",
    "status": "published",
    "inputSchema": {
        "delivery": {
            "distance": {},
            "tariff": {}
        },
        "package": {
            "weight": {},
            "longestSide": {}
        }
    },
    "outputSchema": {
        "price": {}
    },
    "decisionTable": {
        "columns": [
            {
                "condition": {
                    "type": "simple",
                    "inputVariable": "delivery.tariff",
                    "name": "Delivery tariff"
                },
                "columnId": "6849dfec-7621-93af-1e40-21c60bccafe0",
                "type": "input"
            },
            {
                "columnOutput": {
                    "type": "simple",
                    "outputVariable": "price",
                    "name": "Delivery Price"
                },
                "columnId": "d88e08fc-b179-7ce7-5567-7ebd06c6e9d1",
                "type": "output"
            }
        ],
        "rows": [
            {
                "cells": [
                    {
                        "column": "6849dfec-7621-93af-1e40-21c60bccafe0",
                        "scalarCondition": {
                            "value": "basic",
                            "operator": "="
                        },
                        "type": "input"
                    },
                    {
                        "column": "d88e08fc-b179-7ce7-5567-7ebd06c6e9d1",
                        "outputScalarValue": {
                            "value": "150"
                        },
                        "type": "output"
                    }
                ]
            }
        ]
    }
}
File Structure of XLSX format
More information in Manage Decision Tables in Excel/Google Sheets​
Imported & Exported files need to have some mandatory structural information:
name: name of the decision table
description: description of the decision table
type: type of the decision table
status: status of the decision table​
decisionTable: rules of the decision table
File Structure Example:
​
File structure of CSV format
Creating CSV file by hand is not recommended because of uncluttered structure that big CSV files have. Then there is a lot of room for error. It is recommended to use Excel or Google Sheets to edit exported CSV files.
More info about managing decision tables in Excel or Google Sheets here.

Integration functions

Import Decision Table from JSON

Last modified 4mo ago

Copy link

On this page

How to Import or Export Decision Table in DecisionRules

File Structure of JSON format

File Structure of XLSX format

File structure of CSV format