
Concluído
Publicado
Pago na entrega
I already run several in-house APIs that download data and push it straight into our SQL Server tables. A new provider has come on-board and they expose their transaction feed only as a downloadable CSV, so I need one more API written that behaves just like the others. The job is straightforward: fetch the CSV transaction data, map its columns to the existing table structure, and insert each record without any extra transformation—same values in, same values out. The authentication method is a simple token in the request header; I will supply test credentials and the schema of the target tables. You are free to use your preferred stack (our other services are a mix of .NET and Python), but the finished service must: • Retrieve the CSV on a scheduled or on-demand call • Parse the file reliably, handling edge-cases such as commas in text fields • Open a SQL connection with our supplied connection string • Execute parameterised INSERTs for each row • Return success / error responses in JSON so our monitoring can pick them up Once the code is ready, I’ll need: • A brief README covering environment variables, build / run commands, and an example call • A SQL script (or migration) that adds any supporting tables you find necessary • A Postman (or similar) collection showing the main endpoint in action The first test is to pull the API data into a CSV and show me 7/1/2025 to 12/31/2025 data. Once approved, then just add the import function written in existing operational API I will test by pointing the service at the provider’s sandbox feed and confirming the new rows appear unaltered in the database. If that works first time we can move on to wiring it into production and, if you’re interested, discuss the next API in the queue. Attached is an existing API ( [login to view URL]) written for the same API source that pulls the data in csv and drops it into the existing database. Also attached is the new API (APC [login to view URL]) source and sample data
ID do Projeto: 40142237
43 propostas
Projeto remoto
Ativo há 2 meses
Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos

I can build you a clean Python API that fetches the CSV from your new provider, parses it correctly (handling quoted fields with embedded commas), and inserts each transaction into your SQL Server tables using parameterized queries—exactly matching your existing in-house services. I'll use FastAPI for the endpoint with APScheduler for scheduled runs, pyodbc for the SQL Server connection, and return structured JSON responses for your monitoring. You'll get a complete README with environment variable setup, a SQL migration script for any supporting tables, and a Postman collection demonstrating the endpoint. I'm ready to start immediately and can pull the 7/1/2025–12/31/2025 test data as the first deliverable.
$30 USD em 1 dia
3,0
3,0
43 freelancers estão ofertando em média $134 USD for esse trabalho

Hi there, I’m offering a 25% discount for this project. With expertise in API development and financial data processing, I will build a robust API system to securely receive, parse, validate, and integrate CSV transaction files into your application or database. I specialize in creating reliable data pipelines that automate financial workflows and ensure data accuracy. The process includes designing a secure API endpoint for CSV upload, implementing validation rules and error handling, mapping CSV fields to your database schema, and processing transactions asynchronously for performance. I will also set up logging, reporting, and optional webhook notifications for completed batches. You'll receive a fully functional, documented Transaction API with integration examples and deployment instructions. My goal is to deliver an automated, error-resistant system that streamlines your transaction data ingestion and reduces manual processing time. Best regards, Sohail
$30 USD em 1 dia
6,3
6,3

Hi there, We’ve built similar CSV-based APIs that pull data from external sources and insert it into SQL Server, ensuring the same values are stored without any transformation. We also have extensive experience with .NET and Python, so we can choose the best tool for the job. For your project, we’ll create a robust solution that handles edge cases like commas in text fields and supports both scheduled and on-demand data retrieval. We’ll also ensure that the code is production-ready, with features like parameterized queries and detailed logging. Let’s schedule a 10-minute call to discuss your project in more detail and see if I’m the right fit for your needs. I’m eager to learn more about your exciting project. Best, Adil
$118,38 USD em 7 dias
6,0
6,0

