Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Does Google Data Studio have API functionality, and if not, will it in the near future?

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! :)

like image 533
J-C Avatar asked Oct 08 '20 09:10

J-C


People also ask

Does Data Studio have an API?

The Data Studio API allows you to search for and manage Data Studio assets. The primary use case for the API is to allow Google Workspace or Cloud Identity organizations to automate management and migration of Data Studio assets.

Why is Google Data Studio not popular?

The analysis provided by Google Data Studio may not stand at par with the likes of other powerful BI tools such as Tableau and Power BI. While it can adequately visualise the data, it doesn't allow the slice and dice, and analysis of data as the other popular tools.

Can you automate Google Data Studio?

To set up Google Data Studio Automation, you can begin by connecting with your desired data source and then building your business reports. You can further make your reports insightful by adding multiple visualizations to it.


1 Answers

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.

like image 179
Minhaz Kazi Avatar answered Oct 05 '22 13:10

Minhaz Kazi