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...
❤️ Support the ongoing growth of this channel, get exclusive perks, and receive consultation on your projects! / davidweissprogramming
🧑💻 Apps Script Documentation: https://developers.google.com/apps-sc...
----------------------------------------------------------------------------------------------
🕒 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:
• Google Cloud - Season 1 | App Engine
Google Cloud Orientation:
• Google Cloud - Season 0 | Orientation
-------------------------------------
Apps Script
-------------------------------------
Data Studio Service:
• Apps Script - Season 15 | Data Studio...
Maps Service:
• Apps Script - Season 14 | Maps Service
Utilities Service:
• Apps Script - Season 13 | Utilities S...
Properties Service:
• Apps Script - Season 12 | Properties ...
URL Fetch Service:
• Apps Script - Season 11 | URL Fetch S...
Drive Service:
• Apps Script - Season 10 | Drive Service
Forms Service:
• Apps Script - Season 9 | Forms Service
Lock Service:
• Apps Script - Season 8 | Lock Service
HTML Service:
• Apps Script - Season 7 | HTML Service
Document Service:
• Apps Script - Season 6 | Document Ser...
Slides Service:
• Apps Script - Season 5 | Slides Service
Calendar Service:
• Apps Script - Season 4 | Calendar Ser...
Script Service:
• Apps Script - Season 3 | Script Service
Gmail Service:
• Apps Script - Season 2 | Gmail Service
Spreadsheet Service:
• Apps Script - Season 1 | Spreadsheet ...
Apps Script Orientation:
• Apps Script - Season 0 | Orientation
----------------------------------------------------------------------------------------------