--- schema_version: "1" id: 67c07713bdc98be4a3ef985dc042a449398c91dc131762a5721e080db3e9df00 title: Set Values Action for Integration Procedures collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/xcloud/264-0-0/os_set_values_for_integration_procedures_50310.md canonical_url: https://help.salesforce.com/s/articleView?id=xcloud.os_set_values_for_integration_procedures_50310.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: ccf143ad60975f70fc6ffa4f03a14b5c39bf424bbbaf1bdffef8cb54180880a1 description: The Set Values action sets values in the data JSON of an Integration Procedure using literal values, merge fields, or formulas. products: - Omnistudio release: "264" --- # Set Values Action for Integration Procedures The Set Values action sets values in the data JSON of an Integration Procedure using literal values, merge fields, or formulas. ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-xcloud-omnistudio-264-0-0-production-enus/f526eaa8-ae05-487a-8944-4bb99b0b78ac/images/icon_note.png) Note Any text between two percent (%) signs in a Set Values formula is treated as a [merge field](https://help.salesforce.com/s/articleView?id=xcloud.os_access_integration_procedure_data_json_with_merge_fields_48435.htm&release=264.0.0&type=5 "Enable Integration Procedure elements and element properties to access data JSON using merge fields. A merge field is a variable that references the value of a JSON node. For example, if a JSON node is \"FirstName\": \"John\", then the merge field %FirstName% returns John."). To represent literal percent (%) signs, use the `$Vlocity.Percent` [environment variable](https://help.salesforce.com/s/articleView?id=xcloud.os_environment_variables_in_dataraptors_and_integration_procedures_47878.htm&release=264.0.0&type=5 "You can use environment variables to define Default Values and Filter Values, and in Formulas."). The Set Values action doesn’t support custom labels. ## Properties

Property

Description

Element Value Map: Element Name

The JSON node for which the value is to be set.

Element Value Map: Value

The value to assign to the JSON node. Options:

  • Merge fields from a previous step (%elementName%)

  • Literal value

  • Concatenated values

  • Results of formulas and functions

  • Expressions that combine the options: "Case Status: %caseStatus%"
## Examples For the following examples, consider this sample input JSON. ```json { "Name": { "FirstName": "John", "LastName": "Smith" }, "Finances": { "GrossIncome": "100000", "Expenses": "60000" } } ``` **Rename Nodes in the Input Data** To shorten and simplify the input JSON nodes, set the Element Value Map like this example.

Element Name

Value

FirstName

%Name:FirstName%

LastName

%Name:LastName%

GrossIncome

%Finances:GrossIncome%

Expenses

%Finances:Expenses%
**Set Literal Values** To set literal values, which are useful for testing or for specifying data that doesn't change, set the Element Value Map like this example.

Element Name

Value

Location

San Francisco

Code

2345
**Concatenate Literal Values and Merge Fields** To concatenate a literal string with a merge field, set the Element Value Map like this example.

Element Name

Value

LocationCode

Code is %LocationData:Code%
The `%LocationData:Code%` merge field retrieves data from the previous component, LocationData. **Define an Array** To set up an array, click **Edit as JSON** and edit the `ElementValueMap` node like this example. ```json "elementValueMap": { "Departments": [ "Sales", "Development", "Support", "Training" ] }, ``` **Perform Simple Calculations Using Formulas** To perform calculations, use operators in the the Element Value Map like these examples.

Element Name

Value

AfterTaxIncome

=%Inputs:GrossIncome% * 0.7
Set the Element Value Map of CalculateNet as follows:

Element Name

Value

NetIncome

=%AfterTax:AfterTaxIncome% - %Inputs:Expenses%
**Concatenate Two Merge Fields** To concatenate two merge fields, set the Element Value Map like this example.

Element Name

Value

FullName

=%Inputs:FirstName% + " " + %Inputs:LastName%
Notice the literal space included to separate the first and last names. **Use a Function and Retrieve an Array Value** This example uses the IF function. It also uses listnode`|`listnumber notation to retrieve array values.

Element Name

Value

Department

=IF(%Inputs:FirstName% = "John",%DeptArray:Departments|2%,%DeptArray:Departments|3%)
This component assigns a Department value of Development to anyone named John and a Department value of Support to anyone not named John. Notice that the second equals sign has spaces before and after it, to distinguish it from the function. ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-xcloud-omnistudio-264-0-0-production-enus/f526eaa8-ae05-487a-8944-4bb99b0b78ac/images/icon_note.png) Note By default, if an IF function output is a large number, it's converted to scientific notation. To prevent this conversion if the large number is an identifier and not a math operand, wrap the IF function in a TOSTRING function. **Perform a Complex Date Calculation** This example uses four nested date functions to return the first day of the current month.

Element Name

Value

FirstOfThisMonth

=ADDDAY(EOM(ADDMONTH(TODAY(),-1)),1)
**Create a Structure for Output Data** This example creates a JSON structure for the transformed data. To set up the structure, click **Edit as JSON** and edit the `ElementValueMap` node like this sample JSON. ```json "elementValueMap": { "Output": { "FullName": "%ConcatName:FullName%", "Department": "%RetrieveDept:Department%", "AfterTaxIncome": "%AfterTax:AfterTaxIncome%", "NetIncome": "%CalculateNet:NetIncome%", "Location": "%LocationData:Location%", "LocationCode": "%TextWithCode:LocationCode%", "FirstOfThisMonth": "%CalcFirstOfThisMonth:FirstOfThisMonth%" } }, ```