anyToJSON 
Fetches data from anywhere(or atleast strives to) and converts it to JSON. Currently converts flat-file JSON, flat-file CSV, REST JSON, REST CSV and Databases(via ODBC) to JSON.
TOC
Examples
csv file to json
should convert csv to json.
anyToJSON.csv({path: "test/100.csv"}, function(data){
var output = [{"a":"4","b":"9","c":"2","d":"3"}];
var anyToJSONdata = data;
assert.equal(JSON.stringify(anyToJSONdata), JSON.stringify(output));
done()
});should not break when there are commas in strings.
anyToJSON.csv({path: "test/test.csv"}, function(data){
var output = [{"Id":"1","UserName":"Sam, Smith"},
{"Id":"2","UserName":"Fred Frankly"},
{"Id":"1","UserName":"Zachary Zupers"}];
anyToJSONdata = data;
assert.equal(JSON.stringify(anyToJSONdata), JSON.stringify(output));
done();
})loading json from a file
should load json from a file.
anyToJSON.json({path: "test/test.json"}, function(data){
var output = [{"a":"4","b":"9","c":"2","d":"3"}];
anyToJSONdata = data;
assert.equal(JSON.stringify(anyToJSONdata), JSON.stringify(output));
done()
});loading json from rest
should load json from rest.
server.startServer(function(){
anyToJSON.restJSON({
hostname: "localhost",
port: 3000,
path: "/json"},function(data){
var output = [{"a":"4","b":"9","c":"2","d":"3"}];
var anyToJSONdata = data;
assert.equal(JSON.stringify(anyToJSONdata), JSON.stringify(output));
done();
})
});loading csv from rest
should load csv from rest.
server.startServer(function(){
anyToJSON.restCSV({
hostname:"localhost",
port: 3000,
path: "/csv"}, function(data){
anyToJSONdata = data;
var output = [{"a":"4","b":"9","c":"2","d":"3"}]
assert.equal(JSON.stringify(anyToJSONdata), JSON.stringify(output));
done();
})
})Support
- CSV flat file
- JSON flat file
- CSV REST API
- JSON REST API
- Databases (ODBC support)
Future Plans
- Support for XML
- Support for Streaming data