Insert To Children By Query List

​

Overview

• Inserting multiple fields into child objects in a single command
• Applying each query-field pair sequentially to all children
• Reducing pipeline complexity when multiple parent fields need to be injected

​

Command Type

​

Parameters

​

InsertToChildrenByQueryParams

​

Usage Examples

​

Insert Multiple Parent Fields

{
  "command": "insert-to-children-by-query-list",
  "params": {
    "queries": [
      {
        "fieldName": "eventId",
        "query": "$.data.id"
      },
      {
        "fieldName": "sportId",
        "query": "$.data.sportId"
      },
      {
        "fieldName": "leagueId",
        "query": "$.data.leagueId"
      }
    ]
  }
}

​

Insert Metadata and Timestamp

{
  "command": "insert-to-children-by-query-list",
  "params": {
    "queries": [
      {
        "fieldName": "source",
        "query": "$.data.provider"
      },
      {
        "fieldName": "collectedAt",
        "query": "$.data.timestamp"
      }
    ]
  }
}

​

Common Use Cases

• Bulk Enrichment: Inject multiple parent-level identifiers into child records in one step
• Data Denormalization: Flatten hierarchical data with multiple parent attributes
• Pipeline Simplification: Replace multiple sequential Insert To Children By Query commands with one

​

Related Commands

• Insert To Children By Query - Insert a single field into children
• Insert To Children - Insert parent attributes using key mapping rules
• Key Mapping - Remap fields after insertion