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

Поділитися
Вставка
  • Опубліковано 4 січ 2025

КОМЕНТАРІ •

  • @AlexUnderCMYK
    @AlexUnderCMYK 11 місяців тому +1

    Worked perfectly, thanks Dimitris!

  • @daniellyra9199
    @daniellyra9199 4 місяці тому

    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

  • @pablocappeL2
    @pablocappeL2 Рік тому +2

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

    • @DimitrisPaxinos
      @DimitrisPaxinos  Рік тому +4

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

  • @NagurBabuShaik-e2w
    @NagurBabuShaik-e2w Рік тому

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

  • @MantoArnithenou
    @MantoArnithenou Рік тому

    Congrats 🎉

  • @steverodriuguez
    @steverodriuguez 5 місяців тому

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

  • @Viewer-it2pz
    @Viewer-it2pz Рік тому

    Does this method works same as Row level data security?

  • @AnalyticsMadeSimpler
    @AnalyticsMadeSimpler 8 місяців тому

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

  • @ibrahimalzoubi4297
    @ibrahimalzoubi4297 11 місяців тому

    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
    @luminoire2554 10 місяців тому

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

  • @AdminDev-fy4wu
    @AdminDev-fy4wu 5 місяців тому

    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
      @DimitrisPaxinos  5 місяців тому

      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

  • @laghunaland8456
    @laghunaland8456 Рік тому

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

    • @DimitrisPaxinos
      @DimitrisPaxinos  Рік тому

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

  • @VarshaC-v7j
    @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.

  • @ferrarilasko8213
    @ferrarilasko8213 Рік тому

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

  • @HarshadPednekar-h5e
    @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
      @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
      @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
      @DimitrisPaxinos  Рік тому +1

      ​@@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
      @HarshadPednekar-h5e Рік тому

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

    • @DimitrisPaxinos
      @DimitrisPaxinos  Рік тому

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

  • @marcelobrigato
    @marcelobrigato 10 місяців тому

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