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! 📩
Please send us an email: [e-mail]
Code & Blog Post: apptivasoftware.com/blog/brin...
Our website: apptivasoftware.com
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

[@AlexUnderCMYK]

Worked perfectly, thanks Dimitris!

[@DimitrisPaxinos]

I am glad it works well Alex!

[@user-qi2xz5sf8e]

Congrats 🎉

[@user-lp1iu4eo5s]

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

[@pablocappeL2]

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

[@DimitrisPaxinos]

Thank you very much for your feedback! You are right, I will improve this in my next videos.

[@ferrarilasko8213]

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

[@Viewer-it2pz]

Does this method works same as Row level data security?

[@ibrahimalzoubi4297]

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 🙏

[@luminoire2554]

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

[@user-ku7vq4cy2p]

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.

[@laghunaland8456]

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

[@DimitrisPaxinos]

You can find the URL to the full tutorial in the video description below the video.

[@user-gv4pk8xf5g]

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?

[@DimitrisPaxinos]

Hi! This is exactly what this video is about, fetching data from an API returning JSON. Google Cloud is only used for setting up the connector.

[@user-gv4pk8xf5g]

Hey @@DimitrisPaxinos, thanks for quick reply man!!
Well I agree this is video is for same, but what if I don't have Google Cloud Account? still would I be able to setup connector?

[@DimitrisPaxinos]

​@@user-gv4pk8xf5g I see. Unfortunately, I cannot think of any other way around this.
Your best bet would be to talk with your (company's) Google Workspace administrator and set up a Google Cloud project for your connector.

[@user-gv4pk8xf5g]

Hey @DimitrisPaxinos - I was wondering if I can add data source from google drive link (of CSV) file in Looker Studio?

[@DimitrisPaxinos]

I think you need to upload the CSV file diretly within looker studio.

[@marcelobrigato]

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