Advanced Filtering

Advanced Filtering is a data filtering feature seen in conversions, which includes two types of filtering:

• Field Filtering
• Array Filtering

Field Filtering allows a user to specify which fields in an object should be included in the output data when creating a data mapping (conversion).

For example, let’s say you have an object called ‘Weather’ as shown below. In your output, you only want to show the temperature and location field from this object. Field filtering allows you to select which fields are needed for your output.

fieldfilterexample

{
    “weather”: {
        “temp” : 25,
        “humidity” : 60,
        “location” : “Amsterdam”
     }  
}

Array Filtering allows an array field in your input data to be filtered on based on defined criteria.

For example, let’s say you have an object array called ‘Weather’ as shown below. In your output, you only want to show the temperature if the location is Amsterdam. Array filtering allows you to define a filter based on the key you want to filter on.

arrayfilterexample

{
    “weather”: [
        {
            “location” : “Amsterdam” , 
            “temp” : 25
        },
        {
            “location” : “Breda” , 
            “temp” : 30
        }
    ]   
}

Configure Field Filtering

To configure or modify field filtering for your conversion, enter the ‘Data conversions’ page by clicking on the Data option in the menu screen.

Note

To configure field filtering, you first need to create a conversion. Please refer to the Conversions Basics Guide

1. Click on the arrow to enter the conversion design space

2. Drag and drop the required fields into the middle panel (Specifications panel)

3. Click on the three dots of the dropped field in the middle panel

4. Click on Extract properties

5. Select the properties to be extracted

6. Click Select

7. Click on the three dots of the extracted property

8. Click on Select fields

9. Select the relevant protocol property(s)

10. Click Apply

Configure Array Filtering

To configure or modify array filtering for your conversion, enter the ‘Data conversions’ page by clicking on the Data option in the menu screen.

Note

To configure array filtering, you first need to create a conversion. Please refer to the Conversions Basics Guide

1. Click on the arrow to enter the conversion design space

2. Drag and drop the required fields into the middle panel (Specifications panel)

3. Click on the three dots of the dropped field in the middle panel

4. Click on Apply filters

5. Choose the property to be filtered on

6. Choose the filter operation. (For example, filter property ‘name’ contains “…”, or filter property ‘numberval’ equals “…”)

7. Choose entity to compare:

• Compare to constant value is a user-defined value that can be inputted.
• Drop an existing property can be used by dropping a property from the Input panel.

8. Click the blue checkmark when finished

9. Click on the Apply filter button on the top right corner