Python, Excel VBA, API Integration to Parsing Specific Line from API response
$10-30 USD
Paid on delivery
I am seeking a professional with strong expertise in Python, Excel VBA, and API integration. The primary task is to extract specific data from the API response, and populate it into a designated column in an Excel file.
Key Requirements:
- Experience in Python programming
- Proficiency in Excel VBA
- Demonstrable experience with API integration
- Ability to parse specific data from an API response from Google Server
- Good understanding of automating tasks in Excel
Further Details:
- The primary purpose of the project is to send API requests with image URLs listed in column A of the Excel file. Upon receiving the API response, the relevant data should be extracted and placed in column D and B/C/E to be populated.
- The setup should be easy to execute when needed by click of few buttons and automatically looping until all rows in excel are submitted by API.
- The final deliverable should be in .xlsx format.
ATTACHED:
- Partial response of JSON API shown in attached screen shot [login to view URL]
- Format of excel file which shows how the image urls listed on column and other columns to populate.
Please submit your bid if you have a strong background in this area.
Project ID: #38016980
About the project
Awarded to:
Hello, I'm skilled in Python, Excel VBA, and API integration, ready to extract specific data from API responses and populate it into designated columns in an Excel file. Let's discuss further.
12 freelancers are bidding on average $23 for this job
Hey! Greetings from Wilfred! I am thrilled to express my strong interest in this Python, Excel VBA, API Integration to Parsing Specific Line from API response project. With my years of experience working as a freela More
Hi I have read the requirements and understand them. I can assure you that if you work with me once, you will always work with me on these kinds of projects. would you like to discuss the project with me?
Hi! Greetings, Having carefully reviewed your project description, I am confident in my ability to execute this project to perfection. I possess a broad spectrum of skills, knowledge, and experience in this specific More
HI!!! I'm proficient in Python, Excel VBA, and API integration – the perfect fit for this project. I'll automate your data extraction: API Mastery: I'll seamlessly extract the required data from the Google Server API More
Hi, I have more than 10 years of experience as full stack developer and specially in python. I can take start on this immediately and can complete until tomorrow. I understood the requirements which you mentioned. More
I'm an Excel expert with experience in formula creation and data updating. I spent 3 year in Accounting and finance which is helpful for your project. I understood your project's requirements, I will make sure to do my More