Create Table
POST {{_endpoint}}/services/data/v{{version}}/connect/business-rules/decision-table/definitions
Create a decision table definition. A decision table definition contains all the details required to create a decision table.Resource Resource Example Available version 58.0 Requires Chatter No HTTP methods POST JSON example for a single object source JSON example for a multi-object source Request body for POSTProperties ENDPOINTSDecision Table Definitions (POST)
/connect/business-rules/decision-table/definitions
https://yourInstance.salesforce.com/services/data/v59.0/connect/business-rules/decision-table/definitions
{
"setupName":"Product Qualificiation eligibility",
"fullName":"ProductQualificationEligibility",
"description":"Eligiblity of Products using Qualification Rules",
"usageType":"ProductEligibility",
"sourceType":"SingleSobject",
"sourceObject":"AccountFeed",
"status":"Draft",
"decisionResultPolicy":"UniqueValues",
"collectOperator":"Count",
"conditionType":"Any",
"conditionCriteria":"1 OR 2 OR 3",
"parameters":[
{
"fieldName":"IsDeleted",
"usage":"INPUT",
"operator":"Equals",
"sequence":"1"
},
{
"fieldName":"Id",
"usage":"INPUT",
"operator":"Equals",
"sequence":"2"
},
{
"fieldName":"Title",
"usage":"INPUT",
"operator":"Equals",
"sequence":"3"
},
{
"fieldName":"CreatedById",
"usage":"OUTPUT"
}
]
}
{
"setupName":"Jumbo Pricing Definition",
"fullName":"JumboPricingDefinition",
"description":"Join all the DT definitions into one jumbo pricing definition",
"usageType":"ProductEligibility",
"type":"LowVolume",
"sourceType":"MultipleSobjects",
"sourceObject":"AccountFeed",
"status":"Draft",
"decisionResultPolicy":"UniqueValues",
"collectOperator":"Count",
"sourceconditionLogic":"1 AND 2 AND 3",
"conditionType":"Any",
"conditionCriteria":"1 OR 2 OR 3 OR 4 OR 5",
"parameters":[
{
"fieldName":"IsDeleted",
"usage":"INPUT",
"operator":"Equals",
"sequence":"1",
"columnMapping":"IsDeleted"
},
{
"fieldName":"Id",
"usage":"INPUT",
"operator":"Equals",
"sequence":"2",
"columnMapping":"Id"
},
{
"fieldName":"Title",
"usage":"INPUT",
"operator":"Equals",
"sequence":"3",
"columnMapping":"Title"
},
{
"fieldName":"OldvalNumber",
"usage":"INPUT",
"operator":"Equals",
"sequence":"4",
"columnMapping":"AccountHistory.OldvalNumber"
},
{
"fieldName":"OldvalString",
"usage":"INPUT",
"operator":"Equals",
"sequence":"5",
"columnMapping":"AccountHistory.OldvalString"
},
{
"fieldName":"CreatedById",
"usage":"OUTPUT",
"columnMapping":"CreatedById"
},
{
"fieldName":"NewvalNumber",
"usage":"OUTPUT",
"columnMapping":"AccountHistory.NewvalNumber"
},
{
"fieldName":"NewvalString",
"usage":"OUTPUT",
"columnMapping":"AccountHistory.NewvalString"
}
]
"sourceCriteria":[
{
"sourceFieldName":"OldvalString",
"value":"5",
"operator":"Equals",
"valueType":"Parameter",
"sequenceNumber":"1"
}
]
}
Name
Type
Description
Required or Optional
Available Version
collectOperator
String
Operator to apply a filter to outputs. Possible values are:
- Count
- Maximum
- Minimum
- None
- SumOptional
58.0
conditionCriteria
String
Custom logic applied on the decision table columns to decide how the input fields are processed.
Optional
Required when the condition type is Custom.58.0
conditionType
String
Condition logic for input fields. Possible values are:
- All
- Any
- CustomOptional
58.0
description
String
Description of the decision table.
Optional
58.0
decisionResultPolicy
String
Results policy to filter results of the decision table. Possible values are:
- AnyValue
- CollectOperator
- FirstMatch
- OutputOrder
- Priority
- RuleOrder
- UniqueValuesOptional
fullName
String
Unique name of the rule definition.
Required
58.0
isSetCollectOperator
Boolean
For internal use only.
Indicates whether the collectOperator is enabled (true) or not (false).Optional
58.0
isSetConditionCriteria
Boolean
For internal use only.
Indicates whether the conditionCriteria field is enabled (true) or not (false).Optional
58.0
isSetConditionType
Boolean
For internal use only.
Indicates whether the conditionType field is enabled (true) or not (false).Optional
58.0
isSetDescription
Boolean
For internal use only.
Indicates whether the description field is enabled (true) or not (false).Optional
58.0
isSetDecisionResultPolicy
Boolean
For internal use only.
Indicates whether the DecisionResultPolicy field is enabled (true) or not (false).Optional
58.0
isSetFullName
Boolean
For internal use only.
Indicates whether the FullName field is enabled (true) or not (false).Optional
58.0
isSetParameters
Boolean
For internal use only. Indicates whether the parameters field is enabled (true) or not (false).
Optional
58.0
isSetSetupName
Boolean
For internal use only.
Indicates whether the setupName field is enabled (true) or not (false).Optional
58.0
isSetSourceconditionLogic
Boolean
For internal use only.
Indicates whether the sourceConditionLogic field is enabled (true) or not (false).Optional
58.0
isSetSourceCriteria
Boolean
For internal use only.
Indicates whether the sourceCriteria field is enabled (true) or not (false).Optional
58.0
isSetSourceObject
Boolean
For internal use only.
Indicates whether the sourceObject field is enabled (true) or not (false).Optional
58.0
isSetSourceType
Boolean
For internal use only.
Indicates whether the sourceType is enabled (true) or not (false).Optional
58.0
isSetType
Boolean
For internal use only.
Indicates whether the type field is enabled (true) or not (false).