Filter JSON Array

Filter JSON Array entries.

This activity filters the given JSON array entries and their count.

Input

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

• 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-value inputs. That is; the data table must contain 2 columns that contain the key and the value that is used to filter the JSON array. For Example:-

A sample DataTable to be used as filter with Key - Value inputs as two Columns

• 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 array input.
• Value Column Name: String Argument Required Specifies the column name of the data table used in the Filter property that indicates the Value of the key-value pair to filter the JSON array input.

Output

• Result: String Variable Specifies the filtered JSON.
• Count: Integer Variable Specifies the count of the entries in the filtered JSON.