Best way to parse a string to recognisable data structure

Question

I have some data in the following format. There's a uuid with timeseries reading, each tuple representing a timestamp and value.

"[{\"uuid\": \"3c24a849-3355-5b28-bf83-1e93c36eea75\", \"Readings\": [[1541524171000.0, 22.700000762939453], [1541531370000.0, 22.600000381469727], [1541577227000.0, 21.700000762939453], [1541578016000.0, 21.899999618530273], [1541578322000.0, 22.100000381469727], [1541580122000.0, 22.0]]}]"

This is a response from a rest service that's meant to return json. I went ahead and did

public class DataReading
{
    public string uuid { get; set; }
    public string readings { get; set; }
}

imported Newtonsoft.Json and did

var list = JsonConvert.DeserializeObject<List<DataReading>>(thereturnstring);

I'm getting an error

Newtonsoft.Json.JsonReaderException: 'Unexpected character encountered while parsing value: [. Path '[0].Readings', line 1, position 63.'

Any insight? Line 1 position 63 seems to be the 'n' in Readings. How do I convert this to anything meaningful?

Your JSON has an array, not a string. – SLaks Nov 13 '18 at 16:43 — SLaks, Nov 13 '18 at 16:43
https://stackoverflow.com/a/48023576/4180382 – Ole EH Dufour Nov 13 '18 at 16:45 — Ole EH Dufour, Nov 13 '18 at 16:45

Ashkan Mobayen Khiabani · Accepted Answer · 2018-11-13T17:08:46.927

0

Change your class from:

public class DataReading
{
    public string uuid { get; set; }
    public string readings { get; set; }
}

to

public class DataReading
{
    public string uuid { get; set; }
    public double[][] readings { get; set; }
}

Then you can Deserialize it like:

string jsonString = "[{\"uuid\": \"3c24a849-3355-5b28-bf83-1e93c36eea75\", \"Readings\": [[1541524171000.0, 22.700000762939453], [1541531370000.0, 22.600000381469727], [1541577227000.0, 21.700000762939453], [1541578016000.0, 21.899999618530273], [1541578322000.0, 22.100000381469727], [1541580122000.0, 22.0]]}]";
var result = Newtonsoft.Json.JsonConvert.DeserializeObject<DataReading[]>(jsonString);

Live Demo

edited Nov 13 '18 at 17:08

answered Nov 13 '18 at 16:45

Ashkan Mobayen Khiabani

33,575
33
102
171

That's not a string array. – SLaks Nov 13 '18 at 16:45
yes I saw that, I was wrong, and its array of array. – Ashkan Mobayen Khiabani Nov 13 '18 at 16:47
It worked, thanks. I'll accept the answer when it allows me. :) – Ehrendil Nov 13 '18 at 16:54

Best way to parse a string to recognisable data structure

1 Answers1