Uploading a JSON file

There are multiple ways to connect data in Luzmo. One of those is by uploading a local file containing JSON. You can also import it using our Google Drive connector.

Luzmo supports two formats for JSON files.

Array of Arrays

In this format, there is one array per row with a value per column. The first row can contain the header names

Example:

[  
    [  
	    302,  
	    4593575,  
	    "Jan",  
	    1467,  
	    "Viewer",  
	    620,  
	    "Filipo de Makelaar",  
	    268,  
	    "FD Makelaar",  
	    "Upsell",  
	    "2020-01-01",  
	    "2020-01-01"  
    ],  
    [  
	    300,  
	    4593575,  
	    "Jan",  
	    1465,  
	    "Designer",  
	    620,  
	    "Felien de Makelaar",  
	    268,  
	    "FD Makelaar",  
	    "Upsell",  
	    "2020-01-01",  
	    "2020-01-01"  
    ]  
]

Array of Objects

In this format, there is one object per row. The keys of the objects contain the header names.

Example:

[  
	{  
		"id": "1",  
		"name": "a",  
    	"datetime": "2021-05-27T11:51:15.814Z",
    	"value": 157
	},  
	{  
    	"id": "2",  
    	"name": "b",  
    	"datetime": "2021-06-01T15:17:26.287Z",
    	"value": 105
    }  
]