Middleware for Excel to FTP Transfer

Job ID: 38230970

Budget: $30 – $250 USD

I need a custom middleware that can receive Excel files via an API, extract specific fields (name, date, quantity, product), convert them into a tab-delimited text format, and drop the file into a vendor's FTP. It should then receive back confirmation from the vendor and send this confirmation back to through the API.

The middleware should also handle errors during the file extraction process. If an error occurs, it should immediately stop the execution and notify me. This is crucial for me to ensure timely resolution of any issues.

Key Requirements:
- Receive Excel files via an API
- Extract specific fields: Name, Date, Quantity, Product
- Convert extracted fields into Tab-delimited text format
- Transfer the text file to a vendor's FTP location
- Receive and forward confirmation from the vendor through the API
- Handle errors by stopping execution and notifying the client

Ideal Skills:
- Experience with middleware development
- Proficiency in working with Excel files and extracting data
- Familiarity with API integration
- Strong understanding of FTP protocols
- Ability to handle error handling effectively
- Effective communication for client notifications.
Related categories: PHP XML Visual Basic Excel Software Architecture