Filter JSON Keys

Filters a JSON string based on specific keys.

This activity filters the user-specified JSON string to include or exclude the specified keys with the names in the specified data table input.

Input

• Input: String Argument Required Specifies the input JSON string.

• Include Keys: Boolean Argument Required Specifies whether to include or exclude keys.

  • True - Filters the JSON input to include keys with the names in the input data table.

  • False - Filters the JSON input to exclude keys with the names in the input data table.

• Filter: DataTable Variable Required Specifies the Datatable input that is used to filter the given JSON Array. The data table used for filtering must contain key inputs based on which the JSON Array is to be filtered.

The DataTable containing the keys for filtering the JSON Array.

• Key Column Name: String Argument Required Specifies the column name of the data table used in the Filter property that indicates the Keys of the key-value pair to filter the JSON input.

Output

• Result: String Variable Specifies the filtered variable.