Microsoft power Automate Desktop Excel to API to SQL Autotransfer
Budget: ₹1,500 – ₹12,500 INR
As the client, I have a need for a workflow that will automate the transfer of select information from an Excel file to a Web API then to SQL. Further from there, it will execute a query and store the result back into the excel file.
Key tasks include:
- Extraction of specific columns and selected rows from Excel
- Data transformation and transfer to a Web API
- Execution of query in SQL
- Return of results back to the existent Excel file
The ideal applicant should have extensive experience with Power Automate Desktop, Excel, API integration and SQL. Knowledge of file management and data transformation is essential. Strong attention to detail will be required to ensure accurate extraction of select data from an Excel spreadsheet.
Key tasks include:
- Extraction of specific columns and selected rows from Excel
- Data transformation and transfer to a Web API
- Execution of query in SQL
- Return of results back to the existent Excel file
The ideal applicant should have extensive experience with Power Automate Desktop, Excel, API integration and SQL. Knowledge of file management and data transformation is essential. Strong attention to detail will be required to ensure accurate extraction of select data from an Excel spreadsheet.