Insert To Children By Query

​

Overview

• Inserting a parent-level field into every child object
• Using JSONPath to select which data to inject
• Enriching child objects with data from a different level

​

Command Type

​

Parameters

​

Usage Examples

​

Insert Parent ID into Children

{
  "command": "insert-to-children-by-query",
  "params": {
    "fieldName": "eventId",
    "query": "$.data.id"
  }
}

​

Insert Timestamp into Children

{
  "command": "insert-to-children-by-query",
  "params": {
    "fieldName": "collectedAt",
    "query": "$.data.timestamp"
  }
}

​

Common Use Cases

• Parent-Child Enrichment: Inject a parent identifier (e.g. event ID) into each child record
• Metadata Propagation: Attach parent-level metadata to nested child objects
• Data Denormalization: Flatten hierarchical data for downstream sink commands

​

Related Commands

• Insert To Children By Query List - Insert multiple fields at once
• Insert To Children - Insert parent attributes using key mapping
• Key Mapping - Map fields after insertion