Dear . Thanks for sharing your project! I’ve worked on similar projects before and have hands-on experience with tasks like yours. I’ve got a bunch of hands-on experience with SQL, JSON, API Integration, Microsoft SQL Server, Software Architecture, Database Management, API Development, C# Programming, .NET and Python, so I’m comfortable handling everything you’re looking for. If you want to see my work quality, please feel free to check my reviews from previous clients. I can also show examples of previous projects and walk you through my workflow, including clear communication, clean execution, and a professional approach from start to finish. Feel free to message me anytime. I’d be happy to discuss your project and get started. Best Regards, Huy.
$155 USD em 4 dias
5,0
5,0

Hi there! ? I’m a seasoned Full-Stack Developer and API Integration Specialist with expertise in JSON, C# Programming, Python, API Development, Microsoft SQL Server, SQL, .NET, and Database Management. Your project for integrating a new API that provides transaction data in CSV format aligns perfectly with my skills and experience. I propose to develop a new API that fetches the CSV transaction data, maps the columns to match the existing table structure, and inserts each record seamlessly into the SQL Server without any additional transformations. I will use either .NET or Python to build the service, ensuring it retrieves the CSV on a scheduled or on-demand basis, handles edge cases like commas in text fields, and executes parameterized INSERTs for each row. Upon completion, I will provide a detailed README guide with environment variables, build/run commands, and an example call. Additionally, I will include a SQL script for supporting tables and a Postman collection demonstrating the main endpoint in action. My plan includes rigorous testing using the provider's sandbox feed to confirm that new rows appear unaltered in the database. This approach ensures a seamless transition to production. Once the initial test with the sandbox feed is successful, we can proceed to integrate the import function into the existing operational API. Could you please provide the test credentials and schema of the target tables for further progress? Best regards,
$160 USD em 26 dias
5,1
5,1

Dear Bobby, I am excited about the opportunity to assist you with integrating the CSV Transaction API into your existing systems. With my expertise in Python and SQL, I am well-equipped to handle the task efficiently. I have a proven track record of successfully completing similar projects, as showcased in my portfolio. I propose to develop a new API that fetches the CSV transaction data, maps it to your table structure, and inserts records seamlessly. I will ensure reliable parsing of the CSV file, secure SQL connection establishment, and error-handling for smooth operation. Additionally, I will provide comprehensive documentation and support for seamless integration with your current setup. I am eager to discuss your project further and demonstrate how I can add value to your team. Let's collaborate to bring your vision to life. Looking forward to the opportunity, Ali Zahid
$30 USD em 7 dias
5,2
5,2

Hello sir, Did go through your job description and glad to share that I have enormous experience in working with CSV Transaction API Integration I'm a seasoned programmer and Engineer with quality experience in Flutter, React, Node.JS, SpringBoot, Frontend and Backend Development, Python, Matlab, R studio, C, C++, C#, OpenCV, OpenGL, Tesseract OCR, google vision, Statistical programming/R progamming data analysis Computing for Data Analysis Time Series & Econometric, Machine learning, AI, Deep learning, Matlab and Mathematica, 3D modeling, CAD, SolidWorks, Unity 3D, PCB, Electronics, Arduino, Automation, Embedded and Firmware , IOT, Electrical/Mechanical Engineering I am a TOP Rated Freelancer, and you can check my reviews here as well: https://www.freelancer.com/u/mzdesmag. Looking forward to potentially working together on this project. Thanks and Best regards, Adekunle.
$30 USD em 1 dia
5,3
5,3

With over 12 years of experience as a FULL STACK SOFTWARE ENGINEER, I believe that I am the perfect fit for your CSV Transaction API Integration project. Your detailed project description gives me confidence in your project's requirements, and the skills you've mentioned largely align with mine. With extensive knowledge in .NET, C#, JSON, Microsoft SQL Server, and Python, I am well-equipped to deliver a solution which will meet your needs precisely. Having worked with numerous companies, I've built synchronization APIs similar to what you require, so my understanding goes beyond theoretical knowledge. For instance, I’ve successfully managed and executed many PAAS applications with scalability like yours as a foundation. Moreover, I have experience working with Django platform and have effectively managed many SAAS applications like your CVS dissection oversight using Python. These experiences ensure that I'm not only skilled at understanding security nuances but also excel at delivering straightforward and efficient solutions.
$50 USD em 3 dias
4,8
4,8

