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:
- Dashboards
- What views are shown in this dashboard? It should include sources for the Widgets and Filters in the dashboard as well.
- 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.
- Query tables
- What tables are used to create this query table
Why we need this API:
- We provide a customized workspace to our clients where they use tables created by us to create their own reports and query tables.
- We want to give a UI in our product's existing permission system where they can choose which reports should be visible to whom.
- 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.
Access your files securely from anywhere
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
harshit.jain
Vaijayanthi V
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho Campaigns Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー