How to fetch JSON data from an API into Looker Studio (Google Data Studio)

In this video tutorial, we walk you through the process of bringing JSON data from an API into Looker Studio using a custom connector developed with Google Apps Script. Dive deep into the code's intricacies, understand each function's significance, and see the seamless integration in action.

Need help?
If you're looking for expert assistance with Google Apps Script projects or any custom solutions, contact us at Apptiva Software. We're here to help! 📩

0:00 Introduction
1:12 Overview of the API Data
2:20 Creating a new Google Apps Script Project for our Connector
2:46 Editing the Manifest File
4:16 Overview of the basic methods of a Connector
6:50 Walkthrough of the actual code implementation
8:59 Assigning a Google Cloud Project to our Project
10:18 Deploying our Connector
10:54 Visiting our published Connector's page
11:33 Connecting our Connector to Looker Studio
14:13 Working with our Connector in Looker Studio

[lpiueos]

Can we create a real-time dashboard in looker studio by accesing the data in in this way

[steverodriuguez]

One question, if I have several pages in this report, all working with the same data, how can I prevent looker to fetch the data again on page switching?, or even better, can I fetch based on the page we stand? Thanks for the content I think is really helpful!!!

[pablocappeL]

Thanks a lot for the video. Please, could you use zoom when you explain?

[ferrarilasko]

how can I get a valid Date data type in looker studio for a JSON data source?

[AnalyticsMadeSimpler]

Culd I use custom dates everytime I want to generate the report?

[Viewer-itpz]

Does this method works same as Row level data security?

[ibrahimalzoubi]

what to im facing Community Connector Error
There was an error caused by the community
connector. Please report the issue to the provider of
this community connector if this issue persists.
Connector details
There was an error caused by this connector.
Appreciate your kind assistance 🙏

[kuvqcyp]

what to im facing Community Connector Error

There was an error caused by the community connector. Please report the issue to the provider of this community connector if this issue persists.
Connector details

There was an error caused by this connector.

[luminoire]

I assume this community connector is gonng to be public ? can we make it private ?

[laghunaland]

how to do with Url and Rest API can share the tutorial ??, many thanks

[gvpkxfg]

How can I avoid using Google Cloud as I don't have it, can I connect to third party API (returning JSON) and load that data in Looker Studio?

[AdminDev-fywu]

Hello Dimitris

I'm getting this error

There was an error caused by the community connector. Please report the issue to the provider of this community connector if this issue persists.

Any solutions?

[marcelobrigato]

Very hard to see.... 90% of video is useless white window... Shame...