Search…
API
Tutorials
Decision tables
Scripting Rules
Rule Flow
Other
Test Bench
SDK and Frameworks
Business Intelligence
On-Premise / Docker
Terms & Conditions
Export & Import Decision Table
How to Import or Export Decision Table in DecisionRules
Export & Import Decision Table in native JSON format
Export & Import Decision Table in XLSX
Export & Import Decision Table in CSV format
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
- 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:
1
{
2
"name": "",
3
"description": "",
4
"type": "",
5
"status": "",
6
"inputSchema": {
7
},
8
"outputSchema": {
9
},
10
"decisionTable": {
11
"columns": [
12
],
13
"rows": [
14
]
15
}
16
}
Copied!
File Structure Example:
1
{
2
"name": "Sample rule",
3
"description": "Sample package delivery rule",
4
"type": "decision-table",
5
"status": "published",
6
"inputSchema": {
7
"delivery": {
8
"distance": {},
9
"tariff": {}
10
},
11
"package": {
12
"weight": {},
13
"longestSide": {}
14
}
15
},
16
"outputSchema": {
17
"price": {}
18
},
19
"decisionTable": {
20
"columns": [
21
{
22
"condition": {
23
"type": "simple",
24
"inputVariable": "delivery.tariff",
25
"name": "Delivery tariff"
26
},
27
"columnId": "6849dfec-7621-93af-1e40-21c60bccafe0",
28
"type": "input"
29
},
30
{
31
"columnOutput": {
32
"type": "simple",
33
"outputVariable": "price",
34
"name": "Delivery Price"
35
},
36
"columnId": "d88e08fc-b179-7ce7-5567-7ebd06c6e9d1",
37
"type": "output"
38
}
39
],
40
"rows": [
41
{
42
"cells": [
43
{
44
"column": "6849dfec-7621-93af-1e40-21c60bccafe0",
45
"scalarCondition": {
46
"value": "basic",
47
"operator": "="
48
},
49
"type": "input"
50
},
51
{
52
"column": "d88e08fc-b179-7ce7-5567-7ebd06c6e9d1",
53
"outputScalarValue": {
54
"value": "150"
55
},
56
"type": "output"
57
}
58
]
59
}
60
]
61
}
62
}
Copied!
File Structure of XLSX 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
- 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.
Last modified 1mo ago