Accepting JSON files

The JSON to CSV transform can extract objects from an array in your JSON file and create a CSV file from this data which can then be processed in OneSchema.

Each object in the array will result in one row, with the object keys specifying the column and the object values being the cell values for this row.

Example JSON array and resulting CSV:

[
  {
    "first name": "Tessie",
    "last name": "Batha",
    "street": "428 Eliot Crossing"
  },
  {
    "first name": "Margy",
    "last name": "Dibner",
    "city": "Clearwater"
  }
]

first name	last name	street	city
Tessie	Batha	428 Eliot Crossing
Margy	Dibner		Clearwater

Configuring the entry path

If your JSON is an object that contains an entry with the data array you can specify the entry path for the extraction. For example the entry path for this JSON would be records.

{
 "records": [
   {
     "key": "value"
   },
   {
     "key": "value"
   }
 ]
}