Linked to this question: <https://meltano.slack.co...
# singer-tap-development
s
Linked to this question: https://meltano.slack.com/archives/C01PKLU5D1R/p1644014783916389 Has anyone ever tried to create a child stream with multiple parents? I know this is currently impossible, but any ideas on hwo to circumvent this issue? My use case is that I have api (hubspot) that takes in a TYPE, and an objectId. I have 2 types, deals and contacts. I currently run through all of the contacts to get their ids and make one query by id. I would like to now run through contacts AND deals to get both their ids and create on large table of web analytics. Any thoughts?
e
Hi @Stéphane Burwash. Does that mean the child stream would only use one parent at a time? Meaning, it's not that the endpoint requires two IDs from different parent entities, rather you'd like to merge two child streams with different parents but otherwise the same structure?
s
Exactly
Would there be any way to accomplish this?
l
Could you create a mixin class that has all the common parts (schema, whatever) and mix it into each of the child streams. It doesn't merge the streams, but deduplicates the code. I'm not sure if that's what you need though.
s
That could be an idea. For now, I just duplicated the streams and that's good enough