Decode JSON

Question

User-352524747 posted

How to decode this JSON, from yahoo:

 https://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20csv%20where%20url%3D%27http%3A%2F%2Fdownload.finance.yahoo.com%2Fd%2Fquotes.csv%3Fs%3DEURUSD%3DX%2CEURCHF%3DX%2CUSDCHF%3DX%2CUSDJPY%3DX%26f%3Dsl1c1p2%26e%3D.csv%27%20and%20columns%3D%27symbol%2Cprice%2Cchange%2Cpercentchange%27&format=json&env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys

{"query":{"count":4,"created":"2017-09-06T16:09:32Z","lang":"en-US","results":{"row":[{"symbol":"EURUSD=X","price":"1.1937","change":"+0.0025","percentchange":"+0.2132%"},{"symbol":"EURCHF=X","price":"1.1382","change":"+0.0000","percentchange":"+0.0044%"},{"symbol":"USDCHF=X","price":"0.9536","change":"-0.0019","percentchange":"-0.1989%"},{"symbol":"USDJPY=X","price":"108.7470","change":"-0.0030","percentchange":"-0.0028%"}]}}}

I want to read symbol, price, change and percentchange. While i use this code i get an error:

dynamic[] quotes = Json.Decode(marketdata.JsonData);

Error:

Unable to convert to "System.Object[]". Use Json.Decode<T> instead.

Answer 1

User753101303 posted

Hi,

The array is deeper than that (query.result.rows). I would suggest to use copy/paste a json sample to http://json2csharp.com/ which will generate a C# class for this json. You can then use strogly typed code to get to whatever information you want...

Answer 2

User347430248 posted

Hi dow7,

did you try to use Json.parse?

if not you can have a try.

 function LaunchApp() {

     
        var data = '{"row":[{"symbol":"EURUSD=X","price":"1.1925","change":"+0.0004","percentchange":"+0.0344%"},{"symbol":"EURCHF=X","price":"1.1402","change":"+0.0002","percentchange":"+0.0219%"},{"symbol":"USDCHF=X","price":"0.9561","change":"+0.0002","percentchange":"+0.0230%"},{"symbol":"USDJPY=X","price":"109.0700","change":"-0.1860","percentchange":"-0.1702%"}]}';

	var json = JSON.parse(data);

	alert(json["symbol"]); 

	alert(json.price); 


	alert(json.change);
	

	alert(json.percentchange);
    }

Reference:

JSON.parse()

Regards

Deepak

Answer 3

User-352524747 posted

Now i have this c# class, can you please show me how to use it?

public class Row
{
    public string symbol { get; set; }
    public string price { get; set; }
    public string change { get; set; }
    public string percentchange { get; set; }
}

public class Results
{
    public List<Row> row { get; set; }
}

public class Query
{
    public int count { get; set; }
    public string created { get; set; }
    public string lang { get; set; }
    public Results results { get; set; }
}

public class RootObject
{
    public Query query { get; set; }
}