Skip to content

PowerShell RESTful API to read and write Spreadsheets to GitHub repos

License

Notifications You must be signed in to change notification settings

agentidea/katagraphos-api

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

62 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Katagraphos - Store records with Excel Spreadsheets in GitHub

Katagraphos is a PowerShell RESTful API microservice that facilitates writes and reads of Excel spreadsheets which are then stored in GitHub.

Excel was chosen as a primary file format to store textual records as it is useful for:

  1. Tabular data (lists, tables ... )
  2. Built in Authenticaion ( Optional Password protection )
  3. Graph Visulizations
  4. Pivot tables
  5. Numerous other Excel features such as ...?

GitHub as a datastore was chosen as it has the following properties:

  1. Secure and Availible
  2. Private or Public visibility
  3. Version control
  4. Free
  5. Permanent
  6. Owned and backed by Microsoft

Under the hood

This API is made possible by leveraging the following OpenSource PowerShell Modules

  1. ImportExcel, authored by Douglas Finke
  2. PSAdvantage, authored by Douglas Finke
  3. Pode, authored by Matthew Kelly (aka Badgerati)

etc

Why on earth was this named Katagraphos?

Read all about it here













Draft if a ever presentation

blah blah blah brocure ware here

What you will learn

  1. How to create, update and read records in Excel spreadsheets, using the ImportExcel PowerShell module.

  2. Use Microsoft Excel password protection feature to secure your records.

  3. How to save and retrieve records using the PowerShell module, PSAdvantage to and from a GitHub repository.

  4. Use the PowerShell Pode Module to create a RESTful API

  5. How to manage your data by following along a demo using a simple webfront end (tbd - REACT ...)

About

PowerShell RESTful API to read and write Spreadsheets to GitHub repos

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published