Data Studio
1.6K members online now
1.6K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

REST API Data Source?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I am trying to play with Data Studio, but all data sources are irrelevant to my usage, I can use webservices (for really old weird sources) and rest apis (returning json). Is there a way to use them in Data Studio to create some dashboard comparing e.g. data returned from Analytics with data from our own services?

1 Expert replyverified_user

REST API Data Source?

Top Contributor
# 2
Top Contributor

Your best best is to use Google Sheets to pull data from a REST URL, format the result and use that as a data source in DS

VP & Chief Evangelist at Hub'Scan | Contact me
Level 80 Digital Analytics Warrior, KPI Therapist and Keeper of the One True Tagging Plan

REST API Data Source?

Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭
But it is not automatically! who will feed the Google Sheets?  

REST API Data Source?

Top Contributor
# 4
Top Contributor

You know how Google sheets work right? You can automate API scripts.

VP & Chief Evangelist at Hub'Scan | Contact me
Level 80 Digital Analytics Warrior, KPI Therapist and Keeper of the One True Tagging Plan

REST API Data Source?

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

And can you send me script for the rest API in Google sheets?

 

Thank you

 

Petr

REST API Data Source?

Follower ✭ ☆ ☆
# 6
Follower ✭ ☆ ☆

We launched Community Connectors for Data Studio in September. Community Connectors let you directly pull in data from REST API without needing to go through Sheets. Links to the Get Started Guide for Community Connectors and also our GitHub repo for examples.

REST API Data Source?

Top Contributor
# 7
Top Contributor

Each API has its own methods. What kind of data did you want to connect to?

VP & Chief Evangelist at Hub'Scan | Contact me
Level 80 Digital Analytics Warrior, KPI Therapist and Keeper of the One True Tagging Plan

Re: REST API Data Source?

Visitor ✭ ✭ ✭
# 8
Visitor ✭ ✭ ✭
REST API

I know just this name. And in QLIKsense the name is same.

Thanks

Petr






Bez
virů. www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

REST API Data Source?

Visitor ✭ ✭ ✭
# 9
Visitor ✭ ✭ ✭

The example works Smiley Happy 

Tommorow i gonna try with airtable Smiley Happy

 

Thanks

REST API Data Source?

Visitor ✭ ✭ ✭
# 10
Visitor ✭ ✭ ✭

Hi, I wonder how we can connect Datastudio with Apsis through REST Api.  I have heard that it is possible to that without buy Funnel? Is it possible and how do we do it? Is it under "Developers"? Thank you.