解析JSON从Sitecore的项目的Web API返回
我无法从Sitecore的API解析以下JSON对象:
I am having trouble parsing the following JSON object from the Sitecore API:
{
"statusCode": 200,
"result": {
"totalCount": 1,
"resultCount": 1,
"items": [
{
"Category": "PAGE",
"Database": "web",
"DisplayName": "Profile",
"HasChildren": false,
"Icon": "/temp/IconCache/Network/32x32/earth.png",
"ID": "{7F51AD8B-4A8B-4DA5-87A8-374BEB900801}",
"Language": "en",
"LongID": "/{11111111-1111-1111-1111-111111111111}/{0DE95AE4-41AB-4D01-9EB0-67441B7C2450}/{110D559F-DEA5-42EA-9C1C-8A5DF7E70EF9}/{D608D67E-01F1-493C-B3B7-23176449CD10}/{7F51AD8B-4A8B-4DA5-87A8-374BEB900801}",
"MediaUrl": "/~/icon/Network/48x48/earth.png.aspx",
"Name": "Profile",
"Path": "/sitecore/content/COMPANY/SITE/PAGE",
"Template": "User Defined/COMPANY/Pages/Base Page",
"TemplateId": "{661AFEB1-8ECE-4D65-80A6-40AC160898D8}",
"TemplateName": "Base Page",
"Url": "~/link.aspx?_id=7F51AD8B4A8B4DA587A8374BEB900801&_z=z",
"Version": 1,
"Fields": {
"{B370A8AA-C7D1-4B79-9BD2-C94675808949}": {
"Name": "Title",
"Type": "Single-Line Text",
"Value": "Profile"
},
"{55373261-F234-444F-9967-E4821C9ACD2C}": {
"Name": "Search Results Text",
"Type": "Multi-Line Text",
"Value": ""
},
"{F7DBD22A-6BE1-4FEE-920C-DF1E688A1224}": {
"Name": "Meta Description",
"Type": "Multi-Line Text",
"Value": "Profile Page"
},
"{BC5B4A35-9526-4DF3-A1EB-3C6A01A52777}": {
"Name": "Tags",
"Type": "Multilist",
"Value": ""
},
"{2AFDEE31-FF47-4184-9BB5-3D17E283F110}": {
"Name": "Enable Meta NoIndex",
"Type": "Checkbox",
"Value": ""
},
"{31D6E245-E63A-4749-90F5-225892F29DB7}": {
"Name": "Enable Meta NoFollow",
"Type": "Checkbox",
"Value": ""
},
"{A79C9551-A6F4-4E9E-9CF4-3DE68C1E9BAB}": {
"Name": "Browser Title",
"Type": "Single-Line Text",
"Value": ""
},
"{4A907846-00BB-4417-BA0E-21B16F5F9875}": {
"Name": "Open Text",
"Type": "Multi-Line Text",
"Value": ""
}
}
}
]
}
}
问题是与Fields属性 - 它应该是某种字段列表中,而是,它看起来像他们个人的嵌套属性,每个属性的名称是(编号)
The problem is with the Fields property - it should be some sort of list of fields, but instead, it looks like they are individual nested properties where the name of each property is an "{id}".
我想要做类似 JsonConvert.DeserializeObject< Sitecore.Data.Items.Item>(jsonString)
,但我没有成功。我的真正的preFER不具备编写自定义解串器,但它看起来像这就是我唯一的选择。
I wanted to do something like JsonConvert.DeserializeObject<Sitecore.Data.Items.Item>(jsonString)
, but I have not had success. I would really prefer to not have to write a custom deserializer, but its looking like thats my only option.
即使我想用dyanmic类型的,我能得到尽可能jObject.result.items [0] ...点域,但是然后呢?我不能presume,我将永远知道这些字段的ID。
Even if I wanted to use dyanmic types, I could get as far as jObject.result.items[0].Fields... but then what? I can't presume that I will always know the IDs of these fields.
所以,长话短说,下面是我的问题:
So, long story short, here's my questions:
- 有另一种方式与Sitecore的API进行交互,这将有助于我吗?
- 解析/反序列化JSON的时候反正周围的IDS-AS-财产的名称问题?
- Is there another way to interact with the Sitecore API that would help me?
- Is there anyway around the ids-as-property-names problem when parsing/deserializing the JSON?
有关它的价值,这个对象从Sitecore的API,这我从使用这种方法C#应用程序呼唤到来:
For what it's worth, This object is coming from the Sitecore API, which I am calling out to from a C# application using this approach:
var request = (HttpWebRequest)WebRequest.Create(itemUrl);
request.Headers.Add("X-Scitemwebapi-Username", apiUsername);
request.Headers.Add("X-Scitemwebapi-Password", password);
// get response
var response = (HttpWebResponse)request.GetResponse();
var responseStream = response.GetResponseStream();
(我不认为真正重要的专门解决这一问题的JSON,但也许有人见过这个和周围知道另一种方式?)
(I don't think that really matters for tackling the JSON problem specifically, but maybe someone has seen this before and knows another way around?)
先谢谢了。
使用JSON.Net我做这个如下:
Using JSON.Net I've done this as follows:
string json = "{\"statusCode\": 200, \"result\": { \"totalCount\": 1, \"resultCount\": 1, \"items\": [ { \"Category\": \"PAGE\", \"Database\": \"web\", \"DisplayName\": \"Profile\", \"HasChildren\": false, \"Icon\": \"/temp/IconCache/Network/32x32/earth.png\", \"ID\": \"{7F51AD8B-4A8B-4DA5-87A8-374BEB900801}\", \"Language\": \"en\", \"LongID\": \"/{11111111-1111-1111-1111-111111111111}/{0DE95AE4-41AB-4D01-9EB0-67441B7C2450}/{110D559F-DEA5-42EA-9C1C-8A5DF7E70EF9}/{D608D67E-01F1-493C-B3B7-23176449CD10}/{7F51AD8B-4A8B-4DA5-87A8-374BEB900801}\", \"MediaUrl\": \"/~/icon/Network/48x48/earth.png.aspx\", \"Name\": \"Profile\", \"Path\": \"/sitecore/content/COMPANY/SITE/PAGE\", \"Template\": \"User Defined/COMPANY/Pages/Base Page\", \"TemplateId\": \"{661AFEB1-8ECE-4D65-80A6-40AC160898D8}\", \"TemplateName\": \"Base Page\", \"Url\": \"~/link.aspx?_id=7F51AD8B4A8B4DA587A8374BEB900801&_z=z\", \"Version\": 1, \"Fields\": { \"{B370A8AA-C7D1-4B79-9BD2-C94675808949}\": { \"Name\": \"Title\", \"Type\": \"Single-Line Text\", \"Value\": \"Profile\" }, \"{55373261-F234-444F-9967-E4821C9ACD2C}\": { \"Name\": \"Search Results Text\", \"Type\": \"Multi-Line Text\", \"Value\": \"\" }, \"{F7DBD22A-6BE1-4FEE-920C-DF1E688A1224}\": { \"Name\": \"Meta Description\", \"Type\": \"Multi-Line Text\", \"Value\": \"Profile Page\" }, \"{BC5B4A35-9526-4DF3-A1EB-3C6A01A52777}\": { \"Name\": \"Tags\", \"Type\": \"Multilist\", \"Value\": \"\" }, \"{2AFDEE31-FF47-4184-9BB5-3D17E283F110}\": { \"Name\": \"Enable Meta NoIndex\", \"Type\": \"Checkbox\", \"Value\": \"\" }, \"{31D6E245-E63A-4749-90F5-225892F29DB7}\": { \"Name\": \"Enable Meta NoFollow\", \"Type\": \"Checkbox\", \"Value\": \"\" }, \"{A79C9551-A6F4-4E9E-9CF4-3DE68C1E9BAB}\": { \"Name\": \"Browser Title\", \"Type\": \"Single-Line Text\", \"Value\": \"\" }, \"{4A907846-00BB-4417-BA0E-21B16F5F9875}\": { \"Name\": \"Open Text\", \"Type\": \"Multi-Line Text\", \"Value\": \"\" } } } ] }}";
JToken desJson = JObject.Parse(json);
(例如,状态code)
现在拿到的项目,你可以做到以下几点:
Now to get item(e.g., statusCode), you can do the following:
int statusCode = (int)desJson.SelectToken("statusCode");
Console.WriteLine(statusCode);
答:
希望这有助于。
要看到的字段,例如,你可以这样做:
To see Fields,e.g., you can do like this:
JToken desJson = JObject.Parse(json);
var test = desJson.SelectToken("result");
Console.WriteLine(test.Last.Last[0].Last);
的代替 test.Last.Last的[0]。去年
您可以在循环或递归做到这一点。这只是一个例子。的
Instead of test.Last.Last[0].Last
you can do this in loop or recursion as well. that was just an example.
结果: