Simple web-based tool to look up Fate Grand/Order crowd-sourced dropsheet data.
Dropsheet is here: https://docs.google.com/spreadsheets/d/1_SlTjrVRTgHgfS7sRqx4CeJMqlz687HdSlYqiW-JvQA/edit#gid=843570146
This is a frontend for the Google Sheets API. Documentation can be found here: https://developers.google.com/sheets/api
To use this tool, first obtain an API key: https://console.developers.google.com/apis/credentials?pli=1
Create a file named apiKey.js, and add this line of code: export const apiKey = "{your api key here}";. Save the file.
As of 5/2/2020, the Sheets API has a limit of 500 requests per 100 seconds.
Once the apiKey.js file is created:
- Build project: yarn build
- Run project locally: yarn serve
There are two files that provide the source of truth for the API: sheets.js and mats.js.
sheets.js provides the list of sheets with the ID and URL-encoded name of the sheet itself. Note that the API does not actually use the ID.
mats.js is a list of mats in Fate Grand Order, a starting cell (startRange), an ending cell (endRange), a rarity, and a type. The last two are used for filtering. You must ensure startRange and endRange correspond to the sheet, or this tool will not work.