Facebook FQL multiquery by stream and user info

Question

I am going to create an FQL query to retrieve all my friends' messages with full name and email. Therefore, I created multiscreen FQL (as shown below), but again I get an empty result (tried to put it in the Graph API):

"query1":"SELECT actor_id, message FROM stream WHERE filter_key IN (SELECT filter_key FROM stream_filter WHERE uid = me()) AND actor_id IN (SELECT uid2 FROM friend WHERE uid1 = me())" "query2":"SELECT uid, name FROM user WHERE uid IN (SELECT actor_id FROM #query1)" 

Has anyone understood how I can do this correctly?

Does multiquery work in Graph API Explorer at all?

Answer 1

You need to provide the request as a JSON object, you are missing the object notation ( {...} ) and the comma between the requests.

It works:

 {"query1": "SELECT actor_id, message FROM stream WHERE filter_key IN (SELECT filter_key FROM stream_filter WHERE uid = me()) AND actor_id IN (SELECT uid2 FROM friend WHERE uid1 = me())", "query2":"SELECT uid, name FROM user WHERE uid IN (SELECT actor_id FROM #query1)"}