Excel API as a Service. In the experiment we'll use one Excel file (APIOps members list) which is sources folder (members.xslx).
Below is rough sketch about the toolchain needed. At this point I decided not to go with CKAN, which supports something similar. Installing and running CKAN is not as fruitful for learning than trying to build the process. In addition CKAN (afaik) does not support deployment of API.
It is decided that we'll use available software to build the tool chain with the aim not to code anything. We use just CLI tools and run the process in Debian server.
- https://stedolan.github.io/jq/download/ (manually downloaded and copied to local/bin)
- json-server
- csv-to-json
- npm
- pip
- csvtoolkit (python)
To get JSON from CSV file
~/.local/bin/csv-to-json <members.csv | ~/.local/bin/jq '{ members: . }' > db.json
We needed to add jq in the middle to make JSON acceptable for json-server
Install and run JSON server
sudo npm install -g json-server; json-server --watch db.json
After tools have been installed
python ~/.local/bin/in2csv sources/members.xlsx > sources/members.csv; ~/.local/bin/csv-to-json < sources/members.csv | ~/.local/bin/jq '{ members: . }' > db.json; json-server --watch db.json
