LogoLogo
API Documentation
Version 1.19.5 and Older
Version 1.19.5 and Older
  • DecisionRules Documentation
  • API
    • API Introduction
    • API Keys
      • Solver API Keys
      • Management API keys
      • BI API keys
    • Rule Solver API
    • Management API
      • Deprecated Endpoints
    • Console Logs API
    • Business Intelligence API
      • Deprecated Endpoints
    • Datacenters & Locations
      • Global Cloud
      • Regional Cloud
    • Apache Kafka Solver API
    • Endpoint Settings
    • Archive
      • Rule Flow Solver API (DEPRECATED)
  • Decision tables
    • Decision Tables Introduction
    • Table Designer
    • Input & Output JSON Model
      • Simple Editor
      • JSON Editor
      • Binding to Model
    • Supported Data Types
    • Operators and Functions
      • Basic operators
      • Date operators
      • Functions
        • Logical Functions
        • Math Functions
        • Date and Time Functions
        • Text Functions
        • Data Functions
        • Array Functions
        • Integration functions
        • Functions and JSON
    • Export & Import of Decision Tables
      • Export Decision Table
      • Import Decision Table
      • File Structure of JSON Format
      • Managing Decision Table in Excel/Google Sheets
      • Deprecated Formats: XLSX v.1 and CSV
    • Table Operations
      • Filter Values
      • Valid Values
      • Sorting
  • Decision Trees
    • Decision Trees Introduction
    • Decision Tree Designer
    • Export & Import Decision Trees
      • Export Decision Tree
      • Import Decision Tree
  • Scripting Rules
    • Scripting Rule Introduction
    • Custom functions in Scripting Rules
    • Calling external API within ScriptingRules
    • Use Rule Variables in Scripting Rules
    • Call Embedded Rules in Scripting Rules
    • Export & Import Scripting Rules
      • Export Scripting Rule
      • Import Scripting Rule
    • Tips
  • Rule Flow
    • Rule Flow Designer
    • Rule Flow Mapping
    • Rule States in Rule Flow
    • Warnings & Errors
    • Rule Flow Limits
    • Export & Import Rule Flows
      • Export Rule Flow
      • Import Rule Flow
  • Workflow
    • Workflow Introduction
    • Workflow Designer
    • Workflow Nodes Overview
    • Workflow Limits
  • Other
    • Rule Alias
    • Execution Strategy
    • Rule State
    • Rule Versioning
    • Favorite Rules
    • Rule Variables
    • Rule Comparison
      • Decision Table Comparison
      • Decision Tree Comparison
      • Scripting Rule Comparison
    • Rule Tags
    • Rule Dependencies
    • Test Bench
    • Single Sign-On (SSO)
    • Event timeline
    • Rule Lock
    • Rule Migration Strategies
    • Changes in Version 1.19.0 (10/2024)
  • Organizations
    • Introduction
      • Access to Organization
    • Structure
      • Organization Roles
      • Members
      • Teams
      • Spaces
      • Space Roles
      • Policies
      • Settings
  • Teamwork
    • Dashboard
    • Folders
    • Spaces
    • Manage Spaces
    • Share Rules Between Spaces
    • Users & Roles
    • Teamwork Indicator
  • SDK and Integrations
    • Languages / Frameworks
      • SQL Server
      • Oracle PL/SQL
      • PostgreSQL
      • JavaScript
      • Java Spring Example
      • PHP Library
      • Python Library
      • .NET Library
      • Google Tag Manager
    • Excel Add-in
  • Business Intelligence
    • Audit Logs
    • Create a Power BI Report
    • Connect Power BI to Business Intelligence API
    • Connecting from Power BI (deprecated)
    • Connect DecisionRules to Power BI Using Our Custom Connector
  • Billing
    • Invoices & Billing
    • Change Product Plan
    • Billing Information
    • Plan Limits Explained
  • Regional Cloud
    • Regional Cloud
    • Region Specific API URLs
  • On-Premise / Docker
    • Environment Variables
    • Redis Connection Modes
    • Setup Single Sign-On (SSO)
      • Set up Microsoft Entra ID SSO
      • Set up Google SSO
    • DecisionRules Application
      • Minimal Requirements
      • DecisionRules Server
      • DecisionRules Client
      • DecisionRules Business Intelligence
      • Networking Between Docker Containers
    • Docker Showcase App
      • Showcase
      • Showcase + Business Intelligence
    • AWS Setup
      • AWS ECS/Fargate
      • Cache - Amazon ElastiCache
    • Microsoft Azure Setup
      • Database - Azure CosmosDB
      • Cache - Azure Cache for Redis
      • Azure Container Apps
    • Azure Red Hat OpenShift
    • Google Kubernetes Engine (GKE)
    • Kubernetes Setup
      • Kubernetes Setup with Business Intelligence
    • Logging options
    • CD/CI Pipelines
      • Azure DevOps CICD Pipelines
      • Using Migration script (old way)
    • Offline License
  • Terms & Conditions
    • Terms and Conditions
    • Privacy Policy
    • Service Level Agreement
      • Community Support
      • Standard Cloud (SaaS)
      • Silver SLA
      • Gold SLA
      • Custom SLA
    • Sub-Processor List
  • Roadmap 🚲 🗺️
  • Release Notes
    • Public Cloud
    • On-Premise / Private Cloud
