Displaying Data on the Dashboard - Apps Script | Data Studio Service ~ Episode 15.4

Hey Coders! Are you creating a custom Community Connector and trying to connect your Data Studio Report to a custom data source? After authenticating your users, setting the configuration, and defining the schema, there is just one thing left to do: get the data and display it on your dashboard! Every time users of your report request for data to fill their charts and graphs, the getData() function will be called. What is returned will be a data response object that specifies the schema of the data that's being sent back to Data Studio, and the actual data itself. This is the final step to building out a working community connector, and the last required step, so be sure to watch the entire video for the grand finale of our community connector! Check out the source code on GitHub: https://github.com/davidtheweiss/Apps-Script-Season-15-Data-Studio-Service ❤️ Support the ongoing growth of this channel, get exclusive perks, and receive consultation on your projects! https://www.patreon.com/DavidWeissProgramming 🧑‍💻 Apps Script Documentation: https://developers.google.com/apps-script/reference/data-studio ---------------------------------------------------------------------------------------------- 🕒 Timestamps 0:00 Intro 0:37 Overview and Problem Statement 1:46 Building The Data Response Object 4:31 Adding Data Row By Row to our Response Object 5:08 How to Add Date Data in your Community Connector 6:07 Filling out the Rest of the Data According to the Schema 9:00 Showcasing Data in the Data Studio Report for the First Time 10:40 Filtering out the Schema Based on the Request 14:19 Filtering out the Data Returned Based on the Request 18:44 Resolution and Testing out the Community Connector 19:41 Adding a Time Series to Display Cryptocurrency Prices 20:50 Adding Three Cryptocurrency Prices to the Same Line Graph 21:13 Filtering Data From the Data Studio Dashboard 22:04 Dang API Rate Limits! (Nomics Free API Key) ---------------------------------------------------------------------------------------------- Other playlists: ------------------------------------- Google Cloud ------------------------------------- App Engine: https://www.youtube.com/playlist?list=PL42xwJRIG3xCtmOrJAQFR5sIJFKIJ9MEn Google Cloud Orientation: https://www.youtube.com/playlist?list=PL42xwJRIG3xBGAOjrm9iZ3N5_eP_KRc34 ------------------------------------- Apps Script ------------------------------------- Data Studio Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xBM88UgT79HKxO_u0ze3BZL Maps Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xAXgY2FksYt-kbKuXNmSUMA Utilities Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xBnsGHi6fetv17uQ35NXm0S Properties Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xDBj4s5WwO7sYUyA3H06Bjs URL Fetch Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xDormBAHLcxorCYpHlHa_IE Drive Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xDbvnvgWOizjX6j1jYBn0zk Forms Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xBoKUA3zPkICMTAa_vu0QEl Lock Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xDBPhvVrQdRi2Hdy9kMeb90 HTML Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xAafvhn9eCubEdas3I2TrNh Document Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xBFGeUZCMubWlwrhUXDdaTA Slides Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xBknGu3JNdJqHCiPpaVxAuY Calendar Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xAqrGnc_o2NL4RH4jdyiHsp Script Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xDPE35v7e83rH7Uu4g_MfmC Gmail Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xA5pkm04CY_WVZ9lE1Ju_JH Spreadsheet Service: https://www.youtube.com/playlist?list=PL42xwJRIG3xBZFP5wYh-OFb-CQmjz-Rn- Apps Script Orientation: https://www.youtube.com/playlist?list=PL42xwJRIG3xCm6O85pd91tQxgxGcq82m4 ----------------------------------------------------------------------------------------------