Custom Connector - Selecting Multiple Values from Parent Stream

Summary

User inquires about the ability to select additional fields from a Parent Stream in their custom connector, specifically the ‘price’ field, alongside the Parent Key (ID). Seeks possible workarounds for this limitation.


Question

Hi all :wave:,

I’m quite new to Airbyte Cloud and currently building my first custom connector. Is it in any way possible to select multiple values from your Parent Stream other than the Parent Key alone? I seem to only be able to select the ID which is the PK of the Parent Stream, but in my “Child Stream” installments I’d also like to select field price from the Parent Stream. I’ve looked online and in this Slack for any help on this but I’m still wondering if this is possible with some sort of work around. Any help will be much appreciated.

      "price": "23200.000000",
      "id": "xxx",
      "start_date": "2019-02-01",
      "end_date": "2019-10-01",
      "installments": [
        {
          "name": "Second",
          "percentage": 50.043103448275865,
          "invoice_id": "x1"
        },
        {
          "name": "Third",
          "percentage": 46.5948275862069,
          "invoice_id": "x2"
        }
      ],```

<br>

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. [Click here](https://airbytehq.slack.com/archives/C021JANJ6TY/p1733305666367789) if you want
to access the original thread.

[Join the conversation on Slack](https://slack.airbyte.com)

<sub>
['custom-connector', 'multiple-values', 'parent-stream', 'child-stream', 'airbyte-cloud']
</sub>

It’s better to ask this question in <#C027KKE4BCZ|>