Hi all,
in the "Appear X Platform" connector, the "Output Redundancy Settings" and "Output Redundant Sources" tables contain similar parameters. I need to be able to retrieve this data as a single table within a dashboard. I have already tested a query using a JOIN, but it did not work. What options do I have to retrieve the data as a single table in a dashboard?

Desired result for the dashboard.

Thanks and best regards
Christoph
This approach requires a large number of joins because I need data from very different tables, and I have to read the inputs on the Appear X multiple times to query them all. It works in principle, but when I finally put everything together, it stops retrieving data, even after 30 minutes, there is no data.
It stays like that

I removed the part up to the point where it worked.

Then I tried another part, and it was working as well.

Both parts worked independently, but not together.
Here is the JSON code for the various queries. Red is used for all queries, violet only for the first query, and green only for the second query.
Non funktional querie

Functional first querie.

Functional second querie.

Thanks and best regards
Christoph