I am currently writing a python script to make content edits via the Looker API.
My final piece is updating the filters/custom fields for a merge query. I think the path forward is to:
- Update the two corresponding queries (sdk.create_query())
- Create a new merged query (sdk.create_merge_query()) with the updated queries
- Update the dashboard element (sdk.update_dashboard_element()).
However, I am struggling creating a new merge query. What would this command look like and what are the required inputs? The Looker API documentation and online resources are sparse.
Additionally, has anyone successfully updated a merged query dashboard element before? Any advice would be welcomed!