node package manager
Orgs are free. Discover, share, and reuse code in your team. Create a free org »

field-data-array-to-json

field-data-array-to-json

This is a simple script which converts a JSON object with fields and data arrays to an array of JSON objects with mapped fields and data. I mainly wanted this to convert JSON data exported from data.gov.in (Example - https://data.gov.in/node/356981/datastore/export/json) which has two arrays for fields and data. This might not be readily usable in an app hence wrote this module to transform JSON file as shown below.

Usage

This can be installed as a global module to transform JSON

npm i field-data-array-to-json -g

Once installed you can use fda2j command (I know the name sucks, suggest a better one please!) to transform the JSON files:

fda2j --in <path to input JSON file> --out <path for saving transformed JSON file>

Sample Input

{
    "fields": [
        {
            "id": 1,
            "label": "city"
        },
        {
            "id": 2,
            "label": "state"
        }
    ],
    "data": [
        [
            "Chennai",
            "Tamilnadu"
        ],
        [
            "Mumbai",
            "Maharashtra"
        ]
    ]
}

Output

[
  {
    "city": "Chennai",
    "state": "Tamilnadu"
  },
  {
    "city": "Mumbai",
    "state": "Maharashtra"
  }
]

You would not need to do this when you access the same data through API (https://data.gov.in/api/datastore/resource.json?resource_id=e16c75b6-7ee6-4ade-8e1f-2cd3043ff4c9&api-key=YOURKEY) but you might not want to use the API always and perhaps export the data and use it from your server.