The Depot API for TECTRA Ltd utilizes a LibreOffice ODS spreadsheet as the data storage backend of the inventory state and exposes the data therein through GET endpoints as JSON, XML and plaintext.
Additionally, the software utilizes an async file watcher on the spreadsheet, which reloads and re-parses the information therein upon file modification.
The Depot API utilizes htmx for live search across the numerous product item codes, and consumes the ProductItems API for requesting information such as the product family, manufacturer, brand, etc.