无法使用Looker API将Looker图表(视图)拉入Databricks

Question

我的目标是访问我存储在Looker文件夹中的视图或图表，并自动将它们添加到power point幻灯片中。我正在学习的教程是这个：https://discourse.looker.com/t/generating-a-powerpoint-presentation-from-all-looks-in-a-space/8191。

我的问题是#生成PowerPoint (根据教程)。当我运行该命令时，失败消息指出：

    103 chart_test
    Look failed 103: chart_test
    Failed to add image to slide

This corresponds to this piece of code where it fails:

try:
    image = looker_client.LookApi(client).run_look(**look_request)
    image_file = ''.join([str(look.id), '.png'])
    shutil.move(image, image_file)
except:
    print(f'Look failed {look.id}: {look.title}')
    image_file = None

当我打印'image_file‘时，是空的('None')，尽管我在这个名为' chart _test’的文件夹2703中保存了一个折线图。

有人能帮帮忙吗？

Answer 1

检查参数示例

look_request = {
            "look_id": 21, 
            "result_format": 'png', 
            "image_width": 960, 
            "image_height": 540
        } 

尝试使用上一个sdk

import looker_sdk
import shutil 
from looker_sdk import models
sdk = looker_sdk.init40("looker.ini")
look_request = {
            "look_id": 21, 
            "result_format": 'html', 
            "image_width": 960, 
            "image_height": 540
        }

try:
    image1 = sdk.run_look(**look_request)
    image_file1 = '21.png'
    shutil.move(image1, image_file1)
except Exception as e:
    print(e)

您应该在py文件所在的文件夹中创建一个looker.ini文件。