logo

Live Production Software Forums

www.vmix.com

Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
JSON data source not populating
Options
Go to last post Go to first unread
Previous Topic Next Topic
ALCVMixAxes  
#1 Posted : Sunday, June 16, 2024 7:36:16 AM(UTC)
ALCVMixAxes

Rank: Newbie

Groups: Registered
Joined: 6/16/2024(UTC)
Posts: 6
Canada
Location: ontario

Thanks: 1 times
Hello everyone,

I am creating a JSON Data Source, confirmed that there is data on the web page, however no data is being pulled through the Data Source Manager.

I can use other types of Data Sources (RSS, text, etc) and there are no issues pulling data in, it's only with the JSON.

Can anyone lead me in a direction to try and correct the issue? I'm a first time user of VMix so I don't know my way around well enough yet.

Thank you.
Back to top

Wanna join the discussion?! Login to your vMix Forums forum account, or Register a new forum account.
Back to top  
doggy  
#2 Posted : Sunday, June 16, 2024 8:04:35 AM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 5,216
Belgium
Location: Belgium

Thanks: 291 times
Was thanked: 955 time(s) in 790 post(s)
Originally Posted by: ALCVMixAxes Go to Quoted Post
Hello everyone,

I am creating a JSON Data Source, confirmed that there is data on the web page, however no data is being pulled through the Data Source Manager.

I can use other types of Data Sources (RSS, text, etc) and there are no issues pulling data in, it's only with the JSON.

Can anyone lead me in a direction to try and correct the issue? I'm a first time user of VMix so I don't know my way around well enough yet.

Thank you.


Check the helpfiles https://www.vmix.com/help27/DataSourcesTypes.html

JSON
This supports JSON data that is stored as an object array.
Each element in the array will be treated as a row.
Back to top
ALCVMixAxes  
#3 Posted : Sunday, June 16, 2024 8:08:39 AM(UTC)
ALCVMixAxes

Rank: Newbie

Groups: Registered
Joined: 6/16/2024(UTC)
Posts: 6
Canada
Location: ontario

Thanks: 1 times
Unfortunately that's no help.

I have no issue connecting to this source on my laptop copy of VMix, it's just on my production computer that I can't get the data to pull through. I don't know if there is a setting somewhere in the software that's blocking it?
Back to top
ALCVMixAxes  
#4 Posted : Sunday, June 16, 2024 8:11:54 AM(UTC)
ALCVMixAxes

Rank: Newbie

Groups: Registered
Joined: 6/16/2024(UTC)
Posts: 6
Canada
Location: ontario

Thanks: 1 times
Originally Posted by: ALCVMixAxes Go to Quoted Post
Unfortunately that's no help.

I have no issue connecting to this source on my laptop copy of VMix, it's just on my production computer that I can't get the data to pull through. I don't know if there is a setting somewhere in the software that's blocking it?


To be clear, the production computer is connected to the internet, I can pull other internet based data sources (RSS feed), the API address for the JSON has data I can see in a web browser, it just won't pull through when I set up the Data Source via the Manager
Back to top
doggy  
#5 Posted : Sunday, June 16, 2024 8:18:30 AM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 5,216
Belgium
Location: Belgium

Thanks: 291 times
Was thanked: 955 time(s) in 790 post(s)
Originally Posted by: ALCVMixAxes Go to Quoted Post
Originally Posted by: ALCVMixAxes Go to Quoted Post
Unfortunately that's no help.

I have no issue connecting to this source on my laptop copy of VMix, it's just on my production computer that I can't get the data to pull through. I don't know if there is a setting somewhere in the software that's blocking it?


To be clear, the production computer is connected to the internet, I can pull other internet based data sources (RSS feed), the API address for the JSON has data I can see in a web browser, it just won't pull through when I set up the Data Source via the Manager



Again: JSON data that is stored as an object array.

it wont pull properly if it doesnt contain a object array

Maybe post an example of the json file else one is only guessing
Back to top
ALCVMixAxes  
#6 Posted : Sunday, June 16, 2024 8:22:03 AM(UTC)
ALCVMixAxes

Rank: Newbie

Groups: Registered
Joined: 6/16/2024(UTC)
Posts: 6
Canada
Location: ontario

Thanks: 1 times
This is the site I'm using:

https://api.axescores.co...24-WilsonCup/orange/left

The website returns this string:

