Parse a JSON nested array with numbers and strings

Question

I receive the following JSON response from a web server:

[
  [
    1499040000000,
    "0.01634790",
    "0.80000000",
    "0.01575800",
    "0.01577100",
    "148976.11427815",
    1499644799999,
    "2434.19055334",
    308,
    "1756.87402397",
    "28.46694368",
    "17928899.62484339"
  ]
]

How can I parse it to an array using System.Text.Json?
I've already tried String.Split() and String.Replace() (as the brackets and quotes appear in elements) but it's an "ugly" approach.

Any suggestions will be very much appreciated.

Jimi · Accepted Answer · 2021-03-06 12:48:00Z

1

That JSON represents an Array of arrays (well, a single nested array here).
You can parse it as a List(Of Double()) or List(Of List(Of Double)).

The mixed data Type (strings and numbers), can be converted to all numbers, setting a JsonSerializerOptions that specifies the NumberHandling to use, here set to AllowReadingFromString.

Dim options = New JsonSerializerOptions() With {
    .NumberHandling = JsonNumberHandling.AllowReadingFromString
}

Dim listOfDouble = JsonSerializer.Deserialize(Of List(Of Double()))(json, options)

You could also deserialize to a List(Of Object()) and perform the conversion later or just read the values as strings, calling .ToString() when you read an element of the List.

 Dim listOfObjects = JsonSerializer.Deserialize(Of List(Of Object()))(json)

edited Mar 6, 2021 at 12:48

answered Mar 6, 2021 at 8:51

Jimi

33.3k8 gold badges52 silver badges84 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Parse a JSON nested array with numbers and strings

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related