Loading
Upcoming Mandatory Changes to Public Key Infrastructure (PKI)Read More
Salesforce Enforces New Security Requirements in Summer 2026Read More
Business Rules Engine
Table of Contents
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

          Search all of Salesforce Help
          Call a Lookup Table from an Integration Procedure

          Call a Lookup Table from an Integration Procedure

          To call a lookup table from an Integration Procedure, and return the specified matrix’s results to the Integration Procedure, use the Decision Matrix Action.

          Required Editions

          Available in: Lightning Experience
          Available in: Enterprise, Unlimited, and Developer Editions for clouds that have Business Rules Engine enabled
          User Permissions Needed
          To access Omnistudio to create and modify an Integration Procedure: Omnistudio Admin
          To access Business Rules Engine to create and activate a decision matrix or decision table version: Rules Engine Designer
          To call a lookup table from an Integration Procedure: Omnistudio Admin

          You can call only active lookup tables from an Integration Procedure.

          1. From the App Launcher (App launcher icon.), find and select Omnistudio.
          2. From the app navigation menu, select Omnistudio Integration Procedures.
          3. Select an Integration Procedure, and then select the version that you want to modify.
          4. From the Actions panel, drag Decision Matrix Action onto the Structure panel.
          5. In the Decision Matrix Properties section, specify these decision matrix or decision table action properties:
            Field Description
            Matrix Input Parameters: Data Source The name of a data JSON node in the Integration Procedure that contains a value to pass to the decision matrix.
            Matrix Input Parameters: Filter Value The name of the corresponding decision matrix input variable that accepts the value.
            Matrix Name The name of the decision matrix that you want to call.
            Remote Options

            Additional options to pass to the Decision Matrix. These options are predefined, but you can also pass options specific to the matrix.

            • executionDateTime — Sets the Effective Date of the Decision Matrix.
            Default Matrix Result Value to return if the Decision Matrix returns null

            For example, if you're adding a decision matrix with the name StudentDiscountEligibility, and the input variables that the matrix takes are Age and GPA, then enter these values:

            • Matrix Name: StudentDiscountEligibility
            • Matrix Input Parameters:
              Data Source Filter Value
              Age Age
              GPA GPA
          6. From the Actions panel, drag the Response Action component, and place it below the Decision Matrix Action in the Structure panel.
          7. Enter these properties:
            • Send JSON Path: Enter the element name of the Decision Matrix Action. This path is used as the JSON node to store the data.
            • Send JSON Node: Specify a new name for the parent node in the outgoing request. For example, my_output.
          8. Click Preview.
          9. In the Input Parameters panel, add Key/Value pairs.
            For example:
            KeyVALUE
            Age 16
            GPA 3.5
          10. Click Execute.
            Here’s what the output looks like:
            {
              "my_output": {
                "result": [
                  {
                    "Qualified": true
                  }
                ]
              }
            }
           
          Loading
          Salesforce Help | Article