Graphics

 View Only
  • 1.  How to auto-populate a Text Object Combobox from JSON

    Posted 09-22-2025 00:00

    I have a JSON schedule feeding in through the JSON DataLinq provider. It's an array of game objects, and each row includes a startDateTime. I want a text object in my scene to act as a Combobox (User Input Control) that automatically lists every startDateTime from that feed. When the operator picks one, I want the rest of the scene's DataLinq-bound objects to filter to that row via Keys-basically the same operator flow as the Ross University "Text Object Macro to select games" tutorial, but using startDateTime as the key instead of a game ID.

    Where I'm stuck is the purely "native" wiring. I can point the text object at the JSON DataLinq source and open "Assign Columns…", but the Combobox still wants a single Column to populate the list. In my feed, the games live under an array (e.g., "data"), and the provider exposes them as data, data<2>, data<3>, etc.-so I don't see startDateTime presented as one flat column I can select for the list. My understanding is that "Assign Columns…" only maps what gets published/returned from the selected row; it doesn't actually populate the list by itself. So I think I need the JSON provider configured so the array is treated as the table root and startDateTime shows up as a proper column the Combobox can iterate. If that's the intended setup, what's the exact native configuration in the JSON DataLinq dialog to achieve it (i.e., selecting the correct Record/Array node so startDateTime appears once in the Columns list)?

    Anyone who has achieved this, I would love your input. 

    Here is an example schedule that we use. I cannot upload the JSON, here is a link to the JSON structure. 
    Untitled

    Pastecode remove preview
    Untitled
    "data": [ { "eventId": "EVT-001", "seasonId": "2y7cnq64hj4oszlt", "sportId": "wvball", "teams": { "homeTeam": { "apiAccess": [ "READ" ], "teamId": "xmua8potz3savyhl", "teamName": "School 1", "seasonId": "2y7cnq64hj4oszlt", "season": { "seasonId": "2y7cnq64hj4oszlt", "seasonName": "NAIA Women's Volleyball 2025-26", "startDate": "2025-07-01T04:00:00", "endDate": "2026-06-30T04:00:00", "sport": { "sportId": "wvball", "sportName": "Women's Volleyball", "statcode": 4 }, "organization": { "id":
    View this on Pastecode >


    ------------------------------
    Jonathan Peters
    Team Lead & Broadcast Engineer
    Forester Digital Network
    ------------------------------



  • 2.  RE: How to auto-populate a Text Object Combobox from JSON

    Posted 09-22-2025 00:30

    Here is an example schedule that we use. I cannot upload the JSON, here is a link to the JSON structure. 

    https://pastecode.io/s/t615ha21



    ------------------------------
    Jonathan Peters
    Team Lead & Broadcast Engineer
    Forester Digital Network
    ------------------------------



  • 3.  RE: How to auto-populate a Text Object Combobox from JSON
    Best Answer

    Posted 09-23-2025 09:04

    Hello Jonathan,

    Unfortunately, user input controls do not currently support nodal data structures, so the only option for populating them from Datalinq would be sources that are parsed as columns and rows like databases and Text files.



    ------------------------------
    Andrew Sampson
    Ross Video
    ------------------------------



  • 4.  RE: How to auto-populate a Text Object Combobox from JSON

    Posted 09-24-2025 02:11

    Hey Andrew,

    Thanks for getting back to me. I assumed this was the issue. Have you seen workflows that get around this- Maybe with VBA scripting or external code? I'm looking for a workflow that can benefit us. I am thinking about writing a simple Python script that parses our current JSON and extracts the startDateTime into a file.



    ------------------------------
    Jonathan Peters
    Team Lead & Broadcast Engineer
    Forester Digital Network
    ------------------------------