Remote dataset no columm value

Get Help
1

Hi,
i have in Xibo an remote datset. this dataset should get the birthdate of employee’s, and push that to a layout.
when i go to edit the dataset to test the data, i get the following result:

{
   "entries": [
      {
         "lastUpdated": "2024-09-30 09:31:07",
         "employees": [
            {
               "fullName": "employee name",
               "firstName": "employee first name",
               "lastName": "employee last name",
               "avatar": "https://storage.googleapis.com/shiftbase-avatars/avatars/user-picture_150x200.png"
            },
            {
               "fullName": "employee name",
               "firstName": "employee first name",
               "lastName": "employee last name",
               "avatar": "https://storage.googleapis.com/shiftbase-avatars/avatars/user-picture_150x200.png"
            }
         ]
      }
   ],
   "number": 2,
   "isEligibleToTruncate": true,
   "processed": [
      [
         [],
         []
      ]
   ],
   "messages": [
      "Processing 1 results into 1 potential columns",
      "Processing Result with Data Root employees",
      "DataRoot is an array",
      "Processing 0",
      "Processing 1",
      "Consolidating entries",
      "There are 2 entries in total"
   ]
}

now when i view the data within the dataset, it says that the collum is empty.
can anyone please help me?

image
image1118×1192 45.9 KB

2024-09-30 11_42_29-Window(dataset2)
2024-09-30 11_42_29-Window(dataset2)3241×1184 33.4 KB

2

The column type is set to remote?

IMG_20240930_042600
IMG_20240930_0426001080×308 26.4 KB

3

Jupp, these are my columm settings.

image
image942×878 25.9 KB

4

The remote data path should be the JSON path, not the url.

5

also does not work.
i tried copying settings from a remote dataset that works, tried every logical JSON path, but it still does not work.
or it could be possible that i dont exactly know what they mean with JSON path.

image
image977×922 26.6 KB

6

Dataroot is where you want xibo to start getting the data,

So if you have :

{
“firstName”: “John”,
“lastName”: “doe”,
“age”: 26,
“address”: {
“streetAddress”: “naist street”,
“city”: “Nara”,
“postalCode”: “630-0192”
},
“phoneNumbers”: [
{
“type”: “iPhone”,
“number”: “0123-4567-8888”
},
{
“type”: “home”,
“number”: “0123-4567-8910”
}
]
}

Your JSON path to get iPhone is:
$.phoneNumbers[:1].type

To the path for home is:
$.phoneNumbers[:2].type

The path for all instances of type

$.phoneNumbers[:].type

What xibo wants to know is what column to match up with what variable(s) in your list.

This eg might be different for what you are trying to achieve but the JSON path is similar to your select xmlnode but the idea is to pick your dataroot, assgn the columns path value accordingly

1 Like