Hi there, I’m Ahmed from Eastvale, California — a Senior Full-Stack Engineer with over 15 years of experience building high-quality web and mobile applications. After reviewing your job posting, I’m confident that my background and skill set make me an excellent fit for your project — CSV Transaction API Integration . I’ve successfully completed similar projects in the past, so you can expect reliable communication, clean and scalable code, and results delivered on time. I’m ready to get started right away and would love the opportunity to bring your vision to life. Looking forward to working with you. Best regards, Ahmed Hassan
$120 USD em 2 dias
4,8
4,8

Hi there, I'm Kristopher Kramer from McKinney, Texas. I’ve worked on similar projects before, and as a senior full-stack and AI engineer, I have the proven experience needed to deliver this successfully, so I have strong experience in API Development, SQL, Database Management, API Integration, Python, C# Programming, Software Architecture, .NET, JSON and Microsoft SQL Server. I’m available to start right away and happy to discuss the project details anytime. Looking forward to speaking with you soon. Best regards, Kristopher Kramer
$120 USD em 3 dias
4,7
4,7

Hello, I hope you are doing well. I’m a seasoned API and data integration engineer with a track record of building reliable CSV feeders that push clean data into SQL Server. I work across .NET and Python stacks and design pipelines that fetch data on schedule or on demand, map columns to existing tables, and insert with parameterized queries to preserve integrity. In past projects I built CSV-to-SQL importers that correctly handle quoted fields and commas, with token-based auth and robust error handling. I’ll mirror your existing architecture, using the same schema mapping, test credentials, and purely untransformed inserts. I can deliver a small, well-documented service that fetches the provider CSV, maps to your target schema, and returns JSON success/error. It will include a README, a SQL migration/script, and a Postman collection. The first test can pull 7/1/2025 to 12/31/2025 data and report results. Please feel free to contact me so we can discuss more details. Best regards, Billy Bryan
$250 USD em 5 dias
4,1
4,1

Hi there, I have carefully reviewed your project requirements and understand the task clearly. After analyzing the details and expected outcome, I am submitting this proposal with a focused and practical approach to your project. For the CSV Transaction API Integration project, the task is to develop a new API that fetches CSV transaction data, maps its columns to the existing table structure, and inserts records without transformation. The API will use a simple token authentication method in the request header and will connect to SQL Server to execute parameterized INSERTs for each row. Error responses will be returned in JSON format for monitoring purposes. To meet these requirements, I will utilize Python or .NET, ensuring the API can retrieve the CSV either on a schedule or on-demand, parse the file reliably, establish a SQL connection, and handle edge cases like commas in text fields. Additionally, I will prepare a README with environment variables, build/run commands, and a sample call, along with a SQL script for any additional tables needed and a Postman collection showcasing the main endpoint. My approach will focus on seamless integration with your existing stack, ensuring a smooth transition from testing to production. I will start by pulling API data into a CSV for the specified date range and proceed to implement the import function into the operational API once approved. Let's discuss in detail through chat.
$50 USD em 1 dia
3,6
3,6

⭐If you award me, your smile shows up.⭐ Hi Your project immediately stood out to me—it's very similar to one I successfully completed just recently. The core challenges, structure, and technical requirements feel highly familiar, with only a handful of unique elements that align perfectly with my established expertise. This close match is excellent news: it lets me bypass the usual ramp-up period, avoid trial and error, and deliver clean, high-quality work quickly and confidently. I bring deep, hands-on experience with API Development, Python, Database Management, Software Architecture, JSON, C# Programming, SQL, .NET, API Integration and Microsoft SQL Server, along with proven strategies and best practices refined through multiple comparable projects. You can review a directly relevant example in my portfolio here: https://www.freelancer.com/u/thomasb726 I’d be happy to discuss your specific goals in more detail and share a few tailored ideas based on what has worked well in similar scenarios. Why clients consistently choose and return to me: • Clear, proactive, and timely communication—you’ll always know exactly where the project stands • I treat your deadlines, budget, and reputation with the same priority I give my own • Responsive, approachable, and committed to making the entire process smooth and stress-free • Strong ongoing support after delivery; many clients build long-term working relationships as a result If you're looking for precise execution, exceptiona
$250 USD em 3 dias
3,0
3,0

