最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

google sheets - SheetsChart refresh not working in "Slideshow" mode - Stack Overflow

programmeradmin2浏览0评论

I want to updated a liked SheetsChart for Google Slides. It works instantly when the slide is in edit mode, doesn't refresh the chart with latest data from Google Sheets when it's in "Slideshow" mode.

How can I refresh a Sheets Chart while in "Slideshow" mode?

Code

curl --request POST \
  '/[presentationId]:batchUpdate?key=[YOUR_API_KEY]' \
  --header 'Authorization: Bearer [YOUR_ACCESS_TOKEN]' \
  --header 'Accept: application/json' \
  --header 'Content-Type: application/json' \
  --data '{"requests":[{"refreshSheetsChart":{"objectId":"object Id that include a linked Sheets Chart"}}]}' \
  --compressed
Output
HTTP 200
{
  "presentationId": "presentationId",
  "replies": [
    {}
  ],
  "writeControl": {
    "requiredRevisionId": "<>"
  }
}

My use case is to update the Slide's SheetsChart in real-time with an external data source: When an external data source is updated -> use Google API to update Google Sheets and trigger to refresh linked SheetsChart in Slides.

When Slides in "edit" mode: it updates the linked chart instantly When Slides in "Slideshow" mode (or in presentation): it doesn't update the linked chart, exiting the "Slideshow" mode, the chart is updated. Is there an alternative way?

发布评论

评论列表(0)

  1. 暂无评论