def submit(): looker = LookerApi(client_id, client_secret, api_endpoint) c = looker.get_look(528) channel_list = [d['channel_dimensions.organization'] for d in c] market_list = get_markets_list(looker) subtype_list = get_channel_subtype_list(looker) return render_template('submit.html', channel_list=channel_list, market_list=market_list, subtype_list=subtype_list)
def generate_rows(self, dataset_schema=None, dataset_partitioning=None, partition_id=None, records_limit=-1): looker = LookerApi(host=self.baseurl, token=self.clientid, secret=self.clientsecret) data = looker.get_look(self.lookid, "json", limit=5000) for row in data: yield row #print(data) ### ------- Done ------- #print("Done") """
### ------- HERE ARE PARAMETERS TO CONFIGURE ------- look_to_get = sys.argv[1] host = 'localhost' ### ------- OPEN THE CONFIG FILE and INSTANTIATE API ------- f = open('config.yml') params = yaml.load(f) f.close() my_host = params['hosts'][host]['host'] my_secret = params['hosts'][host]['secret'] my_token = params['hosts'][host]['token'] looker = LookerApi(host=my_host, token=my_token, secret = my_secret) ### ------- GET AND PRINT THE LOOK ------- data = looker.get_look(look_to_get) pprint(data) ### ------- Done ------- print "Done"
### ------- HERE ARE PARAMETERS TO CONFIGURE ------- look_to_get = 123 host = 'localhost' ### ------- OPEN THE CONFIG FILE and INSTANTIATE API ------- f = open('config.yml') params = yaml.load(f) f.close() my_host = params['hosts'][host]['host'] my_secret = params['hosts'][host]['secret'] my_token = params['hosts'][host]['token'] looker = LookerApi(host=my_host, token=my_token, secret = my_secret) ### ------- GET AND PRINT THE LOOK ------- data = looker.get_look() pprint(data) ### ------- Done ------- print "Done"
my_host = params['hosts'][host]['host'] my_secret = params['hosts'][host]['secret'] my_token = params['hosts'][host]['token'] looker = LookerApi(host=my_host, token=my_token, secret=my_secret) # These Look IDs should be updated to match the Look ID of # whatever the new reports will be. author_report = 157 task_report = 158 # get emails from a Look(157) (Author Report) print "Getting Look information" emails = looker.get_look(author_report) email_list = [] for email in emails: for key, value in email.iteritems(): email_list.append(value) print "Getting Schedule information from Look" # get look plan ID from a Look(158). look_plan_id = looker.get_look_schedule(task_report)[0]['id'] # Pass those emails into an update_schedule call using the above look_plan_id into below plan # Loop through the email list, appending to and creating and concatenating the string to be used for the # body of the API call in json form i = 1 list_of_schedule_plan_destinations = ''