-
Notifications
You must be signed in to change notification settings - Fork 187
/
update_look.rb
35 lines (26 loc) · 891 Bytes
/
update_look.rb
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
require 'looker-sdk'
# get API creds from environment variables
sdk = LookerSDK::Client.new(
:client_id => ENV['LOOKERSDK_CLIENT_ID'],
:client_secret => ENV['LOOKERSDK_CLIENT_SECRET'],
:api_endpoint => ENV['LOOKERSDK_BASE_URL']
)
# get look, here look id 32
my_look = sdk.look(32)
# get query id for look
my_query = sdk.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 = sdk.create_query(my_query)
puts "New Query ID: " + my_new_query[:id].to_s
# update look with new query
my_look = sdk.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