
Create Excel sheet to pull data from API through power query
- or -
Post a project like this1083
£155(approx. $208)
- Posted:
- Proposals: 11
- Remote
- #3802134
- Awarded
Data Scraper| Data Collection| Data Entry| Web Research| Lead Generation | Product Listing
AI Automation Engineer | OpenAI, Agents & Workflows| LLM & Chatbot Specialist| Machine Learning| Custom AI Agent
FINANCIAL DATA PRESENTATION | BESPOKE PRESENTATION | DATA ANALYSIS PRESENTATION | ANNUAL REPORT PRESENTATION | POWERPOINT TEMPLATES

Wordpress developer | React developer | Front-end developer | n8n automation | Hubspot | Shopify | Airtable | RAG | Flowise | crawl4ai | MCP | qdrant

8247101552962245018832247736597396482785131412352144947378248827320377103441
Description
Experience Level: Entry
Estimated project duration: less than 1 week
I'm looking for someone to build an Excel based tool which will pull data via REST to a non-authenticated public API through Power Query.
The API in question returns data in JSON, and there are a number of parameters which I wish to pass to it that will come from a table within Excel.
Further, I want to be able to iteratively run queries on the API as there may be permutations of the parameters (generally up to five iterations but the solution should provide for n-cases).
Where this iterative process is undertaken, I would like the option of combining all of the data into a single query table, or having it separated based on the number of iterations, with a table per iteration.
The API in question returns data in JSON, and there are a number of parameters which I wish to pass to it that will come from a table within Excel.
Further, I want to be able to iteratively run queries on the API as there may be permutations of the parameters (generally up to five iterations but the solution should provide for n-cases).
Where this iterative process is undertaken, I would like the option of combining all of the data into a single query table, or having it separated based on the number of iterations, with a table per iteration.
Davoud D.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
19 Jan 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies