External JSON Dataset import problems

[pieter123]

CMS Version

4.0.4

Issue

Hello,
i’m struggeling now for a few days to get the Jason output below imported to a dataset
the URL works when i create the dataset, the data gets pulled from the server. but when i try to create the columns i do not get the data.
i tried several different JSON paths, but my knowledge of Json is just to little to debug this.

what would be the right datapath to the ‘entries’ data, the data below that is not relevant but included because then the file would be complete.

any help would be appreciated! thanks in advance

{
   "entries": [
      [
         {
            "id": 6190,
            "court_id": 8,
            "court_name": "edit",
            "starttime": "18:30:00",
            "endtime": "22:30:00",
            "company": "edit",
            "firstname": "edit",
            "lastname": "edit"
         },
         {
            "id": 5277,
            "court_id": 6,
            "court_name": "edit",
            "starttime": "19:00:00",
            "endtime": "22:00:00",
            "company": edit,
            "firstname": "edit",
            "lastname": "edit"
         },
         {
            "id": 4484,
            "court_id": 1,
            "court_name": "edit",
            "starttime": "19:30:00",
            "endtime": "20:30:00",
            "company": "edit",
            "firstname": "edit",
            "lastname": "edit"
         }
      ]
   ],
   "number": 3,
   "isEligibleToTruncate": true,
   "processed": [
      [
         [],
         [],
         []
      ]
   ],
   "messages": [
      "Verwerking van 1 resulteert in 1 potentiële kolommen",
      "Verwerkingsresultaat met Data Root ",
      "DataRoot is an array",
      "Processing 0",
      "Processing 1",
      "Processing 2",
      "Invoer consolideren",
      "Er zijn 3 items in totaal"
   ]
}

[Jon_Knowles]

I had an issue where the web service was returning my json as application/octet-stream instead of application/json

The dataset would fetch very strangely and I also had column matching issues.

Despite the body of the response looking identical, it wasn’t until the response was changed to application/json that the dataset worked properly.

I hope this helps.

[pieter123]

Hey, thanks for the reply,
I checked the content type using the developer tools in Chrome and it comes back as Content-Type: application/json.
I think that i’m messing up the path because if i check other sources the brackets and so are different. but my JSON skils are not good enough to debug that.

[pieter123]

yeah
fixed it using this post : Remote Dataset - Trouble configuring Remote Data Path - #7 by Peter

for 1 i did not know that the data only gets processed every hour, so i changed the variables way to soon, now i could manually start the import every time i changed a variable.