RecordsFilter Core Add-On Module.

This module allows you to apply advanced filtering to the source records before they are uploaded to the Target.

Table of Contents

• Example of module setup.
• BadWords Filter.
• List of the args properties for BadWords filter.
• Additional information about this Add-On module.

Example of module setup. ⇧

In order to modify records by using the RecordsFilter Core Add-On Module, you should declare the module call in your export.json.

Let's see the example of the configuration below:

{
     "objects": [
     {
         "operation": "Upsert",
         "externalId": "LastName",
         "query": "SELECT LastName, Description FROM Contact",
         "filterRecordsAddons": [
            {
                "module": "core:RecordsFilter",
                "args" : {
                    "filterType": "BadWords",
                    "settings" : {
                        "badwordsFile": "./badwords.json",
                        "detectFields": [
                            "Description"
                        ],
                        "highlightWords" : true,
                        "outputMatches": true
                    }
                }
            }
         ]
     }
 ]
}

In this example the RecordsFilter module executes the filter of the type defined by the filterType property. You can see, that the name of the executed filter is BadWords.

The filter is fired by the OnFilterRecords event. This is the only allowed event for this type of Core Add-On because the purpose of this filter is exactly to filter the records. Binding RecordsFilter Add-On to another event will throw runtime error.

Notes:

• Each filter has its own settings definition.

• You can mix between filters and even execute multiple filters of the same type. Put all filters you want to run in the filterRecordsAddons array.

• We plan to release new filters from time to time.

• Find below the full list of the currently available filters.

BadWords Filter. ⇧

The BadWords filter scans the object's fields listed in the detectFields for the unwanted words, then can output the matched words to the console or even modify the source field value to highlight these words, then upload the modified value to the Target (or write to the CSV file).

The BadWords filter can be very useful for example for GDPR requirements.

This filter was implemented thanks to the contribution of the author of the amazing tool SFDX Hardis

List of the args properties for BadWords filter. ⇧

Additional information about this Add-On module. ⇧

• The json file allowed to be placed in any location on the disk. You can name it differently, but the default name when you omit this property is badwords.json. Populate this property with the absolute path (or the path relative to the export.json).

• If badwords.json does not exist or has incorrect format the module will throw an error.

• The records are getting filtered only if the desired field is included in the object's query string and the field is of updateable type.

• Below is the required format of the badwords.json file:

  {
      "badwords" : [
          "bad",
          "word"
      ]
  }
  

  List all bad words int the badwords array.

See also Supported Add-On Api Events