{"players":{"left":{"name":"Austin Agosti","roundsWon":3,"roundScore":25.0,"throws":{"1":{"label":"1","value":"5","clutch":false},"2":{"label":"2","value":"5","clutch":false},"3":{"label":"3","value":"5","clutch":false},"4":{"label":"4","value":"5","clutch":false},"5":{"label":"5","value":"5","clutch":false}},"bigAxes":null},"right":{"name":"Adrian Gagnon","roundsWon":0,"roundScore":18.0,"throws":{"1":{"label":"1","value":"5","clutch":false},"2":{"label":"2","value":"5","clutch":false},"3":{"label":"3","value":"3","clutch":false},"4":{"label":"4","value":"5","clutch":false},"5":{"label":"5","value":"0","clutch":true}},"bigAxes":null}}}
Back to top
ALCVMixAxes  
#7 Posted : Sunday, June 16, 2024 8:50:53 AM(UTC)
ALCVMixAxes

Rank: Newbie

Groups: Registered
Joined: 6/16/2024(UTC)
Posts: 6
Canada
Location: ontario

Thanks: 1 times
this is the web address I'm pulling from:

https://api.axescores.co...24-WilsonCup/orange/left

The data string in the web browser is:

{"players":{"left":{"name":"Austin Agosti","roundsWon":3,"roundScore":25.0,"throws":{"1":{"label":"1","value":"5","clutch":false},"2":{"label":"2","value":"5","clutch":false},"3":{"label":"3","value":"5","clutch":false},"4":{"label":"4","value":"5","clutch":false},"5":{"label":"5","value":"5","clutch":false}},"bigAxes":null},"right":{"name":"Adrian Gagnon","roundsWon":0,"roundScore":18.0,"throws":{"1":{"label":"1","value":"5","clutch":false},"2":{"label":"2","value":"5","clutch":false},"3":{"label":"3","value":"3","clutch":false},"4":{"label":"4","value":"5","clutch":false},"5":{"label":"5","value":"0","clutch":true}},"bigAxes":null}}}
Back to top
doggy  
#8 Posted : Sunday, June 16, 2024 9:31:20 AM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 5,216
Belgium
Location: Belgium

Thanks: 291 times
Was thanked: 955 time(s) in 790 post(s)
Originally Posted by: ALCVMixAxes Go to Quoted Post
this is the web address I'm pulling from:

https://api.axescores.co...24-WilsonCup/orange/left

The data string in the web browser is:

{"players":{"left":{"name":"Austin Agosti","roundsWon":3,"roundScore":25.0,"throws":{"1":{"label":"1","value":"5","clutch":false},"2":{"label":"2","value":"5","clutch":false},"3":{"label":"3","value":"5","clutch":false},"4":{"label":"4","value":"5","clutch":false},"5":{"label":"5","value":"5","clutch":false}},"bigAxes":null},"right":{"name":"Adrian Gagnon","roundsWon":0,"roundScore":18.0,"throws":{"1":{"label":"1","value":"5","clutch":false},"2":{"label":"2","value":"5","clutch":false},"3":{"label":"3","value":"3","clutch":false},"4":{"label":"4","value":"5","clutch":false},"5":{"label":"5","value":"0","clutch":true}},"bigAxes":null}}}


Exactly as mentioned before, there is no array
Json Arrays are enclosed with [ ]
see google search for "json array"

if you are ok with the fact all this data is in one row try the folowing script
Code:
Dim thesource As String = New System.Net.WebClient().DownloadString("https://api.axescores.com/stream/2024-WilsonCup/orange/left")
thesource = "[" & thesource & "]"
System.IO.File.WriteAllText("D:/Test.json", text)

and load the Test.json file as your json datasource
Back to top
thanks 1 user thanked doggy for this useful post.
ALCVMixAxes on 6/16/2024(UTC)
ALCVMixAxes  
#9 Posted : Sunday, June 16, 2024 9:41:24 AM(UTC)
ALCVMixAxes

Rank: Newbie

Groups: Registered
Joined: 6/16/2024(UTC)
Posts: 6
Canada
Location: ontario

Thanks: 1 times
Thank you for this, I'll give it a try.

There must have been that small difference when I was testing with an older link and didn't have the problem.
Back to top
Users browsing this topic
Guest
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.

Privacy Policy | Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET
This page was generated in 0.177 seconds.