Accessing nested field value in Airbyte stream

Slack Knowledge Base Q&A Platform Questions
, , , ,
1

Summary

The user is trying to access a nested field value in an Airbyte stream but is unsure how to do it. They need to retrieve the ‘cardId’ value from the ‘paymentSource’ field to use in a request.


Question

Hi guys,

I’m trying to get a cardId value in an nested field, but the documentation doesn’t say how this works.

The record in the parent stream comes like this:

    "sourceType": "card",
    "cardId": "fd467cdb-57fa-47d4-81cd-52900e7d0188"
}```
I need to get the cardId value to indicate in the request:
`/v1/cards/{{ stream_partition.paymentSource.cardId }}`

<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/p1726855687409029) if you want 
to access the original thread.

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

<sub>
["nested-field-value", "airbyte-stream", "cardid", "request"]
</sub>