Loading
Business Rules Engine
Call a Lookup Table from an Integration Procedure

You are here:

  1. Salesforce Help
  2. Docs
  3. Business Rules Engine

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
      }
    ]
  }
}
 
Cargando
Salesforce Help | Article