Hi there, I understand that your main goal is to successfully integrate a CSV Transaction API to streamline your data processing and enhance operational efficiency. In my previous role, I successfully implemented a CSV API integration for an e-commerce platform, which automated data uploads and reduced manual processing time by 50%. Additionally, I developed custom error handling features that decreased data discrepancies by 40%, ensuring smoother transactions. To meet your requirements, I will create a robust API integration that accurately processes CSV transactions in real-time, ensuring data integrity and minimizing errors. I will also implement logging mechanisms for easy troubleshooting and enhanced visibility into the transaction process. I would be happy to discuss your needs and get started right away. Best regards, Artem
$140 USD em 7 dias
1,8
1,8

Hi there. I specialize in projects like CSV Transaction API Integration, and my background in Microsoft SQL Server, API Integration, C# Programming, Python, SQL allows me to execute efficiently from day one. Based on your requirements, success depends on hands-on experience in Python, .NET, SQL, C# Programming, Software Architecture, Microsoft SQL Server, JSON, Database Management, API Development, API Integration, not trial-and-error solutions. I bring strong expertise in Microsoft SQL Server, API Integration, C# Programming, Python, SQL, backed by successful project delivery for clients in United States and internationally. I will implement a results-driven solution for CSV Transaction API Integration, focusing on efficiency, quality, and measurable outcomes. Let’s discuss the details and turn CSV Transaction API Integration into a completed success. Best regards, Yevhenii
$140 USD em 1 dia
1,1
1,1

As a seasoned professional with over 12 years of experience, I bring a rare combination of skills to the table that will ensure the seamless execution of your CSV Transaction API Integration project. My repertoire includes proficiencies in .NET, C# Programming, Database Management, JSON, Microsoft SQL Server, Python, Software Architecture, and SQL that precisely align with your needs. I have not only developed APIs similar to what you are looking for but also worked extensively with CSV parsing and SQL database management. Reliability and data integrity are the core principles of this job, and this is an area where my expertise differentiates me from others. I am accustomed to handling complex relational database structures and ensuring that data is moved accurately without loss or errors. Commas in text fields or any other edge cases will be no problem for me. Moreover, my commitment to delivering robust solutions extends beyond code. I am ready to provide detailed documentation - from environment variables to example calls - along with a well-defined migration strategy and Postman collection for smooth onboarding. And once we're done with testing on the sandbox feed and you're contented with the outcome, I'll be eager to continue working on your upcoming APIs. It would be a privilege to apply my everything-in-one-basket capabilities to shape-up your project exactly as per your vision. Let's embark on this digital transformation journey together!
$50 USD em 3 dias
0,6
0,6

Hey , I just finished reading the job description, and I see you are looking for someone experienced in JSON, C# Programming, Python, SQL, Software Architecture, Microsoft SQL Server, API Development, .NET, Database Management and API Integration. This is something I can do. Please review my profile to confirm that I have great experience working with these tech stacks. While I have a few questions: 1. Are all these requirements? If not, please share more detailed requirements. 2. Do you currently have anything done for the job, or does it have to be done from scratch? 3. What is the timeline to get this done? Why Choose Me? 1. I have done more than 250 major projects. 2. I have not received a single bad feedback in the last 5-6 years. 3. You will find 5-star feedback on the last 100+ major projects, which shows my clients are happy with my work. I will share with you my recent work in the private chat due to privacy concerns! Please start the chat to discuss it further. Regards, Kafeel Ahmed.
$155 USD em 1 dia
0,0
0,0

