Solve the problem below and write back to us with your solution repo and link to the deployed app raghav [at] rorodata [dot] com More details on the position
Build a webapp for data upload using the Dropbox API. The suggested technologies are Flask + Jinja templates + Bootstrap CSS.
The user should be able to do the following
- Upload csv files in dropbox folder. The server polls dropbox for any new file uploaded.
- View the file data as a table (with pagination) in a web browser
- View the history of all the files uploaded to the app
- View record of errors in file upload. Error-type Supported: mis-match of columns i.e if the columns files do not match then upload is rejected
Note:
- Data from new files is appended to the existing data. The appended data can be stored in S3/CloudStore
- File format is here
The webapp should contain the following pages.
This page should show the data in tabular form with pagination
This page will have table of all files pulled from dropbox and appended to the base data
For simplicity support on one type of file error tracking - mis-match of columns
- Deployed webapp - we recommend digital ocean or heroku but you can choose any platform
- Unit tests
- Code repo