Parser JSON C#

**techgeom** · 06/03/2011, 00h53

Slt le forum, j'essaie en vain de parser le flux foursquare.

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
 var address = new Uri("https://api.foursquare.com/v2/venues/search?ll=40.7,-74");
            var client = new WebClient();
            client.DownloadStringCompleted +=ClientDownloadStringCompleted;
            client.DownloadStringAsync(address);

Et

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
 private static void ClientDownloadStringCompleted(object sender, DownloadStringCompletedEventArgs e)
        {
 
            var responseStream = e.Result;
            var raw = e.Result;
            JsonArray k;
            if (JsonValue.Parse(raw) as JsonArray == null)
                k = new JsonArray { JsonValue.Parse(raw) as JsonObject };
            else
                k = JsonValue.Parse(raw) as JsonArray;
 
 
 
            foreach (JsonObject jo in k)
            {
 
            //     id = (string)item.Element("id"),
            //            name = (string)item.Element("name"),
            //            address = (string)item.Element("address"),
            //            city = (string)item.Element("city"),
            //            state = (string)item.Element("state"),
            //            zip = (string)item.Element("zip"),
            //            geolat = (string)item.Element("geolat"),
            //            geolong = (string)item.Element("geolong"),
            }

Mais je n'arrive pas à parser le flux json. Quelqu'un a une idée ?

Merci

**olibara** · 06/03/2011, 08h44

Envoyé par techgeom

Mais je n'arrive pas à parser le flux json.

C'est a dire ?
Peux tu etre plus precis ?

Le bout de code que tu donne n'eclaire pas vraiment sur ton problème

**techgeom** · 06/03/2011, 17h25

J'essaie de convertir le flux json en objet.
Voici un bout du flux json.

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
{
meta: {
code: 200
}
response: {
groups: [
{
type: "trending"
name: "Trending Now"
items: [
{
id: "49e3e886f964a520ea621fe3"
name: "Brooklyn Tabernacle"
contact: { }
location: {
address: "17 Smith St"
crossStreet: "Jay and Lawrence St"
city: "Brooklyn"
state: "NY"
postalCode: "11201"
lat: 40.691
lng: -73.9876
distance: 1448
}
categories: []
verified: false
stats: {
checkinsCount: 591
usersCount: 206
}
todos: {
count: 0
}
hereNow: {
count: 8
}
}

Je voudrais récuperer id,name,contact,location,address.... de chaque item.
Merci

**Arnard** · 06/03/2011, 17h31

JsonValue.Parse ressemble à quoi ? Combien d'éléments as-tu dans ton Array avant de passer dans le foreach ?

**techgeom** · 06/03/2011, 17h45

JsonValue.Parse ressemble à

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

{"meta":{"code":200},"response":{"groups":[{"type":"trending","name":"Trending Now","items":[{"id":"49e3e886f964a520ea621fe3","name":"Brooklyn Tabernacle","contact":{},"location":{"address":"17 Smith St","crossStreet":"Jay and Lawrence St","city":"Brooklyn","state":"NY","postalCode":"11201","lat":40.691,"lng":-73.9876,"distance":1448},"categories":[{"id":"4bf58dd8d48988d132941735","name":"Churches","icon":"http:\/\/foursquare.com\/img\/categories\/building\/religious_church.png","parents":["Home \/ Work \/ Other","Religious Centers"],"primary":true},{"id":"4bf58dd8d48988d131941735","name":"Religious Centers","icon":"http:\/\/foursquare.com\/img\/categories\/building\/religious.png","parents":["Home \/ Work \/ Other"]}],"verified":false,"stats":{"checkinsCount":591,"usersCount":206},"todos":{"count":0},"hereNow":{"count":7}},{"id":"4c757abb3adda1432e7707af","name":"New York Law School","contact":{"phone":"2124312100","twitter":"nylawschool"},"location":{"address":"185 W Broadway","crossStreet":"at Worth St","city":"New York","state":"NY","postalCode":"10013","lat":40.718005536050974,"lng":-74.00696396827698,"distance":2088},"categories":[{"id":"4bf58dd8d48988d1a6941735","name":"Law Schools","icon":"http:\/\/foursquare.com\/img\/categories\/education\/default.png","parents":["Colleges & Universities"],"primary":true}],"verified":true,"stats":{"checkinsCount":1488,"usersCount":217},"todos":{"count":0},"hereNow":{"count":9}}]},{"type":"nearby","name":"Nearby","items":[{"id":"4b81ea40f964a520e0c330e3","name":"Brooklyn Bridge Park - Pier 1","contact":{},"location":{"address":"334 Furman Street","city":"Brooklyn","state":"NY","postalCode":"11201","lat":40.701984159668676,"lng":-73.9969539642334,"distance":338},"categories":[{"id":"4bf58dd8d48988d163941735","name":"Parks","icon":"http:\/\/foursquare.com\/img\/categories\/parks_outdoors\/default.png","parents":["Great Outdoors"],"primary":true}],"verified":false,"stats":{"checkinsCount":3923,"usersCount":2605},"todos":{"count":0},"hereNow":{"count":0}},{"id":"42377700f964a52024201fe3","name":"Brooklyn Heights Promenade","contact":{},"location":{"address":"Columbia Heights","crossStreet":"btw Montague and Middagh","city":"Brooklyn","state":"NY","postalCode":"11201","lat":40.69829137715981,"lng":-73.99663209915161,"distance":342},"categories":[{"id":"4bf58dd8d48988d163941735","name":"Parks","icon":"http:\/\/foursquare.com\/img\/categories\/parks_outdoors\/default.png","parents":["Great Outdoors"],"primary":true},{"id":"4bf58dd8d48988d1e7941735","name":"Playgrounds","icon":"http:\/\/foursquare.com\/img\/categories\/parks_outdoors\/playground.png","parents":["Great Outdoors"]},{"id":"4bf58dd8d48988d165941735","name":"Scenic Lookouts","icon":"http:\/\/foursquare.com\/img\/categories\/parks_outdoors\/default.png","parents":["Great Outdoors"]}],"verified":false,"stats":{"checkinsCount":3559,"usersCount":1508},"todos":{"count":0},"hereNow":{"count":0}},{"id":"4c48dc0520ab1b8d6118fd15","name":"Movies With A View","contact":{},"location":{"lat":40.701781,"lng":-73.997748,"distance":274},"categories":[{"id":"4bf58dd8d48988d162941735","name":"Other Great Outdoors","icon":"http:\/\/foursquare.com\/img\/categories\/parks_outdoors\/default.png","parents":["Great Outdoors"],"primary":true}],"verified":false,"stats":{"checkinsCount":95,"usersCount":56},"todos":{"count":0},"hereNow":{"count":0}},{"id":"4c3a5ad83849c92880e0c2b1","name":"Blue Marble Ice Cream","contact":{},"location":{"address":"Brooklyn Bridge Park - Pier 1","city":"Brooklyn","state":"NY","postalCode":"11201","lat":40.70136599888968,"lng":-73.99794101715088,"distance":230},"categories":[{"id":"4bf58dd8d48988d1c9941735","name":"Ice Cream Shops","icon":"http:\/\/foursquare.com\/img\/categories\/food\/icecream.png","parents":["Food"],"primary":true}],"verified":false,"stats":{"checkinsCount":68,"usersCount":53},"todos":{"count":0},"hereNow":{"count":0}},{"id":"4c3f7d0cff711b8d68fd0e05","name":"75 Wall Street Gym","contact":{},"location":{"city":"New York","state":"New York","lat":40.700821,"lng":-74.001984,"distance":190},"categories":[{"id":"4bf58dd8d48988d176941735","name":"Gyms","icon":"http:\/\/foursquare.com\/img\/categories\/building\/gym.png","parents":["Home \/ Work \/ Other","Gyms or Fitness Centers"],"primary":true}],"verified":false,"stats":{"checkinsCount":81,"usersCount":39},"todos":{"count":0},"hereNow":{"count":0}},{"id":"4b8f057af964a520184533e3","name":"Exchange Hotel","contact":{},"location":{"city":"New York","state":"New York","lat":40.700521,"lng":-74.001527,"distance":141},"categories":[{"id":"4bf58dd8d48988d121941735","name":"Lounges","icon":"http:\/\/foursquare.com\/img\/categories\/nightlife\/lounge.png","parents":["Nightlife Spots"],"primary":true}],"verified":false,"stats":{"checkinsCount":33,"usersCount":12},"todos":{"count":0},"hereNow":{"count":0}},{"id":"4c0ad81b009a0f47ff2ceabf","name":"Yeasayer Boat Of ROCK","contact":{},"location":{"city":"Brooklyn","state":"New York","postalCode":"11201","lat":40.697134,"lng":-74.00022,"distance":319},"categories":[{"id":"4bf58dd8d48988d12d951735","name":"Boats or Ferries","icon":"http:\/\/foursquare.com\/img\/categories\/travel\/boat.png","parents":["Travel Spots"],"primary":true}],"verified":false,"stats":{"checkinsCount":32,"usersCount":29},"todos":{"count":0},"hereNow":{"count":0}},{"id":"4c67633d8e9120a1d3ddda64","name":"Shroud Park","contact":{},"location":{"address":"Park Place","crossStreet":"Washington","city":"Brooklyn","state":"New York","postalCode":"11238","lat":40.7012193,"lng":-73.9973273,"distance":263},"categories":[{"id":"4bf58dd8d48988d163941735","name":"Parks","icon":"http:\/\/foursquare.com\/img\/categories\/parks_outdoors\/default.png","parents":["Great Outdoors"],"primary":true}],"verified":false,"stats":{"checkinsCount":18,"usersCount":17},"todos":{"count":0},"hereNow":{"count":0}},{"id":"4c704f0334443704e4cc235f","name":"Spiral Pool","contact":{},"location":{"city":"Brooklyn","state":"New York","postalCode":"11201","lat":40.698981285095215,"lng":-73.99768352508545,"distance":226},"categories":[{"id":"4bf58dd8d48988d165941735","name":"Scenic Lookouts","icon":"http:\/\/foursquare.com\/img\/categories\/parks_outdoors\/default.png","parents":["Great Outdoors"],"primary":true}],"verified":false,"stats":{"checkinsCount":13,"usersCount":12},"todos":{"count":0},"hereNow":{"count":0}},{"id":"4c2cd3d38abca593ac4e0220","name":"The Arena","contact":{},"location":{"city":"New York","state":"New York","lat":40.701164,"lng":-74.001253,"distance":167},"categories":[],"verified":false,"stats":{"checkinsCount":9,"usersCount":2},"todos":{"count":0},"hereNow":{"count":0}},{"id":"4d00096e6923721ec97cc23b","name":"My Palatial Estate","contact":{},"location":{"state":"New York","lat":40.70251,"lng":-73.998345,"distance":312},"categories":[],"verified":false,"stats":{"checkinsCount":40,"usersCount":1},"todos":{"count":0},"hereNow":{"count":0}},{"id":"4c5c631c94fd0f47af7ec845","name":"Shuttle Train","contact":{},"location":{"address":"Park Place","crossStreet":"Franklin avenue","city":"Brooklyn","state":"New York","postalCode":"11216","lat":40.7017332,"lng":-73.9965928,"distance":346},"categories":[{"id":"4bf58dd8d48988d1fd931735","name":"Subways","icon":"http:\/\/foursquare.com\/img\/categories\/travel\/subway.png","parents":["Travel Spots"],"primary":true}],"verified":false,"stats":{"checkinsCount":19,"usersCount":7},"todos":{"count":0},"hereNow":{"count":0}},{"id":"4cb9e251adcd54817d881fa2","name":"The Smoking Circle","contact":{},"location":{"lat":40.699856,"lng":-73.995876,"distance":348},"categories":[],"verified":false,"stats":{"checkinsCount":49,"usersCount":5},"todos":{"count":0},"hereNow":{"count":0}},{"id":"4b7c8bedf964a5202c9a2fe3","name":"160 Columbia Heights","contact":{},"location":{"address":"160 Columbia Heights","city":"Brooklyn","state":"NY","lat":40.698296,"lng":-73.996675,"distance":338},"categories":[],"verified":false,"stats":{"checkinsCount":47,"usersCount":4},"todos":{"count":0},"hereNow":{"count":0}},{"id":"4c2fbe00ed37a59340d86703","name":"Fort Stirling Park","contact":{},"location":{"address":"Columbia Heights","crossStreet":"Clark St","city":"Brooklyn","state":"NY","lat":40.6990109,"lng":-73.996,"distance":355},"categories":[{"id":"4bf58dd8d48988d163941735","name":"Parks","icon":"http:\/\/foursquare.com\/img\/categories\/parks_outdoors\/default.png","parents":["Great Outdoors"],"primary":true}],"verified":false,"stats":{"checkinsCount":31,"usersCount":16},"todos":{"count":0},"hereNow":{"count":0}},{"id":"4c4b1b6b9c8d2d7f9c41826a","name":"Wow House rehearsal space","contact":{},"location":{"address":"Park","crossStreet":"Grand","city":"Brooklyn","state":"NY","lat":40.7012193,"lng":-73.9973273,"distance":263},"categories":[{"id":"4bf58dd8d48988d137941735","name":"Theaters","icon":"http:\/\/foursquare.com\/img\/categories\/arts_entertainment\/default.png","parents":["Arts & Entertainment","Performing Arts Venues"],"primary":true}],"verified":false,"stats":{"checkinsCount":8,"usersCount":5},"todos":{"count":0},"hereNow":{"count":0}},{"id":"4cd38685558a37046ceec1a6","name":"Shawarma truck","contact":{},"location":{"address":"Wall st","crossStreet":"Water st","city":"New York","state":"New York","postalCode":"10005","lat":40.701133,"lng":-73.999322,"distance":138},"categories":[],"verified":false,"stats":{"checkinsCount":7,"usersCount":6},"todos":{"count":0},"hereNow":{"count":0}},{"id":"4c8191582f1c236a8e5e3143","name":"Brooklyn Promenade","contact":{},"location":{"city":"New York","state":"New York","lat":40.702858,"lng":-73.998399,"distance":345},"categories":[],"verified":false,"stats":{"checkinsCount":42,"usersCount":41},"todos":{"count":0},"hereNow":{"count":0}},{"id":"4c7150b8b5a5236a85a35252","name":"Yummy Coffee","contact":{},"location":{"city":"New York","state":"New York","lat":40.702122,"lng":-73.999742,"distance":237},"categories":[],"verified":false,"stats":{"checkinsCount":10,"usersCount":5},"todos":{"count":0},"hereNow":{"count":0}},{"id":"4c0077809cf52d7f4ce013e7","name":"Booze Cruise","contact":{"phone":"2126916693"},"location":{"address":"East 23rd St","crossStreet":"FDR Drive","city":"New York","state":"NY","postalCode":"10010","lat":40.703544,"lng":-74.001143,"distance":406},"categories":[{"id":"4bf58dd8d48988d11f941735","name":"Nightclubs","icon":"http:\/\/foursquare.com\/img\/categories\/nightlife\/danceparty.png","parents":["Nightlife Spots"],"primary":true}],"verified":false,"stats":{"checkinsCount":69,"usersCount":53},"todos":{"count":0},"hereNow":{"count":0}},{"id":"4c4672f91ddec9286aab9a32","name":"Opium Den","contact":{},"location":{"city":"Noen Phoem","state":"Thailand","lat":40.702122,"lng":-73.999742,"distance":237},"categories":[],"verified":false,"stats":{"checkinsCount":6,"usersCount":5},"todos":{"count":0},"hereNow":{"count":0}},{"id":"4c86983e74d7b60c4c80a5d8","name":"Hillside Park","contact":{},"location":{"address":"Columbia Heights","crossStreet":"Vine st.","city":"Brooklyn","state":"NY","lat":40.6990109,"lng":-73.996,"distance":355},"categories":[{"id":"4bf58dd8d48988d163941735","name":"Parks","icon":"http:\/\/foursquare.com\/img\/categories\/parks_outdoors\/default.png","parents":["Great Outdoors"],"primary":true}],"verified":false,"stats":{"checkinsCount":15,"usersCount":15},"todos":{"count":0},"hereNow":{"count":0}},{"id":"4c1d046bb4e62d7f43fcdb93","name":"Mannahatta Park","contact":{},"location":{"crossStreet":"South St and Wall St","city":"New York","state":"New York","lat":40.700281,"lng":-74.001472,"distance":128},"categories":[],"verified":false,"stats":{"checkinsCount":10,"usersCount":8},"todos":{"count":0},"hereNow":{"count":0}},{"id":"4d50093edcce224b9ce8d31b","name":"Samantha's Vagina","contact":{},"location":{"city":"Boca Raton","state":"Florida","postalCode":"33498","lat":40.698978,"lng":-74.00043,"distance":119},"categories":[],"verified":false,"stats":{"checkinsCount":5,"usersCount":3},"todos":{"count":0},"hereNow":{"count":0}},{"id":"4c48d05e6594be9a1e573d24","name":"I'm The Dude.  So that's what you call me.","contact":{},"location":{"address":"Furman St.","city":"Brooklyn","state":"NY","lat":40.6974964,"lng":-73.9975451,"distance":347},"categories":[{"id":"4bf58dd8d48988d1e4931735","name":"Bowling Alleys","icon":"http:\/\/foursquare.com\/img\/categories\/arts_entertainment\/bowling.png","parents":["Arts & Entertainment"],"primary":true}],"verified":false,"stats":{"checkinsCount":10,"usersCount":8},"todos":{"count":0},"hereNow":{"count":0}},{"id":"4bf5c1a15e800f47f326e6d4","name":"Fino's","contact":{},"location":{"city":"New York","state":"New York","lat":40.700396,"lng":-74.001432,"distance":128},"categories":[],"verified":false,"stats":{"checkinsCount":4,"usersCount":4},"todos":{"count":0},"hereNow":{"count":0}},{"id":"4c90de437f3b8cfa65b7971e","name":"Taxi 4N62","contact":{},"location":{"city":"New York","state":"New York","lat":40.700249,"lng":-74.001442,"distance":124},"categories":[],"verified":false,"stats":{"checkinsCount":3,"usersCount":3},"todos":{"count":0},"hereNow":{"count":0}},{"id":"4c391bda2c8020a1ed2c8c00","name":"Angel's","contact":{},"location":{"city":"New York","state":"New York","lat":40.702607,"lng":-73.997774,"distance":345},"categories":[],"verified":false,"stats":{"checkinsCount":6,"usersCount":5},"todos":{"count":0},"hereNow":{"count":0}}]}]}}

Je pensais faire une requete linq pour recuperer les items json comme je le fais pour le xml

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
   var q = from item in xmlTree.Descendants("user").Descendants("checkin").Descendants("venue")
                    select new Venue
                    {
                        id = (string)item.Element("id"),
                        name = (string)item.Element("name"),
                        address = (string)item.Element("address"),
                        city = (string)item.Element("city"),
                        state = (string)item.Element("state"),
                        zip = (string)item.Element("zip"),
                        geolat = (string)item.Element("geolat"),
                       geolong = (string)item.Element("geolong"),
                    };

**olibara** · 06/03/2011, 18h51

Salut

Si a chaque question tu reponds a coté on ne vas pas en sortir facilement

1- Je te demandais que que tu voulais dire par "je ne parviens pas a parser"

Tu reponds en montrant le flux Json : ca n'explique pas ta difficulté

2 On te demande Json.Parse ca ressemble a quoi

Tu reponds en montrant de nouveau ta trame json : on tourne en rond ...

En tout cas ce que je peux te dire c'est que si le bout de code en commentaire de ton exemple c'est ce que tu avais exssayé alors c'est évident que ca ne vas pas le faire !

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
            foreach (JsonObject jo in k)
            {
 
            //     id = (string)item.Element("id"),
            //            name = (string)item.Element("name"),
            //            address = (string)item.Element("address"),
            //            city = (string)item.Element("city"),
            //            state = (string)item.Element("state"),
            //            zip = (string)item.Element("zip"),
            //            geolat = (string)item.Element("geolat"),
            //            geolong = (string)item.Element("geolong"),
            }

**techgeom** · 06/03/2011, 18h55

Ok, olibara.
Je souhaite simplement convertir le flux json Foursquare en objet.
Ais-je répondu à ta question?

Parser JSON C#

C#

Vue hybride

Discussions similaires

Partager

Partager