can I use a list of id from a parent stream for va...
# help-connector-development
t
can I use a list of id from a parent stream for value list in Partition router? I need an answer for this, please
k
A message from kapa.ai
Yes, you can use a list of IDs from a parent stream for value list in the Partition router. To achieve this, you need to use the "Substream" partition router. It allows you to select another stream of the same connector to serve as the source for partitions to fetch. Each record of the parent stream is used as a partition for the current stream. To configure the substream partition router, you need to set the following fields: - "Parent stream": defines the records of which stream should be used as partitions. - "Parent key": the property on the parent stream record that should become the partition value (usually some form of ID). - "Current partition value identifier": a freely chosen identifier for the variable holding the current partition value. It can be used in the path of the stream using the
{{ stream_partition.<identifier> }}
[interpolation placeholder](https://docs.airbyte.com/connector-development/config-based/understanding-the-yaml-file/reference#variables). For more details, refer to the [Dynamic and static partition routing > Substream partition router](https://docs.airbyte.com/connector-development/connector-builder-ui/partitioning) section in the Airbyte documentation.