I'm looking to query all the filters used in a workbook. The solution i have implemented is far from pretty:
1. activating all sheets using a timed loop
2. getting worksheets in existing dashboard
3. Using method getFiltersAsync() on worksheets to get the filters in the worksheet.
This approach is taking a significant amount of time, can you please suggest a better way?
Can someone suggest how can i get those objects?