How To Create A RESTful JSON API Using Google Sheets As Database

Progression Page is a tool that helps people track and visualize their daily progress in learning to code, so in the spirit of helping others learn, I decided to share this tutorial to inspire others to create mini-applications using Google Sheets as their database.

How to Create a RESTful JSON API using Google Sheets as Database

Download Zip: https://distlittblacem.blogspot.com/?l=2tOLV6

In the tutorial, you learned how to create a new Laravel application backed by Firebase using the Kieait package. The application was able to access a host of Firebase's amazing services, in particular a real-time database. If you want a full codebase, you can fork the Github repository and customise it to suit your needs.

Sheetsu is a platform for both developers and non-developers. Some of the features can be used by anyone without coding experience and some advanced features like JSON API can be used by developers to convert google sheets as a database.

Libraries make much use of spreadsheets. Spreadsheets are easy to create, and most library staff are familiar with how to use them. But they can quickly get unwieldy as more and more data are entered. The more rows and columns a spreadsheet has, the more difficult it is to browse and quickly identify specific information. Creating a searchable web application with a database at the back-end is a good solution since it will let users to quickly perform a custom search and filter out unnecessary information. But due to the staff time and expertise it requires, creating a full-fledged searchable web database application is not always a feasible option at many libraries.

A free version of Google spreadsheet has a limit in size and complexity. For example, one free Google spreadsheet can have no more than 400, 000 total cells. But you can purchase more Google Drive storage and also query multiple Google spreadsheets (or even your own custom databases) by using Google Visualization API Query Language and Google Chart Libraries together. (This will be the topic of my next post. You can also see the examples of using Google Chart Libraries and Google Visualization API Query Language together in my presentation slides at the end of this post.)

