Excel Import & Export via API Needed
Budget: $8 – $15 USD
I'm in need of a professional who can create two scripts for me: 'Import' and 'Convert'. This project is intended to run on Office 365 Excel or Excel on Windows 11.
Key Requirements:
- The 'Import' script will take data from an Excel file and pull information about Records A (from platform A, with four parameters) and Records B (from platform B, with five parameters).
- The data will then be compared based on simple logic.
- The 'Convert' script will take several B-records that I have marked for export and push them to platform B via API.
I need the scripts to be able to handle read and write API requests, log success/fail results, and detail any errors encountered.
Ideal Skills:
- Proficiency in PowerQuery, VBA, or PowerAutomate is a must.
- Prior experience with Excel automation and scripting.
- Familiarity with API interactions and Excel data manipulation.
Please note, I do not currently have the 'Import' and 'Convert' scripts, so part of the project will be the creation of these scripts.
Key Requirements:
- The 'Import' script will take data from an Excel file and pull information about Records A (from platform A, with four parameters) and Records B (from platform B, with five parameters).
- The data will then be compared based on simple logic.
- The 'Convert' script will take several B-records that I have marked for export and push them to platform B via API.
I need the scripts to be able to handle read and write API requests, log success/fail results, and detail any errors encountered.
Ideal Skills:
- Proficiency in PowerQuery, VBA, or PowerAutomate is a must.
- Prior experience with Excel automation and scripting.
- Familiarity with API interactions and Excel data manipulation.
Please note, I do not currently have the 'Import' and 'Convert' scripts, so part of the project will be the creation of these scripts.