How to read CSV from open data URL?

[firedude144]

Noobish question here. I'm trying to read some open data CSV files online to be able to parse it into a graph but I'm not catching on to what I need to do to actually get at the data behind the URL. Here's a sample URL.

I've tried HTTP IN and HTTP GET but they just stare at me blankly and say "What?"...actually, they don't say anything. Should I download the file first then parse? If so, how?

Cheers

[dceejay]

Seems to be pretty neat.. but you need the http-request node... (to request data
here is a simple flow to get you going

[{"id":"fd65e1f6.44d72","type":"inject","z":"3ead5d77.6a6672","name":"","topic":"","payload":"\"17\",\"N\",,,\"a:0:{}\",\"\",\"Janek\",\"Kowalski\"","payloadType":"str","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":150,"y":1240,"wires":[["4960a405.20c31c"]]},{"id":"4960a405.20c31c","type":"http request","z":"3ead5d77.6a6672","name":"","method":"GET","ret":"txt","paytoqs":false,"url":"https://www.donneesquebec.ca/recherche/fr/dataset/857d007a-f195-434b-bc00-7012a6244a90/resource/16f55019-f05d-4375-a064-b75bce60543d/download/pf-mun-2019-2019.csv","tls":"","persist":false,"proxy":"","authType":"","x":340,"y":1240,"wires":[["8978ea5e.b77d18"]]},{"id":"8978ea5e.b77d18","type":"csv","z":"3ead5d77.6a6672","name":"","sep":",","hdrin":true,"hdrout":"","multi":"one","ret":"\\n","temp":"","skip":"0","strings":true,"x":530,"y":1240,"wires":[["49a5a87c.278e48"]]},{"id":"49a5a87c.278e48","type":"debug","z":"3ead5d77.6a6672","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":690,"y":1240,"wires":[]}]

[firedude144]

That was quick! Been spinning my wheels all day trying to figure that out. Thanks for the push!

[firedude144]

I get can the data in debug but I don't think it is what the chart node is expecting. The chart shows up blank.

[{"id":"300c2f1f.e165e","type":"inject","z":"32556e66.f0c022","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":120,"y":320,"wires":[["d26871e7.693cd"]]},{"id":"d26871e7.693cd","type":"http request","z":"32556e66.f0c022","name":"Get COVID data","method":"GET","ret":"txt","paytoqs":false,"url":"https://covid.ourworldindata.org/data/total_cases.csv","tls":"","persist":false,"proxy":"","authType":"","x":300,"y":320,"wires":[["19ef5c8.f4157a4"]]},{"id":"19ef5c8.f4157a4","type":"csv","z":"32556e66.f0c022","name":"","sep":",","hdrin":true,"hdrout":true,"multi":"one","ret":"\\n","temp":"date,World,Afghanistan,Albania,Algeria,Andorra,Antigua and Barbuda,Argentina,Armenia,Australia,Austria,Azerbaijan,Bahrain,Bangladesh,Belarus,Belgium,Bhutan,Bolivia,Bosnia and Herzegovina,Brazil,Brunei,Bulgaria,Burkina Faso,Cambodia,Cameroon,Canada,Cayman Islands,Chile,China,Colombia,Costa Rica,Cote d'Ivoire,Croatia,Cuba,Cyprus,Czech Republic,Democratic Republic of Congo,Denmark,Dominican Republic,Ecuador,Egypt,Estonia,Ethiopia,Faeroe Islands,Finland,France,French Guiana,French Polynesia,Gabon,Georgia,Germany,Ghana,Gibraltar,Greece,Guadeloupe,Guernsey,Guinea,Guyana,Honduras,Hungary,Iceland,India,Indonesia,International,Iran,Iraq,Ireland,Israel,Italy,Jamaica,Japan,Jersey,Jordan,Kenya,Kuwait,Latvia,Lebanon,Liechtenstein,Lithuania,Luxembourg,Macedonia,Malaysia,Maldives,Malta,Martinique,Mexico,Moldova,Monaco,Mongolia,Morocco,Nepal,Netherlands,New Zealand,Nigeria,Norway,Oman,Pakistan,Palestine,Panama,Paraguay,Peru,Philippines,Poland,Portugal,Puerto Rico,Qatar,Reunion,Romania,Russia,Saint Barthlemy,Saint Martin (French part),Saint Vincent and the Grenadines,San Marino,Saudi Arabia,Senegal,Serbia,Singapore,Slovakia,Slovenia,South Africa,South Korea,Spain,Sri Lanka,Sudan,Sweden,Switzerland,Thailand,Togo,Trinidad and Tobago,Tunisia,Turkey,Ukraine,United Arab Emirates,United Kingdom,United States,Vatican,Venezuela,Vietnam","skip":"0","strings":true,"x":490,"y":320,"wires":[["d6750951.024458","377a982.29e0c68"]]},{"id":"377a982.29e0c68","type":"ui_chart","z":"32556e66.f0c022","name":"","group":"1c71c025.cb23e","order":0,"width":0,"height":0,"label":"chart","chartType":"horizontalBar","legend":"true","xformat":"auto","interpolate":"linear","nodata":"","dot":false,"ymin":"","ymax":"20000","removeOlder":1,"removeOlderPoints":"","removeOlderUnit":"3600","cutout":0,"useOneColor":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"useOldStyle":false,"outputs":1,"x":690,"y":300,"wires":[[]]},{"id":"d6750951.024458","type":"debug","z":"32556e66.f0c022","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":710,"y":360,"wires":[]},{"id":"1c71c025.cb23e","type":"ui_group","z":"","name":"Default","tab":"fae1f75a.b6a308","disp":true,"width":"6","collapse":false},{"id":"fae1f75a.b6a308","type":"ui_tab","z":"","name":"Home","icon":"dashboard","disabled":false,"hidden":false}]

[dceejay]

Well there is lots of data there - you need to extract something and work out what you want to plot on what sort of chart.