Creating a Dataset from at JSON Feed - Not Working

To be completed by the original poster:

CMS Version: Xibo CMS via web

Player Type: DSCS95

Player Version: Xibo for Android v4 R406

Issue

Hi, I am trying to create a dataset from a JSON feed.
https://glendaleaz.librarycalendar.com/events/feed/json. I want to use it to create a widget to pull upcoming events from my library’s calendar.

The calendar widgets won’t display the location properly, reverting to the address, not the name of the library.

I followed the steps in the guide but I get the message “No Data Available in Table”. I’ve tried troubleshooting and something must be wrong in my configuration, but I can’t find the error.

Also, if possible, I’d like to pull events 3 weeks out from the current date.

Rather than posting the json, I recommend viewing it at JSON Parser Online to parse JSON. It is very long.

Here are screenshots of my configuration. Any and all help is appreciated.



Thank you!

Merideth

Hello!

Thanks for sharing your question. I took a look at your screenshots, but the image quality makes it a bit difficult to read. If you could share them again in higher resolution or provide additional details about your configuration, that would be great.

I ran some tests with your JSON feed, and it’s pulling the content correctly. The connection and data extraction seem fine. Now we just need to understand exactly what information you want to use for processing and ensure the events are displayed as expected.

If you could clarify a bit more about how you’d like to present the events or which specific data you want to highlight.

Looking forward to hearing from you! :blush:

Thank you for responding!

What I would like to do with the data set is pull events from the calendar at glendaleaz.librarycalendar.com to create a “Coming Soon” layout.

Here are the screenshots, hopefully they are easier to read -

In case those don’t come through,

In the Remote tab, I have the method set to GET and the URL is
https://glendaleaz.librarycalendar.com/events/feed/json

In the Data tab, I have
Source: JSON
Data root: DATE (because I believe there is no name for the array?)
Aggregation: None

If you have more questions, I’m happy to answer!

Thanks,
Merideth

Hello, Merideth!

I successfully extracted the data, and here are the screenshots of the sequence.

The first screens show the original raw data, while screen 6 displays the selected data, now processed and properly formatted.

If you need any further information or adjustments, feel free to reach out!





Hi!

Thank you, I set it up following your screenshots, and I get the following message when I test the URL

"Unable to get Data for JSON Events Feed because Server error: GET https://glendaleaz.librarycalendar.com/events/feed/json resulted in a 502 Bad Gateway response:\n\r\n502 Bad Gateway\r\n\r\n

502 Bad Gateway

\r\n
ngin (truncated…)\n.

Am I right in thinking that’s a problem on the end of my vendor?

Thanks,

Merideth

json link works fine, are you connecting over proxy ?

This message also appears here, but just wait about 20 seconds, and the result will be displayed.
The “502 Bad Gateway” error usually indicates a problem with the provider’s server. It may be temporary, so just wait a few seconds, and you will receive the result.

Here is the screenshot of the extracted result.

No, I’m not using a proxy. I’m only using a dedicated server for the connection.

i was refering to this nginx 502 Bad Gateway, bad proxy configuration?

Hi,

Thank you again for your help. I don’t think I am using a Proxy, I am on my City network.

When I test the data URL I get the screen below

what is your result on:

  1. ping server
  2. try wget/curl file
  3. open it in browser

Hello,

  1. ping server - Ping server, ping website : Check host - online website monitoring
  2. I’m not sure what that is :slight_smile:
  3. It opens in Edge but I get the bad gateway message in Chrome

On the CMS I get this message -

so disband chrome, use edge

this is not xibo problem, learn proxys on your networks