Hello everybody,

I have to get the data from a .json file in stata. I have been using the following command:

Code:
insheetjson  classes ID Name Address PostCode City District State Telephone using "C:\Users\marius.kaltenbach\Desktop\outfile_A_230102.json",col( "classes" "ID" "Name" "Address" "PostCode" "City" "District" "State" "Telephone")
Before executing the command I generates all variables as strings.

The commandline was successfully executed but only one Observation was submitted and I don't know what happened to the rest. I am no expert regarding json (and the insheetjson command), so it is possible that I made a trivial mistake somewhere.

Here is a small part of the .json File, maybe that is helpful.

Thanks!

Code:
{
    "classes": [
        {
            "students": [
                {
                    "assessments": [
                        {
                            "TestRules": [
                                {
                                    "TestID": "0",
                                    "Invoke": "0",
                                    "Complete": "1",
                                    "Skip": "0"
                                },
                                {
                                    "TestID": "1",
                                    "Invoke": "1",
                                    "Complete": "0",
                                    "Skip": "0"
                                },
                                {
                                    "TestID": "2",
                                    "Invoke": "0",
                                    "Complete": "0",
                                    "Skip": "1"
                                },
                                {
                                    "TestID": "3",
                                    "Invoke": "0",
                                    "Complete": "1",
                                    "Skip": "0"
                                },
                                {
                                    "TestID": "4",
                                    "Invoke": "0",
                                    "Complete": "1",
                                    "Skip": "0"
                                },
                                      
.........
                    },
                    "IsDAZ": null,
                    "AnonID": "99999999-30",
                    "FirstName": "",
                    "FamilyName": "",
                    "DateOfBirth": "",
                    "Gender": null
                }
            ],
            "ID": {
                "value": "30272b9e-701f-11e9-9452-5314d1816c29"
            },
            "Name": "999999",
            "Notes": ""
        }
    ],
    "ID": 0,
    "Name": "Test School",
    "Address": "",
    "PostCode": "",
    "City": "",
    "District": "",
    "State": "",
    "Telephone": ""
}