Need new API to get dependency details of all views in workspace

Need new API to get dependency details of all views in workspace

I want to request a new API to get source tables and query tables for all the views in a workspace.

Feature Request Details:
There needs to be an API which gives the following details for all views in the workspace in a single request:
  1. Dashboards
    • What views are shown in this dashboard? It should include sources for the Widgets and Filters in the dashboard as well.
  2. Reports (Chart View, Pivot View, Summary View, Table View)
    • What tables or query tables were used to create this report. It should include all tables, including the ones used in Graph tab, Filters tab, User Filters tab, Thresholds etc.
  3. Query tables
    • What tables are used to create this query table

Why we need this API:
  1. We provide a customized workspace to our clients where they use tables created by us to create their own reports and query tables.
  2. We want to give a UI in our product's existing permission system where they can choose which reports should be visible to whom.
  3. To apply filter criteria properly and only share the tables needed for the reports, we need API access to know the tables and query tables used to create the selected reports.

Testing Done On Existing APIs
We checked your existing APIs and they don't provide this data. There are two APIs which have a "withInvolvedMetaInfo" parameter like "Get View Metadata" from V1 API and "Get View Details" from V2 API. But this gives extra tables which are connected using lookup columns.

Also these APIs work on a single view only. We have lots of reports and making many individual calls on every view for each time we need this info is not efficient.