Remote Dataset CSV Import Issue - "No data available in table"

[Coen_Deurloo]

Xibo Version: 4.2.3 Server OS: Unraid

Problem Description

I’m trying to set up a remote dataset that pulls data from a Google Sheets CSV, but while the “Test data URL” shows correct data, the dataset remains empty when viewing “View Data”.

Configuration Details

Remote Dataset Settings:

• Method: GET

• Source: CSV

• URI: Google Sheets published CSV URL (ending with &output=csv)

• Authentication: Empty (public sheet)

Test Data URL Output (working correctly):

json

{
   "entries": [
      [
         "9-9-2025 14:21:57",
         "Dit moet op het scherm komen te staan"
      ]
   ],
   "number": 1,
   "isEligibleToTruncate": true,
   "processed": [
      []
   ]
}

Column Configuration:

• Heading: “Tekst”

• Column Type: Remote

• Data Type: String

• Remote Data Path: 1 (trying to get the second column from entries array)

The Issue

1. Test Data URL works perfectly - shows the expected CSV data structure

2. View Data shows “No data available in table” - dataset appears empty

3. Manual CSV upload works fine - when I download the same CSV and upload manually, data appears correctly

4. Processed array is empty - in the test data URL output, the “processed” section shows [] instead of the expected column data

What I’ve Tried

• Different Remote Data Path values (0, 1, 2)

• Various column configurations

• Checked Authentication tab (left empty for public sheet)

• Verified refresh settings (set to “constantly”)

• Confirmed the Google Sheets CSV URL is publicly accessible

Questions

1. Why does the “processed” array remain empty when the “entries” array contains the correct data?

2. Is there a specific configuration needed for Google Sheets CSV URLs?

3. Are there any logs I can check to see what’s happening during the remote data sync?

4. Could this be related to CSV parsing settings or data root configuration?

The manual CSV upload works perfectly with the same data, so the issue seems specific to the remote dataset functionality.

Any help would be greatly appreciated!

Additional Info

• Google Form automatically creates responses in Google Sheets

• Goal is to have form responses automatically appear in Xibo layouts

• The CSV structure is simple: timestamp in column A, text message in column B

• Same CSV works when uploaded manually but not when fetched remotely

[Coen_Deurloo]

Follow-up / additional testing results

Just to follow up on my original post: I wanted to rule out whether this was only a Google Sheets CSV parsing problem, so I built my own feed using a Cloudflare Worker + KV storage.

The Worker publishes a very simple JSON array at /latest, for example:

[
  {
    "Tekst": "This should appear on screen",
    "updated": "2025-09-10T10:14:17.064Z"
  }
]

Xibo Remote Dataset configuration:

• Method: GET

• Source: JSON

• Data root: (left empty, since the top-level is already an array of objects)

• Test Data URL: shows the entries and even the processed arrays populated with the expected data.

Columns configured:

• Column Heading: Tekst

• Column Type: Remote

• Data Type: String

• Remote Data Path: Tekst

Problem:

• Test data URL shows correct data, and the processed array contains the text.

• View Data remains empty (“No data available in table”), even after Run Now.

• This is exactly the same behavior I saw with the Google Sheets CSV approach.

• Uploading the same data manually as a CSV works fine — so the issue seems specific to Remote Datasets.

Conclusion so far:
This doesn’t seem to be limited to Google Sheets; it looks like Remote Datasets (CSV and JSON) are not actually persisting the processed data into the dataset.

Questions:

• Is this a known bug with Remote Datasets?

• Are there any additional configuration steps required for JSON arrays of objects like the above?

• Is there a way to enable extra logging to see why the processed data isn’t written into the dataset rows?

Any guidance would be greatly appreciated!