FQL NoIndexFunctionException 605 error in indexed column

Question

I'm trying to:

SELECT developer_id FROM app_role WHERE application_id='MY APP ID' 

Using a valid token marked with https://developers.facebook.com/tools/explorer

I get this back:

 { "error": { "message": "Invalid application_id in WHERE clause", "type": "NoIndexFunctionException", "code": 604 } } 

Now. application_id is definitely correct. The authentication token is verified and associated with this application identifier, and as far as I can see, application_id is fully indexed.

Any ideas what grief is? Thanks.

Answer 1

This is because you need an application access token. Get it like this:

 GET https://graph.facebook.com/oauth/access_token? client_id=YOUR_APP_ID &client_secret=YOUR_APP_SECRET &grant_type=client_credentials 

Source: https://developers.facebook.com/docs/opengraph/howtos/publishing-with-app-token/

Then use the same FQL query:

 SELECT developer_id FROM app_role WHERE application_id='MY APP ID' 

And here you are:

 { "data": [ { "developer_id": "1234567890" }, { "developer_id": "9876543210" } ] }