Up until now I hadn’t worked with this type of situation. However I do work with macros in Base and have access to JSON files from Weather Underground so I ran a few tests.
Downloading the JSON file was done in the macro with a ‘Shell’ statement using ‘curl’. Worked without a problem. Again using the ‘Shell’ statement, I extracted the data using a ‘batch’ type file containing ‘cat/jq’ statements and wrote this output to another file. No problem here either. Now it’s just a matter of reading that file and creating either a sheet with the data or records for a DB. That shouldn’t be too difficult as I found reference to that in OOME (Open Office Macros Explained) by Andrew Pitonyak which you can download in PDF version here.
Since I’m using Linux, Windows or Mac programs and utilities used in the ‘Shell’ statement will obviously be different. Downloading a CSV file will be no different than the JSON file - just the processing afterwards.
I would only go this route if this process is to be done on a routine basis. If only once or rarely, then you can read a CSV file into either Calc or Base rather easily. If you have not worked with LO macros, it can be very challenging.