Powered by GitBook
On this page
  • Data types in Decision Tables
  • Condition Data Types
  • Calculation Data Types
  • Result Data Types

Was this helpful?

  1. Decision tables

Supported Data Types

Was this helpful?

Data types in Decision Tables

All data in a decision table is stored as string values and is automatically cast when needed. Therefore, you don’t need to specify any data format for your. The automatic casting of conditions and results is described in the following sections.

The decimal separator is always a dot: 5.5

Condition Data Types

Conditions can be created using the following scalar data types:

  • Number

  • Boolean

  • String

  • Date

Conditions

Solver Request Data Example

The inputs below demonstrate the format in which you can send a request to match a particular row:

  1. Number:

    {
      "input": "2.31"
    }

    or

    {
      "input": 2.31
    }
  2. Boolean (True):

    {
      "input": true
    }

    or

    {
      "input": "true"
    }
  3. Boolean (False):

    {
      "input": false
    }

    or

    {
      "input": "false"
    }
  4. String:

    {
      "input": "hello world"
    }
  5. Date and Time:

    {
      "input": "2024-09-23 13:27 +02:00"
    }

    or as extended ISO-8601:

    {
      "input": "2024-09-23T13:27:00+02:00"
    }
  6. Empty Value:

    {
      "input": ""
    }

The data cells now convert dates to strings. The old object format is deprecated but still supported. For example, the input:

{
"input": {
    "date": "2024-09-23",
    "time": "13:27",
    "timezone": "+02:00"
    }
}   

will match the new condition 2024-09-23 13:27 +02:00.

Examples:

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

2.31

2.31

Equal

2.31

"2.31"

Equal

true

true

Equal

true

"true"

Equal

false

false

Equal

true

2

Not Equal

hello world

"hello world"

Equal

"2024-09-23 13:27 +02:00"

"2024-09-23 13:27 +02:00"

Equal

"2024-09-23 13:27 +02:00"

"2024-09-23T13:27:00+02:00"

Equal

"2024-09-23 13:27 +02:00"

Equal

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

"2024-09-23 13:27 +02:00"

Equal

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

Not Equal!

<empty>

""

Equal

<empty>

Value not presented in input JSON

Not Equal

Calculation Data Types

Calculation columns support all the data types used by result columns.

Result Data Types

  • Boolean

  • Number

  • String

  • Date

  • JSON Object

  • JSON Arrays

Casting examples:

Decision Table Result Value
Solver Response Value

true

true

false

false

"true"

\"true\"

25

25

25.0

25

25.01

25.01

""

""

Empty

""

hello world

"hello world"

DATE(09.23.2024)

"2024-09-22T22: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] ]

Read more about

When calling the , the response returns an array of results based on the decision table setup. Response values are automatically cast to the following data types:

{
  "input": {
    "date": "2024-09-23",
    "time": "13:27",
    "timezone": "+02:00"
  }
}
{
  "input": {
    "date": "2024-09-23",
    "time": "13:27",
    "timezone": "+02:00"
  }
}
Solver API
input and output models
Date cells in the dedicated section.