Forum Discussion
Yahoo Finance Power Query Link Not Working
This works. Thanks. The JSON chart is a text document, so use whatever you wish to fit the historical data into your existing scripts. I used awk to load and transpose the chart to the old CSV format. The only reason is that I've been using awk since the 1970s and it is second nature. Anyone younger won't do that. I automatically load hundreds of tables daily, Unix bash scripts.
Nice.... I slightly predate the PC as we know it starting out on Sun Micrososytems SunOS & Silicon Graphics but AWK is new to me!
I am facing exactly the same issue. Mine loads a csv file into a blob storage container to be used in a data warehouse pipeline. I wonder how to get this going as I am not sure of how to change the json to csv before it hits the blob storage. Any ideas?
