SQL Fails on LINQPAD NoSQL data

[tanthiamhuat]

I have this (https://imgur.com/cBwr366), which shows the result of the query.
But when I try this (https://imgur.com/fwCFuop)
, it fails, why?
The data is generated from this book, Guide to NoSQL with Azure Cosmos DB, page 42 for id=1 and pages 47-48 for id=2, which is available at
https://pdfs.semanticscholar.org/a575/7f6392e110b1250e7e0e21d82c0d08aa8adb.pdf

[conwid]

The images make reproducing the problem quite hard. Please simply paste the query as text, also the exact error message as text, and upload the data in json so that I can use the data migration tool to create the database and container (also would need the container's name).

[tanthiamhuat]

videogame1_01.json file:
{
"id": "1",
"name": "Battle Royale Kingdoms",
"lastCompetitionDate": "2018-09-29T04:36:22.7251173Z",
"tags": [
"mobile", "2D", "card game"
],
"levels": [
{
"title": "Training Camp for Dummies",
"towers": 2,
"towerPower": 30
},
{
"title": "Jungle Arena",
"towers": 2,
"towerPower": 40
},
{
"title": "Legendary World",
"towers": 5,
"towerPower": 100
}
],
"highestScores": [
{
"player":
{
"nickName": "Brandon in Wonderland",
"clan": "Wonderland Warriors"
},
"score": "750"
}
]
}

videogame1_02.json file:
{
"id": "2",
"name": "Fortnite vs Zombies",
"lastCompetitionDate": "2018-09-30T03:31:20.7251173Z",
"tags": [
"3D", "battle royale", "monsters", "shooter"
],
"platforms": [
"PS4", "XBox", "PC", "Switch", "iPad", "iPhone", "Android"
],
"levels": [
{
"title": "Dancing in the storm",
"maximumPlayers": 50,
"minimumExperienceLevel": 30
},
{
"title": "Rainbows after the storm",
"maximumPlayers": 30,
"minimumExperienceLevel": 60
},
{
"title": "The last of us",
"maximumPlayers": 10,
"minimumExperienceLevel": 100
}
],
"highestScores": [
{
"player":
{
"nickName": "PlaystationBoy",
"clan": "USA Players",
"experienceLevel": 140
},
"score": "5600"
},
{
"player":
{
"nickName": "KevinSwitchMan",
"clan": "Italian Warriors",
"experienceLevel": 125
},
"score": "3300"
}
]
}
The SQL query which fails is:
VideoGames1: SELECT * FROM VideoGames1
The container's name is Competition
The exact error message: One or more errors occurred.

[tanthiamhuat]

any updated information? Thanks.

[conwid]

Unfortunately I'm swamped with work, not sure when I'll have the time to look into this in more detail. I will check it out as soon as I can.