Supported Data Types

Data types in Decision Tables

All data in a data table are stored as string values and are automatically casted when needed. Therefore, you don't need to specify any data format for your **** input and output models. The automatic casting of conditions and results is described in the following sections.

The decimal separator is always a dot - "."

Condition Data Types

The conditions can be made using the following scalar data types:

  • Number

  • Boolean

  • String

  • Date

Conditions

Solver Request Data

// 2.31
{
  "inputData": 2.31 OR "2.31"
}

// true
{
  "inputData": true
}

//false
{
  "inputData": false
}

// hello world
{
  "inputData": "hello world"
} 

// 17/13/2021 13:17 GMT:-9:00
{
"inputData": {"date":"2021-03-17","time":"13:17","timezone":"-09:00"}
}
// DATE TIME INPUT AS ISO-8601
{
"inputData": "2021-03-17T13:17-09:00"
}
// OR ANY PARSEABLE DATE STRING
{
"inputData": "2021-03-17, 13:17 -09:00"
}
// <empty>
{}
OR
{
  "inputData": ""
}

Examples:

Condition [value in decision table]Solver Request Value [value send on API]Result

2.32

2.32

Equal

2.32

"2.32"

Equal

true

true

Equal

false

false

Equal

true

1

Equal

false

0

Equal

true

2

Not Equal

true

"true"

Not Equal

hello world

"hello world"

Equal

"date": "2021-03-17", "time": "13:17", "timezone": "-09:00"

"date": "2021-03-17", "time": "13:17", "timezone": "-09:00"

Equal

"date": "2021-03-17", "time": "13:17", "timezone": "-09:00"

"2021-03-17T13:17-09:00"

Equal

"2021-03-17T13:17-09:00"

"2021-03-17T13:17-09:00"

Equal

<empty>

""

Equal

<empty>

Value not presented in input JSON

Equal

Result Data Types

Calling Solver API returns an array of results according to the decision table setup. Response values are automatically cast to:

  • Boolean

  • Number OR Float

  • String

  • Date

  • JSON Object

  • JSON Arrays

Casting examples:

Decision Table Result ValueSolver Response Value

true

true

false

false

"true"

\"true\"

25

25

25.0

25

25.01

25.01

<empty>`` OR ``empty string

Node is omitted in reponse

hello world

"hello world"

"date": "2021-03-17", "time": "13:17", "timezone": "-09:00"

"date": "2021-03-17", "time": "13:17", "timezone": "-09:00"

{}

{}

{"data":123 }

{"data":123 }

{"data": "123" }

{"data": "123" }

[12,36,"542"]

[12,36,"542"]

[12,36,"542"

"[12,36,\"542\""

[12, 36, "542", [1,2] ]

[12, 36, "542", [1,2] ]

Last updated