No, the JSON connector is tuned to process "record based" JSON data sets only.
In the following example this JSON (schema) data set separates the data from the field definitions and is designed that way to allow programs to define database table schema and then populate that schema with the data found in the DATA block.
https://data.ny.gov/api/views/cb42-qumz/rows.json?accessType=DOWNLOAD
The Yellowfin JSON connector works only with record based JSON data sets, like this example:
https://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/4.5_week.geojson