Rank: Member
Groups: Registered
Joined: 11/24/2017(UTC)
Posts: 12
|
Hi all, Not sure if I'm doing anything wrong but currently trying to use a web page JSON as a datasource for a live scores and player information in a live Pool tournament: https://api.cuescore.com/tournament/?id=11135416 but I'm only getting 1 line of information from the whole JSON (json1 attachment) Need to get the whole list with player names/image/scores from this. Then on the other hand I'm able to get all rows for the participant list from another JSON source (json2 attachement) : https://api.cuescore.com...ipants=Participants+list Not sure if there is anything wrong with the structure of the JSON data from json1, or vMix can't convert the data, or I am missing something. Tried using excel power query to pull the Json data from Json1 and I was able to retrieve the whole table  json1.PNG (18kb) downloaded 1 time(s). json2.PNG (37kb) downloaded 0 time(s).
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 11/23/2020(UTC) Posts: 154  Location: Wichita Thanks: 9 times
Was thanked: 21 time(s) in 17 post(s)
|
Originally Posted by: bar807  Hi all, Not sure if I'm doing anything wrong but currently trying to use a web page JSON as a datasource for a live scores and player information in a live Pool tournament: https://api.cuescore.com/tournament/?id=11135416 but I'm only getting 1 line of information from the whole JSON (json1 attachment) Need to get the whole list with player names/image/scores from this. Then on the other hand I'm able to get all rows for the participant list from another JSON source (json2 attachement) : https://api.cuescore.com...ipants=Participants+list Not sure if there is anything wrong with the structure of the JSON data from json1, or vMix can't convert the data, or I am missing something. Tried using excel power query to pull the Json data from Json1 and I was able to retrieve the whole table json1.PNG (18kb) downloaded 1 time(s). json2.PNG (37kb) downloaded 0 time(s). Have you tried using: https://devblogs.microso...w-system-text-json-apis/
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 12/27/2012(UTC) Posts: 5,088  Location: Belgium Thanks: 284 times
Was thanked: 920 time(s) in 759 post(s)
|
Help files:
JSON
This supports JSON data that is stored as an object array.
Each element in the array will be treated as a row.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 2/23/2017(UTC) Posts: 189  Thanks: 1 times
Was thanked: 52 time(s) in 42 post(s)
|
First JSON will never work straight in vMix, you need to reformat the data to follow the structure where your player object is inside the array as doggy pointed out. For example: [ { "name": "First Player",
"score1": "11",
"score2": "15" }, { "name": "Second Player",
"score1": "17",
"score2": "21" } ]
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 1/1/2016(UTC)
Posts: 7
Location: Gold Coast
|
Yeah, I have been doing this for 5 or 6 years, Pool 8 Ball scoreboard. actually doing the event + json scoreboard this weekend.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
Important Information:
The vMix Forums uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.
More Details
Close
