Operate on JSON

Use the Operate on JSON action to set, edit, and normalize JSON objects.

• Set Key_Value Pair: Set the key value pair for selected JSON. If the key exists, update its corresponding value; if the key does not exist, automatically add the key and assign a value to it.
  
• Remove Key_Value Pair: Remove the key value pairs which are matched the defined conditions.
  
• Normalize: You can normalize the selected JSON by applying the following rules. See JSON Settings for more details.
  

• Sort all lists by specified keys
• Sort all JSON keys in ascending order
• Ignore the content by selected keys
• Ignore different representations of missing values as null
• Convert all the JOSN values to lowercase