Question

How to change fully scoped field names in Looker API query body

  • 19 May 2022
  • 0 replies
  • 42 views

I’m using the Looker API Get Query to change the underlying view of some dashboards (I’m trying to simplify and automate what I’ve been doing in the content validator). All of the field names include the view name like “table1.customer_name”. Is there a way to replace all of these view references in one step? For example, “table1.customer_name” becomes “table2.customer_name”.

I’ve been successful changing each reference individually by accessing portions of the query response such as “filter”, “share_url”, “dynamic_fields”, “sorts”, ect. but this gets complicated when all the dashboards have different queries. 

Thanks for the help!


This topic has been closed for comments