Angular app with Google Docs API reporting
Ben Thomas
Like this project
Posted Jan 9, 2024
Build an Angular app for inputting data. Build a .NET web API for storing data and outputting a Google Doc report via the API.
The project and database already existed as an incomplete Windows desktop app.
I created an Angular front end, working alongside a designer to use the material design UI elements to match the company's style.
The client also did some development and was looking to get into Angular. By providing them with the source code and documentation at the end of the project they could modify the project as they saw fit.
The data collected by the app was then used to write a Google doc per the client's template. Using the Google Docs API made it possible to create data-driven reports on demand.
Angular front end
Using material design an angular front end with a tab view control was created. This replicated the existing Windows form-based application but for the browser.
.NET Web API back end
A .NET web API was created to allow CRUD operations on the database. This could then be called from the TypeScript code.
SQLite database
The client wanted to keep the existing data store to run the app locally.
Google Docs API
The .NET library for Google Docs API was used to write out the sections of the documents in the correct order. This created a database-driven report with headings, images, and a table of contents.