# anyToJSON

**Repository Path**: inops/anyToJSON

## Basic Information

- **Project Name**: anyToJSON
- **Description**: Converts any data repository to JSON(or atleast strives to!). Currently converts flat-file JSON, flat-file CSV, REST JSON, REST CSV and Databases(via ODBC) to JSON 🔥.
- **Primary Language**: JavaScript
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2020-07-06
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# anyToJSON [![Build Status](https://travis-ci.org/lastlegion/anyToJSON.svg?branch=master)](https://travis-ci.org/lastlegion/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](#Examples)
     - [csv file to json](#csv-file-to-json)
     - [loading json from a file](#loading-json-from-a-file)
     - [loading json from rest](#loading-json-from-rest)
     - [loading csv from rest](#loading-csv-from-rest)
   - [Supported Data Formats](#support)
   - [Future Plans](#future-plans)


# Examples

## csv file to json
should convert csv to json.

```js
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.

```js
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.

```js
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.

```js
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.

```js
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