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

[@AlexUnderCMYK]

Worked perfectly, thanks Dimitris!

[@DimitrisPaxinos]

I am glad it works well Alex!

[@daniellyra9199]

Thanks a lot! I have a similar project coming up and I'm sure what I have learned here will come in handy. If I can give you some feedback, next time zoom-in more, it's very difficult to read the code

[@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!!!

[@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.

[@luminoire2554]

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

[@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 🙏

[@VarshaC-v7j]

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.

[@NagurBabuShaik-e2w]

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

[@Viewer-it2pz]

Does this method works same as Row level data security?

[@AnalyticsMadeSimpler]

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

[@AdminDev-fy4wu]

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?

[@DimitrisPaxinos]

Hey, can you please copy the code from here and try again? github.com/dimitrispaxinos/looker-studio-rest-api-connector/blob/main/looker-studio-connector.js

[@ferrarilasko8213]

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

[@MantoArnithenou]

Congrats 🎉

[@HarshadPednekar-h5e]

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.

[@HarshadPednekar-h5e]

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]

​@@HarshadPednekar-h5e 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.

[@HarshadPednekar-h5e]

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.

[@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.

[@marcelobrigato]

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