FlowEngine Data Standardize & CleanInstall

Summary

Format phone numbers to the E.164 standard using a specified input field and default country code, optionally saving the cleaned phone number to the original or a different output field.

Inputs

• Phone Field (required) — The input field name containing the phone number to clean; supports dot notation for nested fields.
• Default Country Code — The default country code (without +) to apply when none is detected in the phone number, e.g., '1' for US/Canada.
• Output Field — Optional field name to save the cleaned phone number; leave empty to overwrite the original phone field.
• Options — Collection of optional settings including case insensitive field matching, continue on fail, debug mode to include transformation details, skipping unchanged items, and tracking changes with before/after values.

Output shape

a list of items each containing JSON data representing the input data with cleaned phone numbers applied according to parameters.

Each output item corresponds to an input item. Changes are applied to the specified output field or overwrite the input field. If debug mode is enabled, a _debug field is included showing field lookup and transformation details. If track changes is enabled, a _changes field shows what was modified. If skip unchanged is enabled, items with no changes may be excluded from the output.

Examples

Example 1: Clean phone numbers from a nested contact.phone field using default US country code, overwrite original field.

Set Phone Field to 'contact.phone', Default Country Code to '1', leave Output Field empty.

Example 2: Clean phone numbers from a top-level 'phone' field, save cleaned value to 'phoneFormatted', enable tracking changes.

Set Phone Field to 'phone', Output Field to 'phoneFormatted', enable 'Track Changes' option.