Pick Fields

The Pick Fields node reduces each row to only the specified fields, removing everything else. Use it to clean up data, reduce payload size, or select specific columns for display.

Configuration

Property	Type	Default	Description
fields	string	--	Required. Comma-separated list of field names to keep (e.g., id,name,email).

Input

Accepts a single object or an array of rows.

Output

Returns the same structure with each row containing only the listed fields. Unlisted fields are removed. If a listed field does not exist in a row, it is included as null.

Example

Input:

[
  { "id": 1, "name": "Alice", "email": "alice@example.com", "internal_notes": "VIP", "password_hash": "..." }
]

Config: fields: "id, name, email"

Output:

[
  { "id": 1, "name": "Alice", "email": "alice@example.com" }
]

How It Works

1. The fields string is split by commas, and each part is trimmed.
2. For each row, a new object is created containing only the specified fields.
3. If the input is a single object (not an array), the result is also a single object.

Example Use Cases

Clean API response for frontend

Remove internal fields before sending data to the browser:

fields: "id, title, description, price, image_url"

Select columns for a data table

fields: "name, email, phone, created_at"

Strip sensitive data

Remove fields that should not be exposed:

fields: "id, display_name, role"

(Removes email, password_hash, secret_key, etc.)

TIP

Pick Fields is the opposite of Set Field. Pick Fields removes unwanted fields; Set Field adds or modifies specific fields.