Imports System

Imports System.Linq

Imports System.Collections

Imports System.Collections.Generic

Imports System.Data

Imports System.IO

Imports System.Globalization

Imports System.Reflection

Imports System.ComponentModel.DataAnnotations

Imports System.Xml.Linq

Imports System.Xml

​

Imports Newtonsoft.Json

Imports Newtonsoft.Json.Linq

Imports Newtonsoft.Json.Converters

Imports Newtonsoft.Json.Serialization

​

    ' https://stackoverflow.com/questions/47758073/collect-all-appids-from-a-json-file

​

    Public Module TestClass 

​

        Friend Sub Test()

            Dim JsonString as String = GetJson()

            Console.WriteLine("Input JSON: ")

            Console.WriteLine(JsonString)

            Dim jsonObject As JToken = JToken.Parse(JsonString)

            Dim appids = jsonObject _ 

                .SelectTokens("..appid") _

                .Select(Function(t) CType(t, Long)) _

                .ToList()

            Console.Write("appids: ")

            Console.WriteLine(JsonConvert.SerializeObject(appids))

​

        End Sub 

​

        Function GetJson() as String

Dim Jstring As String = <![CDATA[

{

"response": {

    "game_count": 4,

    "games": [

        {

            "appid": 10,

            "playtime_forever": 0

        },

        {

            "appid": 20,

            "playtime_forever": 0

        },

        {

            "appid": 30,

            "playtime_forever": 0

        },

        {

            "appid": 40,

            "playtime_forever": 0

        }

    ]

​

   }

}

]]>.Value       

        Return Jstring      

        End Function

    End Module

​

    Public Module Module1   

        Public Sub Main()

        Console.WriteLine("Environment version: " & Environment.Version.ToString())

            Console.WriteLine("Json.NET version: " & GetType(JsonSerializer).Assembly.FullName)

            Console.WriteLine("")

​

            Try

​

                TestClass.Test()

​

            Catch ex as Exception

​

                Console.WriteLine("Unhandled exception: ")

                Console.WriteLine(ex)

                Throw

​

            End Try

        End Sub 

    End Module

​

    Public Class AssertionFailedException

        Inherits Exception

        Public Sub New()

        End Sub

        Public Sub New(message As String)

            MyBase.New(message)

        End Sub

        Public Sub New(message As String, inner As Exception)

            MyBase.New(message, inner)

        End Sub

    End Class

    Public Module Assert

        Public Sub IsTrue(value as Boolean, Optional message as String = "failed")

​

            If value = False Then

                Throw New AssertionFailedException(message)

            End If

        End Sub

    End Module