
Closed
Posted
Paid on delivery
Purpose Parse various input data, tranform and transmit it successful via API call and receive enriched data related to people and properties Stack Needs Microsoft & Azure Scope & Flow 1- A Power Automate flow is triggered when a new file is uploaded to a specific SharePoint or OneDrive folder. 2- The flow sends the file to an Azure Function. 3- The Azure Function (written in a language like Python or C#) contains the logic to: Parse the input file. Call the Data warehouse API for each record. Process the complex, nested data returned by the API. Create the "wide" sheet with all enriched data and the separate "to verify" sheets (for emails, phones, addresses). 4- The Azure Function then saves these newly generated Excel files back to a designated output folder in SharePoint or OneDrive. Goals Robust & Scalable, Cost-Effective and create the feel of a "Magic Folder" Feel: The entire process is automated. The user just needs to drop a file into a folder. Resources I will provide multiple input files, a successful output file, the App Script from Google Sheet that currently works with the API call, the API Docs. I look forward to working together! Note: I have accomplished the above in Google Sheet, have a newborn at home, and need someone with Microsoft Ecosystem experience to create the solution above - so I can sleep.
Project ID: 39744008
132 proposals
Remote project
Active 8 mos ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
132 freelancers are bidding on average $1,098 USD for this job

Hi David, Nice to meet you, this is Abdul and I have deeply gone through the job details and Immediately available to start the Job after discussion. ping me to get started. Thank you - Abdul
$250 USD in 3 days
7.3
7.3

Got the given description ------------I have extensive experience with similar PROJECT->>> Microsoft Azure-Powered Data Transformation ---->>I am highly qualified to do this job with high QUALITY ----- I am Passionate .NET/AZURE Full stack developer having rich experience with so many successful Tasks. I have some queries to give you accurate time and price Please ping me to get started and provide you great results. Thanks
$1,000 USD in 7 days
7.0
7.0

Hello, I understand that you're looking to automate data transformation using Microsoft Azure. The goal is to create a seamless process that triggers when a new file is uploaded to SharePoint or OneDrive. With my experience in Microsoft Azure and related technologies, I can help you implement a flow that efficiently parses the input files, interacts with the Data Warehouse API, and returns enriched data in well-structured Excel sheets. This will not only meet your requirements but also contribute to a "Magic Folder" feeling where everything works automatically, allowing you to focus on your newborn. What specific formats do the input files have, and are there any special requirements for the output Excel sheets? Thanks, Shamshad
$750 USD in 14 days
6.8
6.8

With over a decade of experience as a Linux Engineer and Full Stack developer, I have honed my skills in Ubuntu, Centos, Kali Linux, Debian, Rocky Linux, Reactjs, Nodejs, and Web Development. This extensive background has provided me with significant exposure and expertise in working with Python as well. As you seek an Azure-savvy professional who can ensure your data transformation project integrates seamlessly into the Microsoft Ecosystem - I am your ideal candidate. Having accomplished similar projects transforming data via API calls within Google Sheets , I bring forth the crucial combination of being adept at navigating Microsoft's Azure Stack while offering domain knowledge to make the project transfer smooth. The output file from your current Google Sheets solution will be highly valuable in maintaining continuity while leveraging the power of the Microsoft ecosystem. Moreover, I understand the paramount importance of delivering a robust, scalable, and cost-effective solution as per your requirements. With a performance-driven mindset, my goal is to make this process as 'magical' as possible - mirroring your desired 'drop a file and sleep' experience fully. I am excited about the prospect of leveraging my skills for this project and look forward to collaborating closely with you!
$300 USD in 1 day
6.5
6.5

As an experienced developer with immense proficiency in Microsoft Azure, C# and API functionalities, I am confident that I can deliver this project notable skillset utilizing advanced languages such as Python or C#. My ability to efficiently parse, transform and transmit data across diverse platforms make me the best fit for building your "Magic Folder" with Microsoft Ecosystem. Plus, 94% of my jobs have been successfully completed on budget, assuring you of utmost cost-effectiveness. Understanding that robustness and scalability are your primary goals, I guarantee a power-packed solution that automates the entire process in a seamless manner. You will only need to drop files into the designated SharePoint or OneDrive folder and the rest will be handled by the Azure Function created by me. This is designed explicitly to handle complex, nested data ensuring clear and widely segregated outputs as requested. Moreover, my technical skills extend further to include not just C#, but .NET, Angular and Typescript. This vast repertoire enables me to tackle any unforeseen challenges that may arise promptly. Client satisfaction being fundamental to my work ethics, I can assure you quick project delivery along with full support which means you can indeed 'sleep' peacefully!
$750 USD in 2 days
6.3
6.3

I understand the need for your project to be robust, scalable, and cost-effective. I have both the extensive experience and the necessary skills in Python, which is one of the preferred languages for cloud and data-centric solutions in Azure. My expertise includes parsing data, API integrations, complex data processing, and data enrichment from my experience with embedded systems and IoT projects. As an extra asset to your project, I possess knowledge of Linux systems that are often used for Azure Functions. One unique thing about me is my adherence to delivering work within set deadlines and ensuring it is of impeccable quality. Your description portrays the use of a SharePoint/OneDrive system: a part of Microsoft’s ecosystem that I am adept at handling. Additionally, you specified a desire for automation where users need only drop a file into the folder; I assure you of providing this so that you have a "Magic Folder" feeling as intended. In conclusion, with my experience in Software Engineering and mastering Microsoft's ecosystem specifically Azure functionalities, entrusting this project to me will give you peace of mind while having someone capable to handle every aspect with professional efficiency - including debugging when unscheduled clarifications or adjustments are required- thus allowing you to redirect your focus on other relevant matters. Let's create this Azure-powered data transformation magic together!
$750 USD in 14 days
6.4
6.4

Hello, Are you interested in a seamless data transformation solution that automates your workflow? I'd be happy to provide a free demo of how we can achieve this using Microsoft Azure. My intention is to leverage Microsoft Azure to streamline your data processing needs with a solution that is both robust and cost-effective. I invite you to discuss this further so we can outline a detailed plan and showcase a proof of concept during the demo. Regards, Smith
$500 USD in 7 days
6.2
6.2

Hello, I am an expert with 15+ years of experience in the technical world, delivering simple to complex websites, e-commerce platforms, membership systems, and portal websites. I provide clear communication, continued support after delivery, and 100% client satisfaction. I specialize in .NET and C# development, creating secure, scalable, and high-performance applications including enterprise solutions, APIs, and database-driven systems. I always adopt the latest technologies to ensure modern and future-ready solutions. If you are looking for a dedicated .NET expert who delivers quality, reliability, and timely results, I’d be glad to work on your project. Best regards,
$250 USD in 7 days
5.9
5.9

⭐Hi, I’m ready to assist you right away!⭐ I believe I’d be a great fit for your project since I’ve built end-to-end Microsoft/Azure pipelines that turn dropped files into cleaned, enriched Excel reports. I can recreate your Google Sheets App Script workflow in a robust, server-side solution using Power Automate, Azure Functions, and SharePoint/OneDrive. I can deliver a working "magic folder" prototype quickly and provide a cost-efficient plan for scaling and monitoring. I’ve built Power Automate triggers that call Azure Functions to parse files, call third-party APIs, and write results back to SharePoint. I’ve also migrated similar Google Apps Script automations to Azure using Python and C#, improving reliability and security. This project will stop manual copy/paste and fragile client-side scripts. It will produce a repeatable, auditable flow that drops enriched wide sheets and verification sheets back into SharePoint automatically. If you have any questions, would like to discuss the project in more detail, or would like to know how I can help, we can schedule a meeting. Thank you. Maxim
$500 USD in 7 days
5.6
5.6

Hi client, I'm Denis Redzepovic, an experienced developer with expertise in API Development, Python, Power Automate, Microsoft, Sharepoint, C# Programming, Microsoft Azure and .NET. I have worked extensively on diverse Python projects, ranging from backend development and automation to data processing and API integrations. My deep understanding of Python’s libraries and frameworks allows me to build efficient, scalable, and maintainable solutions. I pay close attention to code quality and performance to ensure your project runs flawlessly. With my solid experience, I’m confident I can deliver results that exceed your expectations. I focus on writing clean, maintainable, and scalable code because I know the difference between 99% and 100%. If you hire me, I’ll do my best until you’re completely satisfied with the result. Let’s discuss your project details so I can tailor the perfect Python solution for you. Thanks, Denis
$350 USD in 5 days
5.4
5.4

Hi, As experienced Azure and Microsoft Power Automate specialist, we understand your need for a robust, scalable data transformation process and we can assure you that my skills and expertise are the perfect fit for this project. Having had hands-on experience with similar projects before, we can provide you with a "magic folder" feel, where automation is seamless and your efforts are reduced to simply dropping a file into the folder. Let's discuss more on chat and go ahead. Regards, Team SolutionzHere
$800 USD in 10 days
5.5
5.5

Hi, I specialize in Microsoft Azure-based automation and data transformation solutions. For your project, I’ll build a robust Power Automate → Azure Function workflow where files dropped into SharePoint/OneDrive are parsed, enriched via your Data Warehouse API, and returned as structured Excel outputs (“wide” sheets + separate verification sheets). The entire flow will be automated to create the seamless “Magic Folder” experience you described. I’ve recently implemented a similar Azure solution for a financial services client, where incoming files were processed through an Azure Function (C#), enriched via external APIs, and exported back to SharePoint with automated verification sheets. That project reduced manual work by over 70%—experience directly applicable here. You’ll receive a scalable, cost-efficient system with clear documentation, so you can rely on it without manual intervention. Best, Joseph
$500 USD in 7 days
5.5
5.5

Hi there! This looks like a full automation pipeline where Power Automate triggers, Azure Functions handle heavy lifting, and everything stays synced with SharePoint/OneDrive without breaking the flow or adding latency. I’ve been building enterprise-grade workflows for 8 years using Microsoft stack, Azure Functions (C# and Python), and API-driven data enrichment, so creating a scalable, cost-effective automation like this is right in my zone. I actually did something similar for a real estate analytics company—used Azure Functions to parse CSVs, hit an external enrichment API, normalized nested JSON, and generated multi-sheet Excel reports via OpenXML before saving them back to SharePoint. It worked like a true “magic folder” for them. Here are some solutions to complete the project: 1. Build a Power Automate flow to trigger on new file upload and pass it to an Azure Function, ensuring zero manual steps for the user. 2. Implement Azure Function logic to parse, call the API, and process nested data into clean, enriched output files, improving accuracy and user confidence. 3. Generate the final Excel with structured “wide” and “to verify” sheets and push it back to the right folder, giving that seamless drop-and-done experience. I can deliver a working prototype in 3–4 days showing the full pipeline in action. If you choose me, we’ll turn this into a true one-click automation fast; if not, I hope you find someone who nails it for you. Good luck!
$600 USD in 7 days
5.2
5.2

Hi, With 5 years of hands-on experience in Azure Cloud, I specialize in delivering top-notch cloud solutions tailored to your business needs. My services include: Azure cloud architecture design Virtual machine setup and management Cloud migration and deployment Azure DevOps implementation Security and compliance configuration Cost optimization strategies Backup and disaster recovery solutions Monitoring and maintenance
$650 USD in 7 days
5.0
5.0

Hello, I am a full stack developer with 10+ years of experinec in web, mobile and ai development. I can do the project, let's discuss more details in the chat. Thanks.
$500 USD in 7 days
5.0
5.0

Hi, Q1. What file types/volumes should we support initially (CSV/XLSX/JSON; max rows/MB per file, expected daily drop count)? Q2. Does the Data Warehouse API have rate limits or per-record quotas we must respect, and should we parallelize or throttle calls? Q3. How “authoritative” should the outputs be append-only per run, or idempotent updates if the same file is reprocessed? Your “Magic Folder” vision is exactly what I build in the Microsoft ecosystem. I can deliver an end-to-end, robust, and cost-effective solution so you can simply drop a file and sleep while Azure does the heavy lifting. I’ve led and delivered Microsoft-stack automation for ministries and enterprises (SharePoint/Office 365, Power Automate, custom APIs), and I’ll bring those best practices here to avoid the usual pitfalls. Share the sample inputs, your successful output, the Google Apps Script, and the API docs, and I’ll mirror the working logic on Azure with proper resilience. Looking forward to collaborating on thishappy to discuss deliverables and timeline. Best regards, Rahim
$750 USD in 7 days
4.9
4.9

Hello, I have read your job post and I am interested in the same. I have a B. Tech (Computer Science) and MBA from the very best universities in the country with an acceptance rate of 0.01% of the applicants. I have been doing academic writing and programming tasks for over 5 years now. I have worked with students from the US, UK, UAE and Australia in different domains ranging from Machine Learning, Website design, Engineering and others. I have expertise with C, C++, Python, Java and other languages along with Networking, Packet Tracers etc. I can discuss in detail after you have shared complete details of the task. I have assisted students from graduation, masters and Ph.D level with their thesis or other work. I can assist you in a single assignment or take up your entire course. I can assure you in terms of quality and deliverables. Please do send me a message in case you have any questions.
$500 USD in 7 days
4.8
4.8

Hi there, I'm Ahmed Hassan, a Senior Full-Stack Engineer based in California with over 15 years of hands-on experience in web and mobile application development. After reviewing your job posting, I’m confident that my background aligns closely with your project requirements and enough qualified for your project - Microsoft Azure-Powered Data Transformation. I’ve successfully delivered SIMILAR projects in previous roles—both as a senior developer and project manager—ensuring secure, scalable, and user-friendly systems tailored to business goals. I’d love the opportunity to discuss how I can contribute to your project’s success. Looking forward to connecting. Best regards, Ahmed Hassan
$500 USD in 6 days
4.8
4.8

Hello David R. Hope you are doing well! This is Efan , I checked your project detail carefully. I am pretty much experienced with Sharepoint, Microsoft Azure, Power Automate, .NET, Microsoft, C# Programming, Python and API Development for over 8 years, I can update you shortly. Cheers Efan
$250 USD in 1 day
5.5
5.5

✋ Hi, there. I can build a fully automated Microsoft Azure solution to parse, enrich, and store your data with minimal user effort. ✔️ I have experience creating Power Automate flows and Azure Functions for data processing. I previously built a solution where files uploaded to SharePoint were automatically processed, API calls were made per record, and enriched Excel reports were saved back for user access. ✔️ I will set up a Power Automate flow triggered on file upload, send the file to an Azure Function (Python or C#) that parses input, calls your API, processes nested data, and generates both the wide sheet and verification sheets. The output files will be saved back to SharePoint or OneDrive automatically. ✔️ The solution will be fully automated, cost-effective, and easy to maintain, giving the feel of a “Magic Folder” where users only drop files and receive results. I will ensure the process handles complex data reliably and can scale as needed. Let's chat so I can review your API docs and sample files and plan the flow. Best regards, Mykhaylo
$500 USD in 7 days
5.0
5.0

Dallas, United States
Payment method verified
Member since Sep 12, 2019
$10-30 USD
$750-1500 USD
₹1500-12500 INR
₹600-1500 INR
₹12500-37500 INR
$250-750 USD
$30-250 USD
₹15000-20000 INR
$30-250 USD
₹12500-37500 INR
$250-750 USD
€2-6 EUR / hour
€6-12 EUR / hour
$2-8 USD / hour
$3000-5000 USD
₹12500-37500 INR
$10-80 USD
$2-8 USD / hour
min £36 GBP / hour
₹600-601 INR
₹400-750 INR / hour
$10-200 USD
$10-30 USD
₹10000-20000 INR
$8-15 USD / hour