FlowEngine Data Standardize & CleanInstall

Summary

Clean and format phone numbers to the E.164 standard using a specified phone field and a default country code if none is detected.

Inputs

• Phone Field (required) — The JSON field containing the phone number to clean. Supports dot notation for nested fields (e.g., "contact.phone").
• Default Country Code — Country code to assume if the phone number does not already include one, specified without the plus sign (e.g., "1" for US/Canada).
• Output Field — Optional field name to save the cleaned phone number. If left empty, the original phone field is overwritten.
• Options — Additional options controlling behavior including tracking changes, continuing on failure, skipping unchanged items, case insensitive field matching, and debug information.

Output shape

a list of JSON objects representing input items, each with the phone number cleaned and formatted to E.164 standard; may include additional fields such as _changes and _debug depending on options.

If 'Output Field' is specified, the cleaned number is saved there; otherwise, it overwrites the original phone field. Options allow inclusion of detailed change logs (_changes), skipping items without changes, and adding debug info (_debug). Processing can continue for other items if one fails depending on settings.