I know how to parse JSON response, but the stupid Foobot.io API responds with CSV! Anyone know how I can parse out pm, co2 and voc from the following response?
Pulling data now with curl, will make it it an http item:
curl -X GET --header "Accept: text/csv;charset=UTF-8" --header "X-API-KEY-TOKEN: eyJhbGciOiJIUzI1NiJ9.eyJncmFudGVlIjoibmF0aGFuQHJvYm90aWNzLm5ldCIsImlhdCI6MTQ4NzE3NTYyMiwidmFsaWRpdHkiOi0xLCJqdGkiOiJiMGasZTU5YS0zOWEdsTQzNDUtYmU5Mi1lMThmMmUzNTk2YjAiFCJwZXJtaXNzaW9ucyI6WyJ1c2VyOnJlYWQiLCJkZXZpY2U6cmVhZCJdLCJxdW90YSI6MjAwLCJyYXRlTGltaXQiOjV9.skkOxbDOaMetkL509wV6BSeKbMLhpl5YXiLPoh5_-3I" "https://api.foobot.io/v2/device/24004667007040C0/datapoint/0/last/0/"
Response:
#time (s), device local time, pm (ugm3), tmp (C), hum (pc), co2 (ppm), voc (ppb), global (%)
1487176005,2017/02/15 11:26:45,4.5,22.044,32.795,450.0,125.0,4.5