How do I read a csv file from a HTTP request?

Community Support
1

I’ve got a CSV file on a web server that get’s updated every now and then and would like to append new rows to a table when I run a q script. 

I’m using the file at http://code.kx.com/wsvn/code/cookbook\_code/yahoo.q as a reference for using http requests, and have changed the symbol casting to work with the lastest version of kdb.

At the moment, I’m just trying to read in the CSV file but it doesn’t seem to be working. 

q)url:`$":http://www.football-data.co.uk/mmz4281/1314/E0.csv";

  


q)(" SSSIIIIII IIIIIIIIIIII"; ",") 0: url; //doesn't work
2

data:(`$“:http://www.football-data.co.uk”) “GET /mmz4281/1314/E0.csv http/1.0\r\nhost:www.football-data.co.uk\r\n\r\n”
(" SSSIIIIII IIIIIIIIIIII"; “,”) 0:data

3

Thanks! got it working, now just need to format the result properly. 

4

You can’t beat the bookies…trust me!!

5

I’m making a database so I can demo a GUI toolkit I’ve been writing in Java, just needed to pick something I’m interested in.