DataSet from json error

Hello,

I try to remote a simple data information from a json URL which return this content.

image

Here is my database configuration




When i test the data URL the result i get is this one

{
   "entries": [
      [
         {
            "json_featuretype": "OPS_V2.OPS_INTER",
            "NbInter": "2161"
         }
      ]
   ],
   "number": 1,
   "processed": [
      [
         []
      ]
   ],
   "messages": [
      "Processing 1 results into 1 potential columns",
      "Processing Result with Data Root ",
      "DataRoot is an array",
      "Processing 0",
      "Consolidating entries",
      "There are 1 entries in total"
   ]
}

Then i configure the colum with that parameters

I don’t know what is wrong in my configuration.

For information i don’t realy master the json format and request.

Best regards,

Hi sdis35

I have about 7 remote datasets on my Xibo, all being created from Json files which are in turn created in Excel VBA to export live excel data into Xibo. To me, I would say it looks like you need to specify a data root (or starting point in your json output) for Xibo to be able to populate your colums correctly. I had to add some extra lines into my VBA in order to create a data root within my Json output, for Xibo to use the data correctly.

I will try and show you what I mean.

So my data root on my dataset is Xibo but it can be anything you want :

image

Then with the extra code within my Excel VBA, my raw json datafile has the following structure :

image

And when I click the Test Data URL button, I get the following structure :

with confirmation at the bottom :

Once this dataroot field is within the json output file and youve programmed your columns to match the data, it should work fine. I might be wrong on this completely though but it looks to me like the missing dataroot is the problem you are having.

Jimbo

1 Like