Insert To Children

​

Overview

• Selecting parent objects with a JSONPath query
• Selecting child objects within each parent with a JSONPath query
• Copying specific parent attributes into each child object using mapping rules

​

Command Type

​

Parameters

​

KeyMapping

​

Usage Examples

​

Insert Event Fields into Markets

{
  "command": "insert-to-children",
  "params": {
    "query": "$.events[*]",
    "keyChildren": "$.markets[*]",
    "mapping": [
      { "from": "$.id", "to": "eventId" },
      { "from": "$.startTime", "to": "eventStartTime" }
    ]
  }
}

​

Insert League Info into Fixtures

{
  "command": "insert-to-children",
  "params": {
    "query": "$.leagues[*]",
    "keyChildren": "$.fixtures[*]",
    "mapping": [
      { "from": "$.leagueId", "to": "leagueId" },
      { "from": "$.leagueName", "to": "leagueName" },
      { "from": "$.sportId", "to": "sportId" }
    ]
  }
}

​

Common Use Cases

• Hierarchy Flattening: Propagate parent identifiers into nested children
• Data Enrichment: Attach parent context to child records for downstream processing
• Denormalization: Combine parent and child fields into flat records for sink commands

​

Related Commands

• Insert To Children By Query - Insert a single field using a query
• Insert To Children By Query List - Insert multiple fields at once
• Key Mapping - Remap object keys