Displaying Data on the Dashboard - Apps Script | Data Studio Service ~ Episode 15.4 скачать в хорошем качестве

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 Service   Maps Service:    • Apps Script - Season 14 | Maps Service   Utilities Service:    • Apps Script - Season 13 | Utilities Service   Properties Service:    • Apps Script - Season 12 | Properties Service   URL Fetch Service:    • Apps Script - Season 11 | URL Fetch Service   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 Service   Slides Service:    • Apps Script - Season 5 | Slides Service   Calendar Service:    • Apps Script - Season 4 | Calendar Service   Script Service:    • Apps Script - Season 3 | Script Service   Gmail Service:    • Apps Script - Season 2 | Gmail Service   Spreadsheet Service:    • Apps Script - Season 1 | Spreadsheet Service   Apps Script Orientation:    • Apps Script - Season 0 | Orientation   ----------------------------------------------------------------------------------------------