Data Import » Control » Value conversions » Value filters

Value filters

Input data can be passed through multiple value filters to convert the values in the input Record.

filters

Array of value filter names.

Filters are applied in the order they are specified in the control file. If generic value mapping is used, this is performed before the filters.

Example

Your input data might include usernames of users supplied in the User sync. To convert these usernames into a Ref which can be used by a load Instruction, use:

{
    "source": "PERSON-USERNAME",
    "destination": "load:by-ref",
    "name": "ref",
    "filters": ["haplo:username-to-ref"]
}

Available value filters

The standard filters provided by the data import framework may be augmented by other plugins. To view the available filters, use the admin UI:

Value filters implemented by the framework and user sync are:

haplo:code-to-ref
haplo:fix-up-url
haplo:string-to-ref
haplo:to-lower-case
haplo:to-upper-case
haplo:username-to-ref