downloading an combining multiple json files then creating a single excel table.

[JeffGrant]

I have an app in java that downloads csv files from a data supplier, then combines them, puts backup copies into various local folders and then creates a csv file ready to import into excel. It has been working well for about 2 years.

However, the data supplier has notifed me that the longer term support for csv files may end.

Is it possible to achieve the same result using PQ to get the data and create teh table I need?

Thanks

 

[jdellasala]

Short answer is yes. PQ can import JSON files directly, or you can point to a folder and filter the results and pull in the JSON files in that folder and sub folders.
This is THE best way to handle this. If you have a PQ script for the CSV files, you should be able to use it as a guide for handling the JSON files.
Great YouTube playlists on PQ can be found here and here. I particularly like the later because start and end workbooks are provided for each video. The lists are long, but you should only need to watch a few to be able to do what you need to do. It's well worth the time! Good luck.