Hi there, I see you're looking for someone to whip up a CSV Transaction API that fits right in with your existing setup. I totally get the need for a smooth transition with the new provider's CSV feed. I've got the chops in Python and .NET, and I can easily fetch that CSV, parse it without a hitch, and map it all to your SQL Server tables. Plus, I’ll make sure to handle those pesky edge cases, like commas in text fields, so everything comes through clean and neat. Here's the plan: I'll set up a scheduled call to grab the CSV, run parameterized INSERTs, and return JSON responses for your monitoring. I’ll also throw in a README and a SQL script to make everything crystal clear for you. Let's get this rolling so you can see those new rows pop into your database without a hitch. I’m pumped to knock this out and chat about the next API on your list! Best regards, Uros S
$140 USD em 7 dias
0,0
0,0

Hello Bobby, I am interested in your project "CSV Transaction API Integration" and I believe I can help you with it. I have experience in developing APIs that download and process data into SQL Server tables. I can create a new API to fetch CSV transaction data, map it to your existing table structure, and insert records without additional transformation. I am available to work in the United States' time zone and can communicate in real-time. I am proficient in both .NET and Python and can use your preferred stack for this project. I would like to have a detailed discussion about the project through chat. I am open to work right now. Best regards, Platon
$100 USD em 7 dias
0,1
0,1

Hello, I read your job post and I understand you need a new API that fetches CSV transaction data from a provider, maps it to your existing SQL Server tables, and inserts each row exactly as received—matching the behavior of your current in-house APIs. I can deliver a reliable service that: Fetches the CSV on schedule or on demand Parses all edge cases (commas, quotes, etc.) Inserts data into SQL Server using parameterized queries Returns JSON success/error responses for monitoring Includes a README, SQL script if needed, and a Postman collection I can start by importing the sample data for 7/1/2025 to 12/31/2025 for your approval, then integrate it fully with your production workflow. I’m comfortable using Python or .NET based on your stack. Could you confirm which stack you prefer for this API so I can align the implementation? Thanks,
$50 USD em 2 dias
0,0
0,0

Hi there, I’m excited about the opportunity to help with building an API that fetches the provider CSV, maps columns, and inserts rows unchanged into your SQL Server tables. I have 7+ years of experience in backend engineering, and I have mastered Microsoft SQL Server, .NET, Python, C#. My prior projects include scheduled CSV ingestion services, robust RFC4180 parsing, and parameterized INSERTs aligned with your requirements. 1️⃣ Implement an authenticated GET endpoint supporting scheduled and on-demand CSV retrieval using the provider token. 2️⃣ Parse the CSV with an RFC4180-compliant parser and stream rows to correctly handle commas and quoted fields. 3️⃣ Map CSV columns to your supplied schema and execute parameterized INSERTs using your connection string. 4️⃣ Return structured JSON success/error responses, log failures, and produce a CSV export for 7/1/2025–12/31/2025 verification. 5️⃣ Deliver README, a SQL migration script for any support tables, and a Postman collection demonstrating the main endpoint. I look forward to working with you. Best Regards, Rosita Iniesta.
$50 USD em 7 dias
0,0
0,0

Lodi, United States
Método de pagamento verificado
Membro desde dez. 9, 2011
$10-30 USD
$30-250 USD
$250-750 USD
$250-750 USD
$30-250 USD
£20-250 GBP
$250-750 USD
$10-30 USD
$250-750 USD
$15-25 USD / hora
₹1500-12500 INR
₹1500-12500 INR
₹600-1500 INR
$250-750 AUD
$25-50 USD / hora
₹600-2000 INR
$25-50 USD / hora
$2-8 USD / hora
$750-1500 USD
$250-750 USD
$250-750 AUD
$30-250 USD
$250-750 USD
$250-750 CAD
$250-750 USD