Remote Dataset - how to create a dynamic Ticker (complex)

CMS Version

2.3.10

Im considering retrofitting an existing network from an old Signage platform to xibo on my self hosted one.
the current platform has a Stock ticker from XML (Or JSON)
image

the % Value color should be determine by scripting (if value < 0 - paint it red, ect)
the arrow is either “green up” or “red down” also by the same scripting.
(still haven’t got to the layout yet and how to create it)

i started to setup remote dateset from JSON in order to create dataset ticker

the JSON:

{
  "Table": {
    "-AsOfDate": "2022-03-15T17:55:24.1785078+02:00",
    "Security": [
      {
        "-Key": "767012",
        "BaseRate": "3790",
        "BaseRateChange": "53",
        "TradingStage": "E",
        "HebName": "הפניקס",
        "LastDealRate": "3843",
        "BuyLimit1": "3843",
        "SellLimit1": "3849",
        "YesterdayYield": "4.52",
        "AllMonthYield": "1.53",
        "BeginOfYearYield": "-5.79",
        "MinusOneYearYield": "76.97"
      },
      {
        "-Key": "224014",
        "BaseRate": "6925",
        "BaseRateChange": "-145",
        "TradingStage": "E",
        "HebName": "כלל עסקי ביטוח",
        "LastDealRate": "6780",
        "BuyLimit1": "6757",
        "SellLimit1": "6780",
        "YesterdayYield": "3.67",
        "AllMonthYield": "-4.11",
        "BeginOfYearYield": "-13.22",
        "MinusOneYearYield": "59.03"
      },
      {
        "-Key": "1081165",
        "BaseRate": "520.4",
        "BaseRateChange": "13.7",
        "TradingStage": "E",
        "HebName": "מגדל ביטוח",
        "LastDealRate": "534.1",
        "BuyLimit1": "531",
        "SellLimit1": "534.1",
        "YesterdayYield": "4.29",
        "AllMonthYield": "-6.23",
        "BeginOfYearYield": "1.42",
        "MinusOneYearYield": "39.86"
      },
      {
        "-Key": "566018",
        "BaseRate": "6850",
        "BaseRateChange": "344",
        "TradingStage": "E",
        "HebName": "מנורה מב החז",
        "LastDealRate": "7194",
        "BuyLimit1": "7195",
        "SellLimit1": "7197",
        "YesterdayYield": "1.66",
        "AllMonthYield": "-9.76",
        "BeginOfYearYield": "-6.95",
        "MinusOneYearYield": "49.14"
      },
      {
        "-Key": "585018",
        "BaseRate": "3616",
        "BaseRateChange": "83",
        "TradingStage": "E",
        "HebName": "הראל השקעות",
        "LastDealRate": "3699",
        "BuyLimit1": "3691",
        "SellLimit1": "3699",
        "YesterdayYield": "4.36",
        "AllMonthYield": "-0.71",
        "BeginOfYearYield": "2.32",
        "MinusOneYearYield": "25.73"
      },
      {
        "-Key": "1129501",
        "BaseRate": "10300",
        "BaseRateChange": "-70",
        "TradingStage": "E",
        "HebName": "איידיאיי ביטוח",
        "LastDealRate": "10230",
        "BuyLimit1": "10220",
        "SellLimit1": "10230",
        "YesterdayYield": "0",
        "AllMonthYield": "-7.71",
        "BeginOfYearYield": "-9.25",
        "MinusOneYearYield": "27.63"
      }
    ]
  }
}

the “-AsOfDate” key - if to old = don’t show the ticker (or show something else)
and i need to extract 3 keys from Security array:
“BaseRate”
“HebName”
“YesterdayYield”

I have set the Dataset root to “Table”
and added columns for the Date, and Name(first key)
image

image

However, i think using the following Path, it the remote fetch should import all 6 keys under security into rows
as i need to setup a ticker, so using different Name1, Name2 … Name6 columns doesn’t make sense…

image

the Security.*.HebName doesn’t seems to fetch anything…

Help is much appreciated from however setup remote dataset…

[EDIT]
by Using Table.Security as Root for the dataset, i was able to fetch ,
but i don’t have access for the “AsOfDate” element anymore as its outside the root…

1 Like

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.