Backend: Add routes-f CSV upload endpoint

[davedumto]

Summary

Add a Routes-F CSV upload endpoint with validation.

Requirements

• POST /api/routes-f/upload accepts CSV file.
• Validate required columns.
• Return parsed row count and errors.

Notes

• Parsing can be done in-memory.

Acceptance Criteria

• Invalid CSV returns 422 with errors.
• Tests cover valid and invalid CSVs.

[drips-wave]

This issue has been added to the Stellar Wave Program and is worth 200 Points.

🧑‍💻 Interested in contributing? Apply to work on this issue on Drips Wave, earn points, and receive rewards.

Warning

Only applications submitted via the apply link above will be considered. Please do not apply by commenting on the issue or opening a PR directly.

🤠 Repo maintainers: You can manage this issue's Points and Complexity on your Maintainer Dashboard here. Please keep an eye on applications and respond quickly 💙

ℹ️ Learn more about Drips Wave

[steph-crown]

@steph-crown has applied to work on this issue as part of the Stellar Wave Program's 2nd wave.

I am a Senior Software Engineer with over 5 years of experience building secure financial platforms. I specialize in backend systems and data ingestion pipelines, with significant experience developing in both TypeScript and Rust.

I can implement the routes-f CSV upload endpoint by building a Next.js API route that uses csv-parse for in-memory processing. I plan to use Zod to define the required column schema, which will allow the endpoint to return a structured 422 error response containing the specific row and column failures if the validation fails. I will also provide a comprehensive test suite covering valid CSVs and various edge cases like missing headers or malformed data types.

Relevant Experience:

• Financial Data Ingestion: Led the development of core modules in a corebanking project that required strict validation of high-volume financial data.

• Fullstack TypeScript: Extensive experience building and securing Node.js/Next.js API routes with schema-based validation.

Systems Engineering: Developed a custom shell (àṣẹ) in Rust, providing a meticulous approach to data parsing and resource management.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @steph-crown to this issue.

[NueloSE]

@NueloSE has applied to work on this issue as part of the Stellar Wave Program's 2nd wave.

I can help you resolve the following task kindly assign me

ℹ️ Repo Maintainers: To accept this application, review their application or assign @NueloSE to this issue.

[EbukaMoses]

@EbukaMoses has applied to work on this issue as part of the Stellar Wave Program's 2nd wave.

Hello Maintainer,

I’d like to apply to work on this issue.

I’m Ebuka Moses, a full-stack and blockchain developer with experience building, testing, and maintaining smart contracts, particularly using Rust and blockchain-based architectures. I’m comfortable working with contract logic, validation, access control, persistent storage, and event handling, and I always pay close attention to correctness, security, and edge cases.

I take time to fully understand the issue requirements before implementing a solution, and I ensure my work follows the project’s coding standards. I also write clear, well-tested code and submit clean pull requests with meaningful commits.

I’m confident I can deliver a solid solution that meets the acceptance criteria and adds value to the project.

Thank you for your consideration, and I look forward to contributing.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @EbukaMoses to this issue.

[okekefrancis112]

@okekefrancis112 has applied to work on this issue as part of the Stellar Wave Program's 2nd wave.

Hi, I would like to apply to this issue. I’m a full-stack smart contract and backend engineer with experience building and integrating production systems across web2 and web3. I work with NestJS, Node.js, TypeScript, and SQL/NoSQL databases to design clean, scalable APIs, and I’ve also built and integrated smart contracts, including working with Soroban on Stellar to manage contract state, construct transactions, and connect on-chain logic with backend services. I’m comfortable navigating existing codebases, following established project patterns, and contributing well-documented, testable changes that are easy to review and maintain in an open source environment.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @okekefrancis112 to this issue.

[Robinsonchiziterem]

@Robinsonchiziterem has applied to work on this issue as part of the Stellar Wave Program's 2nd wave.

Hi, please can i work on this?

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Robinsonchiziterem to this issue.

[0xVida]

@0xVida has applied to work on this issue as part of the Stellar Wave Program's 2nd wave.

I can implement the Routes-F CSV upload endpoint with proper validation and clear error handling.

I would:
• Create a POST /api/routes-f/upload endpoint that accepts a CSV file and parses it in memory.
• Validate required columns and return structured validation errors when the format is incorrect.
• Return the total parsed row count along with any row-level issues.
• Ensure invalid CSVs return 422 with clear error details.
• Add tests covering both valid and invalid CSV scenarios.

I’ve built file upload and validation endpoints before, so I’ll keep the implementation lightweight, reliable, and easy to extend.

ETA: 4–6 hours.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @0xVida to this issue.

[blessme247]

@blessme247 has applied to work on this issue as part of the Stellar Wave Program's 2nd wave.

I would like to solve this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @blessme247 to this issue.

[BigJohn-dev]

@BigJohn-dev has applied to work on this issue as part of the Stellar Wave Program's 2nd wave.

This issue appeals to me because it combines the challenge of solving complex frontend performance problems with the opportunity to deliver a smoother, more reliable user experience, while also sharpening my skills with emerging design and resolution patterns.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @BigJohn-dev to this issue.