The Movie Database 支持

Hi there, I'm trying to import specific TMDB data into my Google Sheet. I've installed a JSON importer via the script editor and have confirmed it is running properly. My question: Is there a way for me to pull a specific credit/name from the JSON file into a cell in Google Sheets.

Example of what I'm looking to do.

FROM:

 "crew": [
      {
        "credit_id": "57458f48c3a368697e001153",
        "department": "Directing",
        "gender": 2,
        "id": 5655,
        "job": "Director",
        "name": "Wes Anderson",
        "profile_path": "/s03CeUeC5yAXyB1acqP0zGNo2SC.jpg"
      },

TO: "Wes Anderson" in just a single cell in Google.

Please let me know what I can clarify here to help resolve. Thank you.

1 回复(第 1 页,共 1 页)

Jump to last post

Hi @andyshapiro, I'm sure this is possible but I've never used Google Sheets with the JSON importer before. Maybe you'd have better luck asking over at Stack Overflow?

找不到电影或剧集?登录并创建它吧。

全站通用

s 聚焦到搜索栏
p 打开个人资料菜单
esc 关闭打开的窗口
? 打开键盘快捷键窗口

在媒体页面

b 返回(或返回上级)
e 进入编辑页面

在电视季页面

(右箭头)下一季
(左箭头)前一季

在电视集页面

(右箭头)下一集
(左箭头)前一集

在所有图像页面

a 打开添加图片窗口

在所有编辑页面

t 打开翻译选择器
ctrl+ s 提交

在讨论页面

n 创建新讨论
w 切换关注状态
p 设为公开 / 私密讨论
c 关闭 / 开放讨论
a 打开活动页
r 回复讨论
l 跳转至最新回复
ctrl+ enter 发送信息
(右箭头)下一页
(左箭头)前一页

设置

想给这个条目评分或将其添加到片单中?

登录

还不是会员?

注册加入社区