13.7.3 Adding Computed Data Profile Columns

Add computed columns to enrich response payload data, then use their values in regions, Lists of Values, or programmatic code.

Your computed columns use a SQL expression that can reference the names of other data profile columns. For example, imagine you're working with a service whose response payload contains firstName and lastName properties like this:

{
   ⋮
  "firstName": "Jordan",
  "lastName": "Jones"
   ⋮
}

Assume your REST Data Source's Data Profile already contains the columns:

• FIRST_NAME sourced from the firstName, and
• LAST_NAME using the selector lastName

Then, in the Data Profile editor you can click (Add Column >) and choose the Column Type of SQL Expression. You can call your new column FULL_NAME and enter a valid SQL Expression like the following to concatenate the first and last name values together:

FIRST_NAME||' '||LAST_NAME

Other types of computed columns include Lookup and SQL Query (return single value). Once defined, the computed column is a read-only value you can reference anywhere you use the REST Data Source throughout your application.