Accepting JSON files
Allow your users to upload and process 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"
}
]
}
Updated 4 months ago