首先,这对希望了解这一点的人有所帮助:
我有一个API,我需要查询各种数据点(CrunchBase),我获取了URL并使用此工具http://json2csharp.com/#为其生成了类(返回了与该JSON URL交互所需的类)接下来,我需要使用服务,请斯科特·汉塞尔曼(Scott Hanselman)进行救援,使用有关如何执行此操作的博客文章http://www.hanselman.com/blog/NuGetPackageOfTheWeek4DeserializingJSONWithJsonNET.aspx接下来,我将两者放在一起,并进行了一些修补,以使我可以查询CrunchBase API以获取所需的部分信息。目前,我只是通过控制台应用程序来确定逻辑,因为我打算稍后将其包装在.dll中,以便在将信息提供给MVC站点的DataModel项目的DAL层中使用。
问题:到目前为止,除了我不知道我该怎么做才能遍历从JSON终结点返回的子对象之外,目前为止都可以工作。我的代码按原样发布给想要查看实现的任何人(我无法在网上找到任何示例来调用C#中的CrunchBase API)此代码在我知道需要一些foreach循环的地方被评论。但是我发现的所有示例都不适用于我。任何有关如何执行此操作的方向都非常感谢。一个示例或代码更正对帮助自己和其他人自己解决其余问题大有帮助。另一个问题,这可以全部用c#完成吗?还是需要使用其他方法?
此代码中使用的端点是“ http://api.crunchbase.com/v/1/company/” + CompanyName +“。js”提前非常感谢,在询问之前,我竭尽全力。
....
using System.Net;
using Newtonsoft.Json;
namespace CrunchBase
{
class Program
{
static void Main(string[] args)
{
Console.WriteLine("Enter the name of a Company to look up:");
string CompanyName = Console.ReadLine();
var client = new WebClient();
client.Headers.Add("User-Agent", "Nobody"); //my endpoint needs this...
var response = client.DownloadString(new Uri("http://api.crunchbase.com/v/1/company/" + CompanyName +".js"));
var j = JsonConvert.DeserializeObject<RootObject>(response);
var f = JsonConvert.DeserializeObject<FundingRound>(response);
var i = JsonConvert.DeserializeObject<Investment>(response);
Console.WriteLine("Company Name: {0}", j.name);
Console.WriteLine("Web Page: {0}", j.homepage_url);
Console.WriteLine("Email Adress: {0}", j.email_address);
Console.WriteLine("CruchBase Page: {0}", j.crunchbase_url);
Console.WriteLine("Category: {0}", j.category_code);
Console.WriteLine("Description: {0}", j.description);
Console.WriteLine("Number of Employees: {0}", j.number_of_employees);
Console.WriteLine("Year Founded: {0}", j.founded_year);
// How would the best aproach be to loop through all of the Objects and print their properties?
// By the way, if you run this it will hang a little bit because the FundingRound object is not
// properly implemented at the moment.
Console.WriteLine("Funding Round Type: {0}", f.round_code);
Console.WriteLine("Information Source: {0}", f.source_url);
Console.WriteLine("Description: {0}", f.source_description);
Console.WriteLine("Raised Amount: {0} {1}", f.raised_currency_code, f.raised_amount);
// I take it the same technique used to loop through the above "f" var object
// I would use again to loop through to the next nested Investment object
// and on down the chain fefore returning right back up....
Console.ReadLine();
}
public class Image
{
public List<List<object>> available_sizes { get; set; }
public object attribution { get; set; }
}
public class Person
{
public string first_name { get; set; }
public string last_name { get; set; }
public string permalink { get; set; }
}
public class Relationship
{
public bool is_past { get; set; }
public string title { get; set; }
public Person person { get; set; }
}
public class Provider
{
public string name { get; set; }
public string permalink { get; set; }
}
public class Providership
{
public string title { get; set; }
public bool is_past { get; set; }
public Provider provider { get; set; }
}
public class FinancialOrg
{
public string name { get; set; }
public string permalink { get; set; }
}
public class Person2
{
public string first_name { get; set; }
public string last_name { get; set; }
public string permalink { get; set; }
}
public class Investment
{
public object company { get; set; }
public FinancialOrg financial_org { get; set; }
public Person2 person { get; set; }
}
public class FundingRound
{
public string round_code { get; set; }
public string source_url { get; set; }
public string source_description { get; set; }
public double raised_amount { get; set; }
public string raised_currency_code { get; set; }
public int funded_year { get; set; }
public int funded_month { get; set; }
public int funded_day { get; set; }
public List<Investment> investments { get; set; }
}
public class Office
{
public string description { get; set; }
public string address1 { get; set; }
public string address2 { get; set; }
public string zip_code { get; set; }
public string city { get; set; }
public string state_code { get; set; }
public string country_code { get; set; }
public object latitude { get; set; }
public object longitude { get; set; }
}
public class VideoEmbed
{
public string embed_code { get; set; }
public string description { get; set; }
}
public class Screenshot
{
public List<List<object>> available_sizes { get; set; }
public object attribution { get; set; }
}
public class RootObject
{
public string name { get; set; }
public string permalink { get; set; }
public string crunchbase_url { get; set; }
public string homepage_url { get; set; }
public string blog_url { get; set; }
public string blog_feed_url { get; set; }
public string twitter_username { get; set; }
public string category_code { get; set; }
public int number_of_employees { get; set; }
public int founded_year { get; set; }
public int founded_month { get; set; }
public object founded_day { get; set; }
public object deadpooled_year { get; set; }
public object deadpooled_month { get; set; }
public object deadpooled_day { get; set; }
public object deadpooled_url { get; set; }
public string tag_list { get; set; }
public string alias_list { get; set; }
public string email_address { get; set; }
public string phone_number { get; set; }
public string description { get; set; }
public string created_at { get; set; }
public string updated_at { get; set; }
public string overview { get; set; }
public Image image { get; set; }
public List<object> products { get; set; }
public List<Relationship> relationships { get; set; }
public List<object> competitions { get; set; }
public List<Providership> providerships { get; set; }
public string total_money_raised { get; set; }
public List<FundingRound> funding_rounds { get; set; }
public List<object> investments { get; set; }
public object acquisition { get; set; }
public List<object> acquisitions { get; set; }
public List<Office> offices { get; set; }
public List<object> milestones { get; set; }
public object ipo { get; set; }
public List<VideoEmbed> video_embeds { get; set; }
public List<Screenshot> screenshots { get; set; }
public List<object> external_links { get; set; }
}
}
}
最佳答案
我想您正在寻找类似的东西,如果没有,则应指定您的问题,或告诉以下内容为何不起作用或发生哪个错误...
foreach (var office in j.offices)
{
Console.WriteLine("Description: {0}", office.description );
//...
}
但是可以肯定的是:可以使用C#完成!
对于那些
List<object>
属性,您应该将相应的类添加到模型(您确实生成的类),或者尝试将这些对象强制转换为JsonObject
或sth。像那样。 (请检查VS以查看实际类型。)