https://linen.dev logo
#plugins-general
Title
# plugins-general
a

Aquib

01/06/2024, 12:14 AM
I'm new to using Meltano, and I have an API that returns data structured as follows:
Copy code
{
  "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