Example Ruby API script to update a Look

[rducarrouge]

Knowledge Drop

Last tested: Jun 8, 2018
 

require 'looker-sdk'



LOOKER_ID = ENV['LOOKER_ID'],

LOOKER_SECRET = ENV['LOOKER_SECRET']

LOOKER_PATH = 'https://company.looker.com:19999/api/3.0'



looker = LookerSDK::Client.new(

:client_id => LOOKER_ID,

:client_secret => LOOKER_SECRET,

:api_endpoint => LOOKER_PATH

)



# get look, here look id 32

my_look = looker.look(32)



# get query id for look

my_query = looker.query(my_look.query_id).to_attrs



# set new filters, here update the value for order_id

my_query[:filters] = {:"order_items.order_id" => "<567"}



# remove the client id!

my_query[:client_id] = {}



# create a new query

my_new_query = looker.create_query(my_query)

puts "New Query ID: " + my_new_query[:id].to_s



# update look with new query

my_look = looker.update_look(32, :query_id => my_new_query[:id])

puts "Updated Look Query ID: " + my_look[:query_id].to_s





if my_new_query[:id] == my_look[:query_id]

puts "Success!"

else

puts "Fail again, fail better"

end

This content is subject to limited support.