a!toJson( value, removeNullOrEmptyFields )
Converts a value into a JSON string.
The value to convert into a JSON string.
Determines whether fields with values that are null, empty strings, or empty arrays are removed from the JSON output. Default: false.
The value parameter must be a CDT, a dictionary, a map, a record, or a list.
The removeNullOrEmptyFields parameter removes all fields with values that are null, empty strings, or empty arrays from the generated JSON request body. This is important for certain web services, such as those that follow the OData protocol. Some web services treat fields with null values differently from fields that aren't included in the request body at all. Omitting a field may mean "don't modify the field," while sending a null value for that field would mean "write a null value to the field."
The behavior of removeNullOrEmptyFields can also be leveraged for integrations that send a JSON request body by selecting the checkbox labeled Remove fields with null or empty values from generated JSON.
|Custom Record Field Expressions||Incompatible|
There are older versions of this function. You can identify older versions by looking at the name to see if there is a version suffix. If you are using an old version, be sure to refer to the corresponding documentation from the list below.
|Old Versions||Reason for Update|
Improved support for datetime values. This removes the need to create a supporting conversion rule.
To learn more about how Appian handles this kind of versioning, see the Function and Component Versions page.
On This Page