JeffGrant
Well-known Member
- Joined
- Apr 7, 2021
- Messages
- 558
- Office Version
- 365
- Platform
- Windows
I have a java API that downloads and combines csv files from a data site, ready for import into excel.
Basically, the API gets a particular file, then loops through all of the lines in the file to pull down the relevant data for the day.
The data suppler also supplies the data as json files and they are making noises about stopping the supply of the csv files.
With PQ, i can see there are many videos about pulling a single data file with a known URL, but i have not seen anything that would effectively loop through an input list to create the URL as an input variable.
Is this possible?
I am a real novice with PQ, and a little above novice with VBA, so I can grab the jist of it without claiming be a professional. so I do understand the technical parts of what i am asking here.
I look forward to hearing from your guys soon.
Basically, the API gets a particular file, then loops through all of the lines in the file to pull down the relevant data for the day.
The data suppler also supplies the data as json files and they are making noises about stopping the supply of the csv files.
With PQ, i can see there are many videos about pulling a single data file with a known URL, but i have not seen anything that would effectively loop through an input list to create the URL as an input variable.
Is this possible?
I am a real novice with PQ, and a little above novice with VBA, so I can grab the jist of it without claiming be a professional. so I do understand the technical parts of what i am asking here.
I look forward to hearing from your guys soon.