smaabruket-availability-api

https://foreningenbs.no/smaabruket-availability-api/availability

https://foreningenbs.no/smaabruket-availability-api/availability?first=2018-01-01

Development

corepacke enable
pnpm install
# Using the test spreadsheet here.
export SPREADSHEET_ID='1RDCajU73u3TRhUv1M5DQchO_V7YgwTqdf5MZsMuIRfs'
pnpm serve

http://localhost:8000/availability

The SPREADSHEET_ID should point to the ID of the spreadsheet, which can be seen in the URL of the spreadsheet.

Spreadsheet used in tests

This is a spreadsheet made for the purpose of integration testing.

https://docs.google.com/spreadsheets/d/1RDCajU73u3TRhUv1M5DQchO_V7YgwTqdf5MZsMuIRfs/edit?usp=sharing

Credentials

A file credentials.json must exist in the working directory representing the JSON file for a Service Account. The spreadsheet must be shared with the email of this Service Account to grant it access.

This file is also required for running integration tests.

As of this writing we use the Service Account [email protected].

Named range in the spreadsheet

We retrieve data for the named range "Bookinger", which should cover the range from the header row (just before data) and all the data, and the columns as referenced in availability.ts.