Comment on page
Export & Import of Decision Tables

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
"decision-tree" - for decision trees
"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.
Functions and JSON
Export Decision Table
Last modified 10mo ago