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

​

Imports Microsoft.VisualBasic 

​

Imports NUnit.Framework

​

    ' https://stackoverflow.com/questions/56211783/translate-c-sharp-to-vb-net#56211783

​

    Public Module TestClass 

​

        Sub PrintType(Of T)(ByVal Item As T)

            Console.WriteLine(GetType(T))

        End Sub

        Friend Sub Test()

            Dim json as String = GetJson()

            Dim obj As JObject = JObject.Parse(json)

            Dim values = obj.DescendantsAndSelf().OfType(Of JProperty)().Where(Function(p) TypeOf p.Value Is JValue).GroupBy(Function(p) p.Name).ToList()

            Dim columns = values.[Select](Function(g) g.Key).ToArray()

​

            Dim parentsWithChildren = values.SelectMany(Function(g) g).SelectMany(Function(v) v.AncestorsAndSelf().OfType(Of JObject)().Skip(1)).ToHashSet()

​

            Dim rows = obj.DescendantsAndSelf() _

                                .OfType(Of JObject)() _

                                .Where(Function(o) o.PropertyValues().OfType(Of JValue)().Any()) _

                                .Where(Function(o) o.Equals(obj) OrElse Not parentsWithChildren.Contains(o)) _

                                .Select(Function(o) columns.Select(Function(c) _

                                                                o.AncestorsAndSelf() _

                                                                .OfType(Of JObject)() _

                                                                .Select(Function(parent) parent(c)) _

                                                                .OfType(Of JValue)() _

                                                                .Select(Function(v) CStr(v)) _

                                                                .FirstOrDefault()) _

                                                            .Reverse() _

                                                            .SkipWhile(Function(s) s Is Nothing) _

                                                            .Reverse())

​

            Dim csvRows = DirectCast({columns}, IEnumerable(Of IEnumerable(Of String))).Concat(rows) _

                            .Select(Function(r) String.Join(",", r))   ' HERE IS WHERE THE EXCEPTION OCCURS

            Dim csv = String.Join(vbLf, csvRows)        

​

            Console.WriteLine("Output CSV:")

            Console.WriteLine(csv)

            Console.WriteLine()

​

            Console.WriteLine("Input JSON:")

            Console.WriteLine(obj)

            Console.WriteLine()

​

​

            PrintType({ columns.AsEnumerable() })

            PrintType({ columns })

​

            PrintType(rows)

        End Sub 

​

        Function GetJson() as String

Dim Jstring As String = <![CDATA[

{

  "Response": [

    [

      {

        "id": 136662306,

        "symbol": "aaa",

        "status": "ACTIVE",

        "base": "731.07686321",

        "amount": "6.95345994",

        "timestamp": "1524781083.0",

        "swap": "0.0",

        "pl": "5127.4352653395923394"

      },

      {

        "id": 137733525,

        "symbol": "bbb",

        "status": "ACTIVE",

        "base": "636.75093128",

        "amount": "1.1",

        "timestamp": "1531902193.0",

        "swap": "0.0",

        "pl": "687.800226608"

      }

    ]

  ]

}

]]>.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

​