Access Integration Procedure Data JSON with Merge Fields

Merge fields access data JSON using syntax to indicate to an Integration Procedure element that a merge field is present. The syntax requires you to wrap a full JSON path with a percent sign on both ends.

Common Use Cases

• Setting values to rename elements, access JSON nodes, run formulas, and populate elements. See Set Values Action for Integration Procedures.

• Access data stored in Integration Procedure elements in a formula or in a future step.

• Access data returned from an action. For example, an Omnistudio Data Mapper Action or an HTTP Action returns data from Salesforce or an external source. See Integration Procedure Actions.

Access the Data JSON

Use existing data JSON in an element property by indicating the use of a merge field.

1. Locate the name of the JSON node in the Integration Procedure's data JSON.

2. Enter the name of the JSON node and wrap the name in percentage signs to indicate it's a merge field. For example, a merge field accessing a JSON node named firstName must use the syntax %firstName%.

3. Preview the Integration Procedure to ensure the merge field works correctly.

Additional Syntax

This table provides additional syntax examples for nested JSON.

"ContactInfo": {
    "FirstName": "John"
  }

%ContactInfo:FirstName%

 "ContactInfo": {
    "ContactInfoList": [
      {
        "FirstName": "John"
      },
      {
        "FirstName": "Adam"
      },
      {
        "FirstName": "Steve"
      }
    ]
  }

%ContactInfo:ContactInfoList|3:FirstName%