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
  • loading json from a file
  • loading json from rest
  • loading csv from rest
• Supported Data Formats
• Future Plans

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