Quick way to check a workbook for applied filters

Follow

Dave Olsson

• June 17, 2021 17:00

Is there a way to return a list of applied filters in any workbook by sheet? Filters left intentionally "in" (testing, vetting etc.) seem to be my Achilles heel. It would be great for peace of mind to know quickly if I've accidentally left any filters in place without having to drive through the entire book/process. 

0

• 

  Konsta Danyliuk

  • June 17, 2021 18:14

  Hello Dave.
  You could retrieve a Workbook structure as a JSON file via REST API and then review this file to check filters.

  You would need the Read a Workbook call.

  curl -u '<username>:<password>' -X GET 'http://<Datameer-serverIP>:<port-number>/api/workbooks/<file-id>'

  It might be good to put together a short script that will execute the REST API call and extract filter definitions from its response.

  0

  Comment actions Permalink

Please sign in to leave a comment.