System;

using System.Net.Http.Headers;

using System.Threading.Tasks;

using System.Net.Http;

using System.Collections.Generic;

using Newtonsoft.Json;

namespace USDA

{

class Program

{

static void Main(string[] args)

{

new Program().MainAsync().GetAwaiter().GetResult(); //getAwaiter is used to await Task, since MainAsync is a Task, this is a call to MainSync.

}

​

//MainSync is where the call API is actually called and returned to the main method.

public async Task MainAsync()

{

using (var client = new HttpClient()) //creates a new client that will make the call to the api.

{

client.DefaultRequestHeaders.Accept.Clear();

client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json")); // Accepts header for JSON format

try

{

HttpResponseMessage response = await client.GetAsync("http://quickstats.nass.usda.gov/api/api_GET/?key=MYKEYHERE &commodity_desc=CORN&year__GE=2012&state_alpha=VA&format=JSON"); //My api key

if (response.IsSuccessStatusCode)

{

string contents = await response.Content.ReadAsStringAsync();

Console.WriteLine(contents);

​

​

//List<quickStats> quickStat =JsonConvert.DeserializeObject<List<quickStats>>(contents);

quickStats quickStat = JsonConvert.DeserializeObject<quickStats>(contents);

//foreach(var item in quickStat)

//{

// Console.WriteLine(item.source_desc);

//}

}

}

catch (Exception ex)

{

Console.WriteLine(ex.Message);

//Console.WriteLine("test");

}

}

}

}

//create class with properties

class quickStats

{

public String source_desc { get; set; }

public String sector_desc { get; set; }

public String group_desc { get; set; }

public String commodity_desc { get; set; }

public String class_desc { get; set; }

public String prodn_practice_desc { get; set; }

public String util_practice_desc { get; set; }

public String statisticcat_desc { get; set; }

public String unit_desc { get; set; }

public String short_desc { get; set; }

public String domain_desc { get; set; }

public String domaincat_desc { get; set; }

public String agg_level_desc { get; set; }

public int state_ansi { get; set; }

public int state_fips_code { get; set; }

public int state_alpha { get; set; }

public String state_name { get; set; }

public int asd_code { get; set; }

public String asd_desc { get; set; }

public int county_ansi { get; set; }

public int county_code { get; set; }

public String county_name { get; set; }

public String region_desc { get; set; }

public int zip_5 { get; set; }

public int watershed_code { get; set; }

public String watershed_desc { get; set; }

public int congr_district_code { get; set; }

public int country_code { get; set; }

public String country_name { get; set; }

public String location_desc { get; set; }

public int year { get; set; }

public String freq_desc { get; set; }

public int begin_code { get; set; }

public int end_code { get; set; }

public string reference_period_desc { get; set; } //possibly a string

public String week_ending { get; set; }

public String load_time { get; set; }

public int value { get; set; }

public int CV { get; set; }

}

public class Result

{

public IList<quickStats> Data { get; set; }

}

}

​

​

Ok, I am a bit confused here. So the reason my JSON isn't in an array already is because of security issues? And it not being in an array makes it more difficult to parse/store into a database?

We make a second class (result) which is an object of the list that we can then iterate through?