FlowEngine Data Standardize & CleanInstall

Summary

Parse and decompose a phone number field into multiple standardized components, adding these as new fields with a configurable prefix.

Inputs

• Phone Field (required) — The name of the field containing the raw phone number to parse. Supports case-insensitive matching and nested fields using dot notation.
• Default Country Code — The default country dialing code to assume if none is detected in the phone number (e.g., '1' for US/CA, '44' for UK, '91' for India).
• Output Prefix — A string prefix to prepend to all generated output fields, such as 'phone_' to create output fields like phone_e164, phone_national, etc.
• Options — Additional configuration options including case-insensitive field matching (default true), whether to continue processing on failure, enabling debug mode to add detailed steps to a _debug field, skipping unchanged items from output, and tracking detailed changes in a _changes field.

Output shape

A list of items, each containing the original data JSON augmented with new fields representing different phone number components (e164, national, international format, country code, area code, local number, extension, and validity).

Output fields are named by combining the specified output prefix with component names. If the phone field is missing or null, no components are added and the item is optionally annotated with debug or change information depending on options. Debug information includes detailed lookup and transformation steps. The operation supports nested fields and case-insensitive matching as configured.