Moved to Developer Community.
You can use workbook.getActiveSheet() to get the current worksheet so that you can start working with the sheet.
I hope this gives you a good starting point.
1 of 1 people found this helpful
sorry thats not what i meant , i know some about the controls , i just want to get a list of available Parameters/Filters INSIDE the workbook/dashboard i.e a country filter etc.
in the API reference you only seem to be able to get it post event and only the parameter that triggered the event i simply want a list of all the parameters inside the workbook/dashboard.
Yeah, you can do this. FYI, it’s all documented in help. Take a look at the getParametersAsync() method, which allows you to return a collection of parameters. You then call methods against the collection like paramCollection(“Param Name”).getDataType() and so on.
Example of this stuff in action can be found here, towards the bottom of the list:
ive not seen that example site before thanks i will have a look.
btw on that site how do you see the actual script being used ?
Your browser has a way to view it – IE has F12 developer tools, Chrome has ctrl-shift-J, etc.