Analytics Extensions Settings Methods Add analytics extension connection to site Adds an analytics extensions connection for an external service to a site. Delete analytics extension connection from site Deletes a specific analytics extension connection for an external service from a site. Enable or disable analytics extensions on server - Not available for Tableau Cloud Enables or disables analytics extensions on a server. Get analytics extension details Get the details of a specified analytics extension connection to an external service. Get current analytics extension for workbook Gets basic details, including connection type and name, of the analytics extension connection to an external service that the specified workbook is currently using. Get enabled state of analytics extensions on server - Not available for Tableau Cloud Gets the enabled/disabled state of analytics extensions on a server. Get enabled state of analytics extensions on site Gets the enabled/disabled state of analytics extensions on a site. List analytics extension connections of workbook Lists basic details of each analytics extension connection available for a specified workbook, including connection type and name. List analytics extension connections on site Lists a site's analytics extension connections for external services. Remove current analytics extension connection for workbook Remove the currently used analytics extension connection to an external service from the specified workbook. Update analytics extension connection of site Updates the details of specified analytics extension connection for an external service to a site. Update analytics extension for workbook Updates the analytics extension connection to external service currently used by a workbook. Update enabled state of analytics extensions on site Enables or disables analytics extensions on a site. Ask Data Lens Methods Create ask data lens Create an ask data lens. Delete ask data lens Delete an ask data lens. Get ask data lens Get the details of the specified ask data lens. Import ask data lens Import an existing ask data lens on a server to a site, and optionally transform the metadata of the lens in the process. List ask data lenses in site Returns a list of ask data lenses in a site. Authentication Methods Revoke Administrator Personal Access Tokens - Not available for Tableau Cloud. Revokes all personal access tokens(Link opens in a new window) (PATs) created by server administrators. Sign In Signs you in as a user on the specified site on Tableau Server or Tableau Cloud. Sign Out Signs you out of the current session. Switch Site - Not available for Tableau Cloud. Switches you onto another site without having to provide a user name and password again. Connected App Methods Create Connected App Create a connected app. Create Connected App Secret Generate a secret for a connected app. Delete Connected App Permanently remove a connected app. Delete Connected App Secret Permanently remove a secret associated with a connected app. Delete EAS - This method is not available for Tableau Server. Delete a registered external authorization server (EAS). Get Connected App Query a connected app by its ID. Get Connected App Secret Query a connected app secret and the token value using the connected app's ID. List All Registered EAS - This method is not available for Tableau Server. Query all external authorization servers (EASs) registered to a site. List Connected Apps Query all connected apps configured on a site. List Registered EAS - This method is not available for Tableau Server. Query an external authorization server (EAS) registered to a site. Register EAS - This method is not available for Tableau Server. Register an external authorization server (EAS) to a site. Update Connected App Update a connected app. Update EAS - This method is not available for Tableau Server. Update a registered external authorization server (EAS). Content Exploration Methods Get batch content usage statistics - Not available for Tableau Server Gets usage statistics for multiple content items. Get content search results Searches across all supported content types for objects relevant to the search expression specified in the querystring of the request URI. Get usage statistics for content item - Not available for Tableau Server Gets the usage statistics for a Tableau content item, specified by LUID and content type, such as workbook, datasource, or flow. Dashboard Extensions Settings Methods Allow dashboard extension on site Adds a dashboard extension to the safe list of the site you are signed into. Block dashboard extension on server - Not available for Tableau Cloud Adds a dashboard extension to the block list of a server. Disallow dashboard extension on site Deletes a specific dashboard extension from the safe list of the site you are signed into. Get allowed dashboard extension on site Gets the details of a specific dashboard extension on the safe list of the site you are signed into. Get blocked dashboard extension on server - Not available for Tableau Cloud Gets the details of a specific dashboard extension on the blocked list of a server. List allowed dashboard extensions on site Lists the dashboard extensions on the safe list of the site you are signed into. List blocked dashboard extensions on server - Not available for Tableau Cloud Lists the dashboard extensions on the blocked list of a server. List dashboard extension settings of site Lists the dashboard extension settings of the site you are signed into. List settings for dashboard extensions on server - Not available for Tableau Cloud Lists the dashboard extension settings of a server. Unblock dashboard extension on server - Not available for Tableau Cloud Deletes a specific extension from the block list of a server. Update dashboard extension settings of site Updates the settings for dashboard extensions for the site you are signed into. Update dashboard extensions settings of server - Not available for Tableau Cloud Updates the settings for dashboard extensions of a server Update settings for allowed dashboard extension on site Updates the settings of a specific dashboard extension in the safe list of the site you are signed into. Data Sources Methods Add Tags to Data Source Adds one or more tags to the specified data source. Delete Data Source Deletes the specified data source from a site. Delete Tag from Data Source Deletes a tag from the specified data source. Download Data Source Downloads a data source in .tdsx format. Download Data Source Revision Downloads a specific version of a data source prior to the current one in .tdsx format. Get Data Source Revisions Returns a list of revision information (history) for the specified data source. Publish Data Source Publishes a data source on the specified site, or appends data to an existing data source. Query Data Source Returns information about the specified data source. Query Data Source Connections Returns a list of data connections for the specified data source. Query Data Sources Returns a list of published data sources on the specified site, with optional parameters for specifying the paging of large results.To get a list of data sources embedded in a workbook, use the Query Workbook Connections method. Remove Data Source Revision Removes a specific version of a data source from the specified site. Update Data in Hyper Connection Incrementally updates data (insert, update, upsert, replace and delete) in a published data source from alive-to-Hyper connection, where the data source has multiple connections. Update Data in Hyper Data Source Incrementally updates data (insert, update, upsert, replace and delete) in a published data source from alive-to-Hyper connection, where the data source has a single connection. Update Data Source Updates the owner, project or certification status of the specified data source. Update Data Source Connection Updates the server address, port, username, or password for the specified data source connection. Update Data Source Now Runs an extract refresh on the specified data source. Extract and Encryption Methods Create an Extract for a Data Source Create an extract for a data source in a site. Create Extracts for Embedded Data Sources in a Workbook Create extracts for all embedded data sources of a workbook. Decrypt Extracts in a Site Extract encryption at rest is a data security feature that allows you to encrypt .hyper extracts while they are stored on Tableau Server. Delete Extract Refresh Task Deletes an extract refresh task. Delete Extracts of Embedded Data Sources from a Workbook Delete all extracts of embedded data sources in a workbook. Delete the Extract from a Data Source Delete the extract of a data source in a site. Encrypt Extracts in a Site Extract encryption at rest is a data security feature that allows you to encrypt .hyper extracts while they are stored on Tableau Server. Reencrypt Extracts in a Site Extract encryption at rest is a data security feature that allows you to encrypt .hyper extracts while they are stored on Tableau Server. Favorites Methods Add Data Source to Favorites Adds the specified data source to the user's favorites. Add Flow to Favorites Adds the specified flow to the user's favorites. Add Metric to Favorites Adds the specified metric to the user's favorites. Add Project to Favorites Adds the specified project to a user's favorites. Add View to Favorites Adds the specified view to a user's favorites. Add Workbook to Favorites Adds the specified workbook to a user's favorites. Delete Data Source from Favorites Deletes the specified data source from the user's favorites. Delete Flow from Favorites Deletes the specified flow from the user's favorites. Delete Project from Favorites Deletes the specified project from the user's favorites. Delete View from Favorites Deletes the specified view from user's favorites. Delete Workbook from Favorites Deletes a workbook from a user's favorites. Get Favorites for User Returns a list of favorite projects, data sources, views, workbooks, and flows for a user. Organize Favorites Move an item to organize a user's favorites. Flow Methods Add Flow Permissions Adds permissions to the specified flow for a Tableau Server user or group. Add Flow Task to Schedule Adds a task to run a flow to an existing schedule. Cancel Flow Run Cancels a flow run that is in progress. Delete Flow Deletes a flow. Delete Flow Permission Deletes the specified permission from the specified flow for a group or user. Download Flow Downloads a flow in .tfl or .tflx format. Get Flow Run Gets a flow run. Get Flow Run Task Returns information about the specified flow run task. Get Flow Run