I'm new to using Meltano, and I have an API that returns data structured as follows:

{
  "A": "",
  "B": "",
  "C": [
    {
      "W": "",
      "X": "",
      "Y": [
        {
          "L": "",
          "M": "",
          "N": ""
        }
      ],
      "Z": [
        {
          "P": "",
          "Q": "",
          "R": ""
        }
      ]
    }
  ]
}

I need to extract specific fields from this data and separate them into three different streams: 1. Stream 1 should include 'W' and 'X'. 2. Stream 2 should include 'W', 'L', 'M', and 'N'. 3. Stream 3 should include 'W', 'P', 'Q', and 'R'. How can I achieve this using Meltano? Should I use a mapper or another method? Please provide suggestions

Hi @Aquib! You could do something like https://gist.github.com/edgarrmondragon/0d39ec2b309c0ef7b055ca18be9584c7. That is, create a parent-child relationship between the streams you defined and pass down the contents of the child streams from the parent's stream response.

Thanks @Edgar Ramírez (Arch.dev), I'll try