Wrap your output into an array. E.g. [...]

I am also looking for help with JSON as a datasource.

A web query of the JSON source looks like this ( well a lot more data but in this format):

{"SiteKit":{"Parameters":{"feed":"modulekit","view":"roster","key":"xxxxxxxxxxxx","fmt":"json","client_code":"cchl","lang":"en","season_id":0,"team_id":"7","lang_id":1,"league_id":"1"},"Roster":[{"id":"5902","person_id":"6732","active":"1","first_name":"Antoine","last_name":"Bourdeau","phonetic_name":"","display_name":"","shoots":"L","catches":"L","hometown":"Montreal, QC","homeprov":"","homecntry":"Canada","homeplace":"Montreal, QC, Canada","birthtown":"Montreal, QC","birthprov":"","birthcntry":"Canada","birthplace":"Montreal, QC, ","height":"6-0","weight":"193","height_hyphenated":"6-0","hidden":"0","current_team":"","player_id":"5902","status":"","birthdate":"2000-02-14","birthdate_year":"'00","rawbirthdate":"2000-02-14","latest_team_id":"7","tp_jersey_number":"1","rookie":"0","position_id":"7","position":"G","nhlteam":"","playerId":"5902","isRookie":" ","h":"6-0","w":"193","draftinfo":[],"name":"Antoine Bourdeau","flags":[],"player_image":"https:\/\/assets.leaguestat.com\/cchl\/240x240\/5902.jpg"},{"id":"5899","person_id":"6729","active":"1","first_name":"Mathieu","last_name":"Wuth","phonetic_name":"","display_name":"","shoots":"R","hometown":"Broomfield, CO","homeprov":"","homecntry":"USA","homeplace":"Broomfield, CO, USA","birthtown":"Broomfield, CO","birthprov":"","birthcntry":"USA","birthplace":"Broomfield, CO, ","height":"6-2","weight":"174","height_hyphenated":"6-2","hidden":"0","current_team":"","player_id":"5899","status":"","birthdate":"2000-06-01","birthdate_year":"'00","rawbirthdate":"2000-06-01","latest_team_id":"7","tp_jersey_number":"5","rookie":"0","position_id":"1","position":"D","nhlteam":"","playerId":"5899","isRookie":" ","h":"6-2","w":"174","draftinfo":[],"name":"Mathieu Wuth","flags":[],"player_image":false},

29 more player sets of data then finishes

{"id":"18206","first_name":"Brooks","last_name":"Taylor","name":"Brooks Taylor","coach_id":"490","role_id":"16","role":"Equipment Manager","person_id":"6069","hometown":"","homeprov":"","jersey_number":"0","start_date":"2019-03-16","end_date":"","is_admin":"0"}]],"Copyright":{"required_copyright":"Official statistics provided by Leaguestat","required_link":"http:\/\/leaguestat.com","powered_by":"Powered by HockeyTech.com","powered_by_url":"http:\/\/hockeytech.com"}}}

When vMIX tries to read this data source it generates the message:

ERROR: A column named "id" already belongs to this Data Table

Is my data source corrupted ? or .......

Thanks

Whit

Hi Burie - I was having a similar issue "Encountered unexpected character '<'" - when adding a JSON source.

Did the suggestion fix your issue?

DAMN you're right. My fault. I have a apache running behind, but called the PHP File the wrong way. E:\_Data is the localhost folder.
I will try it ASAP, I'm not near this PC.

On another thread I got a good hint for a solution with PHP and XML. Until the end I had used to the output return (), how to do that with PHP functions. But since I use echo for the output instead, this works. Maybe that's an approach as well.