Edit Fields

Edit Fields

What it does: Transforms and cleans up data by renaming fields, converting data types, and applying validation rules.

Perfect for: Data cleaning • API response processing • Form data preparation • Field standardization

What It Does

• Rename fields - Change field names to match your needs
• Convert data types - Turn strings into numbers, dates, etc.
• Clean values - Remove extra spaces, fix formatting
• Add validation - Ensure data meets your requirements

How It Works

graph LR
    A[🌐 Raw Data] --> B[✏️ Edit Fields]
    B --> C[📊 Clean Data]

    style A fill:#e1f5fe
    style B fill:#e8f5e8
    style C fill:#f3e5f5

Simple flow: Raw data → Edit Fields node → Clean, formatted data

Common Operations

Rename Fields

{"action": "rename", "from": "user_name", "to": "username"}

Convert Types

{"action": "convert", "field": "age", "type": "number"}

Clean Values

{"action": "transform", "field": "email", "function": "toLowerCase"}

Add New Fields

{"action": "add", "field": "timestamp", "value": "{{now}}"}

Real Example

Before (messy data):

{
  "user_name": "Alice Smith",
  "age": "28",
  "email": "ALICE@COMPANY.COM"
}

After (clean data):

{
  "username": "Alice Smith",
  "age": 28,
  "email": "alice@company.com"
}

What happened: Renamed “user_name” to “username”, converted age from text to number, and made email lowercase.

Common Use Cases

Clean web scraped data - Fix messy field names and data types from websites Prepare API data - Format data before sending to external services Process form submissions - Clean and validate user input data Standardize data - Make data consistent across different sources

Quick Troubleshooting

Field not found errors: Check that field names match exactly (case-sensitive) Type conversion fails: Make sure the data can actually be converted (e.g., “abc” can’t become a number) Operations not working: Verify your JSON syntax is correct

What’s Next?

Related nodes: Filter • Merge • HTTP Request

Common workflows: Data Processing Patterns • Web Extraction Workflows • API Integration

Learn more: Data Transformation Guide • Multi-Step Workflows