- Modify the key pairs to the correct ones.
- Onetime run: setup() in google script in setup.gs.
- When user open google spreadsheet, the menu is setup automatically through OnOpen() function.
- User modify meta data in google spreadsheet.
- Click menu to call Get/Post/Patch functions, data is converted into JSON format, and then submit to http server implemented in PHP
- Http server filter the meta data according to schemas defined schemas.json, and submit the data to 4DN server.
- Http server receive the message from 4DN server, and send back to google spreadsheet
- We should use https instead of http protocol for the communication for http server.
- Support raw data submission using URL format.
- Support bz2 by converting bz2 to gz automatically.
- Discuss the machanism of how to control which fields to submit, comparing re-submitting all fields.