17

I'm trying to automate a workflow using Google Data Studio. Requirements are simple - I need to be able to programatically copy a templated report (from a Python/Java application) and import/set a data source (Google Sheets doc) for that report. Nothing more fancy (no visualisation creation, formatting, or anything graphical, etc.).

Sources here, here and here (last two require Google Cloud Console account) suggest an API does exist (and detail a setup process to access it). However, after going through this setup process, I can find no details or documentation of any functionality, and consequently have been unable to progress.

Can anyone authoritatively state whether:

1. There does exist any API functionality for GDS? and

2. If not, are there plans to develop such? (since the Google links above suggest there is, I'm wondering if this means it's in the pipeline for near future).

The only directly related SO posts I can find are here and here. The first suggests there isn't, but doesn't account for the Google links I've provided above which suggest there is; the second doesn't really cover the same use case, so doesn't provide answers applicable here.

FYI - I've posted a Google Community forum post here asking essentially the same question.

If anyone is able to help out, that would be greatly appreciated :) Many thanks in advance for your time and help! :)

J-C
  • 173
  • 1
  • 5

1 Answers1

13

Fresh as of 2022-05-23

  1. There does exist any API functionality for GDS?

    • Not in the way you are expecting. The three links you posted all refer to the current Data Studio API. The only things you can do with that API is view your Data Studio assets and update permissions. That's it. This API won't let you create/copy/modify reports or data sources.

  2. If not, are there plans to develop such?

    • Not in the near future. You can make/vote for this feature request in the official tracker. More popular feature requests are usually prioritized in roadmaps.

That being said, a lot of the API use cases can be resolved using combinations of Community Connectors, config parameters, direct linking, viewer's credentials, Linking/Integration API etc.

Minhaz Kazi
  • 3,115
  • 1
  • 10
  • 20
  • Are programmatic interfaces available for managing the assets & permissions? If yes then could you please show me the path forward. – AKs Jul 27 '21 at 14:23
  • [This](https://developers.google.com/datastudio/api/reference) is all that is available right now. – Minhaz Kazi Jul 27 '21 at 19:25
  • 1
    Thanks for the detailed response @MinhazKazi. I have a use case where I am hoping to do exactly what this question describes. My goal is to programmatically create a data studio report from a template and add a data source (google sheet) to that new report (all from python). Can you please confirm this is still not possible? Also, from reading the links you provide, it seems this use is also outside the scope of what community connectors, config parameters, direct linking and viewer credentials can do, does this sound correct to you? Thanks again for the helpful answer you provided! – Braden Anderson May 13 '22 at 02:08
  • 1
    You still can't programmatically create a new report from a template. But the new Linking/Integration API might be helpful here. It lets you dynamically define a data source for a report. See details here: https://developers.google.com/datastudio/share/linking-api – Minhaz Kazi May 23 '22 at 22:10