Create Table

POST {{_endpoint}}/services/data/v{{version}}/connect/business-rules/decision-table/definitions

Decision Table Definitions (POST)

Create a decision table definition. A decision table definition contains all the details required to create a decision table.Resource

/connect/business-rules/decision-table/definitions

Resource Example

https://yourInstance.salesforce.com/services/data/v59.0/connect/business-rules/decision-table/definitions

Available version

58.0

Requires Chatter

No

HTTP methods

POST

JSON example for a single object source

{
   "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"
      }
   ]
}

JSON example for a multi-object source

{
   "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"
      }
   ]
}

Request body for POSTProperties

Response body for POST

Decision Table Output

Decision Table Output

Output representation of the decision table details.JSON example for GET, POST, and PATCH

{
   "code":"200",
   "decisionTable":{
      "collectOperator":"Count",
      "conditionCriteria":"1 OR 2 OR 3",
      "conditionType":"Any",
      "decisionResultPolicy":"UniqueValues",
      "description":"Eligiblity of Products using Qualification Rules",
      "id":"0lDxx00000000BJ",
      "parameters":[
         {
            "fieldName":"IsDeleted",
            "isGroupByField":false,
            "isPriority":false,
            "operator":"Equals",
            "sequence":1,
            "usage":"Input"
         },
         {
            "fieldName":"CreatedById",
            "isGroupByField":false,
            "isPriority":false,
            "usage":"Output"
         },
         {
            "fieldName":"Title",
            "isGroupByField":false,
            "isPriority":false,
            "operator":"Equals",
            "sequence":3,
            "usage":"Input"
         },
         {
            "fieldName":"Id",
            "isGroupByField":false,
            "isPriority":false,
            "operator":"Equals",
            "sequence":2,
            "usage":"Input"
         }
      ],
      "setupName":"Product Qualificiation eligibility3",
      "sourceCriteria":[

      ],
      "sourceObject":"AccountFeed",
      "sourceType":"SingleSobject",
      "sourceconditionLogic":"1 AND 2 AND 3",
      "status":"Draft"
   },
   "isSuccess":true,
   "message":""
}

JSON example for DELETE

{
   "code":"200",
   "isSuccess":true,
   "message":""
}

Request Body

{"setupName"=>"Product Qualificiation eligibility", "fullName"=>"ProductQualificationEligibility", "description"=>"Eligiblity of Products using Qualification Rules", "sourceObject"=>"AccountFeed", "status"=>"Draft", "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"}]}

RESPONSES

status: Created

{"code":"200","decisionTable":{"id":"0lDHo0000008Pnt","parameters":[],"sourceCriteria":[]},"isSuccess":true,"message":""}