如何使用'；帖子'；方法使用c#获取JSON数据
本文关键字：获取 JSON 数据 方法 何使用 帖子 | 更新日期: 2023-09-27 18:26:48
我正试图从BLS网站请求一组特定的数据：
http://www.bls.gov/developers/api_signature_v2.htm#parameters
在这个链接上，我特别试图获得一个具有可选参数的系列。我非常接近，但好像我的JSON发布请求没有得到处理。
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Net;
using System.Data.SqlClient;
using System.Web;
using System.Configuration;
using System.Data;
using System.Globalization;
using System.ComponentModel;
using Newtonsoft.Json;
using System.Web.Script.Serialization;
using System.IO;
using System.Net.Http;
using System.Net.Http.Headers;
namespace ConsoleApplication5
{
//Classes needed to deserialze JSON data (JSON to C# website)
public class DataObject
{
public string Name { get; set; }
}
public class Footnote
{
}
public class Datum
{
public string year { get; set; }
public string period { get; set; }
public string periodName { get; set; }
public string value { get; set; }
public List<Footnote> footnotes { get; set; }
}
public class Series
{
public string seriesID { get; set; }
public List<Datum> data { get; set; }
}
public class Results
{
public List<Series> series { get; set; }
}
public class RootObject
{
public string status { get; set; }
public int responseTime { get; set; }
public List<object> message { get; set; }
public Results Results { get; set; }
public override string ToString()
{
return string.Format("Status: {0}", status);
}
}
class Program
{
static double octLY;
static double oct2y;
static void Main(string[] args)
{
TryParsing();
}
static void TryParsing()
{
var httpWebRequest = (HttpWebRequest)WebRequest.Create("http://api.bls.gov/publicAPI/v2/timeseries/data/CUUR0000SA0");
httpWebRequest.ContentType = "application/json";
httpWebRequest.Method = "POST";
using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))
{
//string json = new JavaScriptSerializer().Serialize(new
//{
// seriesid = "CUUR0000SA0",
// startYear = "2010",
// endYear = "2015",
// catalog = "true",
// calculations = "true",
// annualAverage = "true",
// registrationKey = "f3171173a8ce4b969b5085ba9a83202f"
//});
string json = "{'"seriesid'":['"CUUR0000SA0'"],'"startyear'":'"2010'",'"endyear'":'"2015'",'"catalog'":true,'"calculations'":true,'"annualAverage'":true,'"registrationKey'":'"f3171173a8ce4b969b5085ba9a83202f'"}";
//Console.WriteLine(json.ToString());
//Console.ReadLine();
streamWriter.Write(json);
streamWriter.Flush();
streamWriter.Close();
}
var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
using (var streamReader = new StreamReader(httpResponse.GetResponseStream()))
{
var result = streamReader.ReadToEnd();
Console.WriteLine(result.ToString());
Console.ReadLine();
}
}
}
}
我对JSON post数据进行了硬编码，以完全符合BLS链接上的示例所显示的内容。问题是它忽略了我的所有参数。我只得到3年的数据，尽管要求5等…
可以使用我的身份验证代码，因为这是通用的，稍后会更改。
有人能告诉我如何使用POST方法请求这些数据吗？我觉得我只是错过了一些基本的东西，但却找不到。
仅供参考，如果你正在重新创建这个问题，这将很容易，因为它都是开源数据等…但由于它在请求中没有看到我的授权，它将用户限制为每天25个请求。。。因此，如果你按原样运行26次…你会收到一条请求超出的消息。如果这起作用，则从25倍增加到500倍。
这是我尝试的另一种方法：
static void TryParse()
{
//Get JSON data
using (WebClient wc = new WebClient())
{
var json = wc.DownloadString("http://api.bls.gov/publicAPI/v2/timeseries/data/CUUR0000SA0");
//Deserialize JSON data
var p1 = new JavaScriptSerializer();
RootObject j = p1.Deserialize<RootObject>(json);
RootObject r1 = JsonConvert.DeserializeObject<RootObject>(json);
//check to see if JSON data was successfully downloaded
if (r1.ToString() == "Status: REQUEST_SUCCEEDED")
{
//Loop through the JSON to find values
foreach (Datum d in j.Results.series[0].data)
{
//Filters data based on year value
if ((Int16.Parse(d.year) == DateTime.Now.Year - 1 && d.period == "M10" )) //|| (Int16.Parse(d.year) == DateTime.Now.Year - 1 && d.period == "M10" )))
{
octLY = (double.Parse(d.value));
Console.WriteLine("OCT14: {0}", octLY);
//Console.WriteLine(d.year + " : " + d.period + " : " + d.periodName + " : " + d.value);
}
if (Int16.Parse(d.year) == DateTime.Now.Year - 2 && d.period == "M10")
{
oct2y = (double.Parse(d.value));
Console.WriteLine("OCT13: {0}", oct2y);
}
else { }
}
Console.WriteLine("CPI: {0}", (octLY - oct2y) / oct2y + 1);
}
else
{
Console.WriteLine(r1.ToString());
Console.ReadLine();
}
Console.ReadLine();
}
}
使用您的代码重新创建时，我能够在我的RootObject class Results.Series集合中获取有效数据。首先，我创建了一个名为Series Post的新类。
public class SeriesPost
{
public string[] seriesid { get; set; }
public string startyear { get; set; }
public string endyear { get; set; }
public bool catalog { get; set; }
public bool calculations { get; set; }
public bool annualaverage { get; set; }
public string registrationKey { get; set; }
}
从那里我修改了你的JSON序列化一点
using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))
{
string newJson = Newtonsoft.Json.JsonConvert.SerializeObject(new SeriesPost()
{
seriesid = (new List<string>() { "CUUR0000SA0" }).ToArray(),
startyear = "2010",
endyear = "2015",
catalog = false,
calculations = true,
annualaverage = true,
registrationKey = "f3171173a8ce4b969b5085ba9a83202f"
});
//So you can see the JSON thats output
System.Diagnostics.Debug.WriteLine(newJson);
streamWriter.Write(newJson);
streamWriter.Flush();
streamWriter.Close();
}
var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
using (var streamReader = new StreamReader(httpResponse.GetResponseStream()))
{
var result = streamReader.ReadToEnd();
//Here your RootObject is the Type thats returned with your results
RootObject obj = Newtonsoft.Json.JsonConvert.DeserializeObject<RootObject>(result);
// Loop over the series in the results
foreach(Series ser in obj.Results.series)
{
// Loop over the Data in each of the series.
foreach(var data in ser.data)
{
//Output the year, in my test I got multiple entries for each year between 2010 to 2015
Console.WriteLine(data.year);
}
}
Console.ReadLine();
}