LogoLogo
API Documentation
Current Version
Current Version
  • DecisionRules Documentation
  • DecisionRules Academy
  • API
    • API Introduction
    • API Keys
      • Solver API Keys
      • Management API keys
      • BI API keys
    • Rule Solver API
    • Management API
      • Rule Migration Strategies
      • 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)
  • AI Assistant
    • About Assistant
  • RULES
    • Rules Introduction
    • Rule List
    • Rule Mode
    • Common Rule Features
      • Input & Output Model
        • Simple Editor
        • JSON Editor
      • Test Bench
      • Rule Alias
      • Rule State
      • Versioning
      • Rule Variables
      • Execution Strategy
      • Rule Dependencies
      • Rule Export & Import
        • Rule Export
        • Rule Import
        • Managing Decision Table in Excel/Google Sheets
        • Deprecated Formats: XLSX v.1 and CSV
      • Tags
      • Rule Comparison
        • Decision Table Comparison
        • Decision Tree Comparison
        • Scripting Rule Comparison
      • Rule Lock
      • Teamwork Indicator
      • Event Timeline
    • Data Types & Functions
      • 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
    • Decision Table
      • Table Designer
        • Table Operations
          • Filter Values
          • Valid Values
          • Sorting
      • Binding to Model
    • Decision Tree
      • Tree Designer
    • Workflow
      • Workflow Designer
      • Workflow Nodes Overview
      • Workflow Limits
    • Scripting Rule
      • Custom functions in Scripting Rules
      • Calling external API within ScriptingRules
      • Use Rule Variables in Scripting Rules
      • Call Embedded Rules in Scripting Rules
      • Tips
    • Rule Flow
      • Rule Flow Designer
      • Rule Flow Mapping
      • Rule States in Rule Flow
      • Warnings & Errors
      • Rule Flow Limits
  • SPACE
    • Space Introduction
    • Space Info
    • Dashboard
    • Access
    • API Keys
    • Audit Logs
  • Organization
    • Organization Introduction
    • Organization List
    • Members
    • Teams
    • Spaces
    • Space Roles
    • Policies
    • Statistics
    • Settings
  • Profile
    • Profile Introduction
    • General
    • Dashboard
    • Plans
    • Add-ons
    • Limits
      • Plan Limits Explained
    • Subscriptions
    • Invoices
  • Access
    • Sign Up & Login
    • Invitations & Permissions
    • Single Sign-On (SSO)
  • Business Intelligence
    • Audit Logs
    • Power BI Connectivity
      • 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
  • OTHER DEPLOYMENT OPTIONS
    • Regional Cloud
      • Region Specific API URLs
    • Docker & On-Premise
      • Environment Variables
      • Redis Connection Modes
      • DecisionRules Application
        • Minimal Requirements
        • DecisionRules Server
        • DecisionRules Client
        • DecisionRules Business Intelligence
        • Networking Between Docker Containers
      • Setup Single Sign-On (SSO)
        • Set up Microsoft Entra ID SSO
        • Set up Google SSO
      • 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
  • 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
  • Terms & Conditions
    • Terms and Conditions
    • Privacy Policy
    • Service Level Agreement
      • Community Support
      • Standard Cloud (SaaS)
      • Silver SLA
      • Gold SLA
      • Custom SLA
    • Sub-Processor List
  • Product Updates
    • Release Notes
      • Public Cloud
      • On-Premise / Private Cloud
    • Major Updates
      • Changes in Version 1.19.0 (10/2024)
      • Changes in Version 1.20.0 (4/2025)
    • Roadmap
Powered by GitBook
On this page
  • Data types in Decision Tables
  • Condition Data Types
  • Calculation Data Types
  • Result Data Types

Was this helpful?

  1. RULES
  2. Data Types & Functions

Supported Data Types

Last updated 7 months ago

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.