Json file not read properly

[PaulvT]

Can somebody help me.

I try to load following json into XIBO

(this is the result I copy from XIBO when he reads the json file)

{
   "entries": [
      {
         "status": 200,
         "message": "success",
         "data": {
            "total": 178,
            "employees": [
               {
                  "id": "183",
                  "nummer": "_0304044074",
                  "tag": "",
                  "voornaam": "FirstName",
                  "tussenvoegsel": "MiddleName",
                  "achternaam": "LastName",
                  "email": "xxxxxx@sample.com",
                  "sms": "+31600000000",
                  "telefoon": "+31600000000",
                  "status": "out",
                  "department_id": "14",
                  "BHV": "false"
               },
               {
                  "id": "1",
                  "nummer": "_0324979963",
                  "tag": "",
                  "voornaam": "FirstName",
                  "tussenvoegsel": "MiddleName",
                  "achternaam": "LastName",
                  "email": "xxxxxx@sample.com",
                  "sms": "+31600000000",
                  "telefoon": "+31600000000",
                  "status": "out",
                  "department_id": "14",
                  "BHV": "false"
               },
               {
                  "id": "174",
                  "nummer": "_0464885984",
                  "tag": "",
                  "voornaam": "FirstName",
                  "tussenvoegsel": "MiddleName",
                  "achternaam": "LastName",
                  "email": "xxxxxx@sample.com",
                  "sms": "+31600000000",
                  "telefoon": "+31600000000",
                  "status": "out",
                  "department_id": "14",
                  "BHV": "false"
               },
               {
                  "id": "3",
                  "nummer": "_0471210092",
                  "tag": "BHV=1",
                  "voornaam": "FirstName",
                  "tussenvoegsel": "MiddleName",
                  "achternaam": "LastName",
                  "email": "xxxxxx@sample.com",
                  "sms": "+31600000000",
                  "telefoon": "+31600000000",
                  "status": "out",
                  "department_id": "14",
                  "BHV": "false"
               }
            ]
         }
      }
   ],
   "number": 1,
   "processed": [
      [
         [],
         []
      ]
   ],
   "messages": [
      "Processing 1 results into 4 potential columns",
      "Processing Result with Data Root data",
      "DataRoot is an object",
      "Processing as Multiple Rows",
      "Processing total",
      "Processing employees",
      "Consolidating entries",
      "There are 2 entries in total"
   ]
}

I’ve validated this data with https://jsonlint.com/ and it passes.

If i do not fill in a data root the json file is fetched, and read.

The part I need is the “employees” part. If I fill in employees as data root

The error is “No data found at the DataRoot employees”.

If the json is valid, what do I do wrong?
XIBO version
Xibo Digital Signage - www.xibo.org.uk. Version 2.3.17

[Frazer]

Hi @PaulvT and welcome to the Xibo Community!

Please can you try entering the following as the data root:

data.employees

Note the dot (full stop) between data and employees.

Please let me know if this does not work.

[PaulvT]

Hi Frazer,

Thank you for your answer, that I did not try this myself
I tried some other ones.

But this works thank you. (see result).

"messages": [
      "Processing 1 results into 4 potential columns",
      "Processing Result with Data Root data.employees",
      "DataRoot is an array",
      "Processing 0",
      "Processing 1",
      "Processing 2",
      "Processing 3",
      "Processing 4",
..............
      "Consolidating entries",
      "There are 178 entries in total"
   ]

Maybe you can also help me with the next problem I run into.
If I add al column.

It is created twice.

And then if I want to view the data.

If I remove the first of the second column both are deleted.