dataset schema not showing correctly for .json file

arkiboys 9,686 Reputation points
2022-11-13T07:34:34.127+00:00

hello,
I am trying to load a .json file which has alot of different arrays...
but when I try to create a dataset, in the schema, I do not see all the quantities array items
it only shows me
For example the file is like this:

{
"dv": "54344",
"book": "hhgg",
"movements": [
{
"name": "someName",
"state": "completed",
...
"quantities": [
{
"planned": "45445",
"uom": "xxx",
"moisture": "55656.99"
},
{
"actual": "5656.99",
"uom": "yyy",
"moisture": "3434"
},
{
"planned": "23424",
"uom": "ooo",
"moisture": "22323"
},
{
"actual": "678678678",
"uom": "dfd",
"moisture": "876867"
},
{
"gross": "22323",
"uom": "ghgh"
},
{
"net": "2323.99",
"uom": "dff"
}
],
...

however, this is the schema it shows me for quantities.
Any suggestions? thank you

259827-image.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,110 questions
{count} votes

Accepted answer
  1. Nasreen Akter 10,791 Reputation points
    2022-11-14T03:09:23.763+00:00

    Hi @arkiboys ,

    Thank you for the ask. I think the best way to load a dataset-schema is by creating a json-schema file with all the possible attributes in it and then load it. For the above example the json-schema file would be something like
    {
    "dv":"",
    "book":"",
    "movements":[
    {
    "name":"",
    "state":"",
    "quantities":[
    {
    "planned":"",
    "actual":"",
    "uom":"",
    "moisture":"",
    "gross":"",
    "net":""
    }]
    }]
    }

    Thanks!

    0 comments No comments

0 additional answers

Sort by: Most helpful