StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I can answer your question using FQL, which is on my opinion much simplier. I used FacebookWebclient, but FacebookClient should work the same way.</p> <p> FacebookWebClient fb = new FacebookWebClient(); </p> <pre><code>string query0 = "SELECT uid2 FROM friend WHERE uid1 = me()"; //here you get the friends list string query1 = "SELECT uid, message, status_id FROM status WHERE uid IN (SELECT uid2 FROM #query0)"; //here you get the last statuse of each friend (max 50, or max from the last 30 days) string query2 = "SELECT uid, name FROM user WHERE uid IN (SELECT uid FROM #query1)"; //here you get the user data (in this case the name only) dynamic result = fb.Query(query0, query1, query2); //all results dynamic status = result[1][1]; //results of query1 dynamic friend = result[2][1]; //results of query2 for (int i = 0; i < result[1][1].Count; i++) { litFeedback.Text += "<a href=\"http://www.facebook.com/profile.php?id=" + status[i].uid + "\" target=\"_blank\">" + friend[i].name + "</a> : " + status[i].message + "<br/>" + Environment.NewLine; } //if not using .net 4.0: //var result = (IList<object>)fb.Query(query1, query2); //var result0 = ((IDictionary<string, object>)result[0])["fql_result_set"]; //var result1 = ((IDictionary<string, object>)result[1])["fql_result_set"]; </code></pre> <p>Note:</p> <p><a href="http://developers.facebook.com/docs/reference/fql/status/" rel="nofollow">http://developers.facebook.com/docs/reference/fql/status/</a> <em>"The status table is limited to the last 30 days or 50 posts, whichever is greater."</em></p> <p>And of course you need the <strong>permissions</strong> for: <strong>friends_status</strong></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload