We need an API developer to take API calls from a web based learning provider and create or store it in our hosted MySQL database or create a middleware solution to dump the information. From the MySQL database or Middleware solution, create flat files according to a provided specifications document. The flat files must then be sent daily to a secure SFTP site. The solution must be tested and documented thoroughly.
There is two files attached to this project. The first being the Rest API where the information will be exposed. We need this information to be processed into the required template and fields in the spreadsheet attached, and a flat file generated that will be sent automatically via the solution to a pre-determined SFTP server provided.