CODEWITHSUNDEEP
facebook-graph-apisortingfacebook-fqlfeedstatus
Michael
Michael

Reputation: 145

Find User's First Post?

Using the Graph API or FQL, is there a way to efficiently find a user's first post or status? As in, the first one they ever made?

The slow way, I assume, would be to paginate through the feed, but for users like me who joined in 2005 or earlier, that would take a very long time with a huge amount of API calls.

From what I have found, we cannot obtain the date the user registered with Facebook for a good starting point, and we cannot sort by date ascending (not outside of the single page of data returned) to get the oldest post on top.

Is there any reasonable way to do this?

Upvotes: 0

Views: 1604

Answers (2)

Durgaprasad Budhwani
Durgaprasad Budhwani

Reputation: 977

you can use facebook query language (FQL) to get first post information.

Please refer below query for more details :-

SELECT message, time FROM status WHERE uid= me() ORDER BY time ASC LIMIT 1

Please check and let me know in case of any issue.

Thanks and Regards Durgaprasad

Upvotes: 2

DMCS
DMCS

Reputation: 31880

I think the Public API is limited to the depth of information it is allowed to query. Facebook probably put in these constraints for performance and cost concerns. Maybe they've changed it. When I tried to go backwards thru a person's stream about 4 months ago, there seemed to be a limit as to how far back I could go. Maybe it's a time limit or a # posts back limit. If you know when your user first posted, then getting to it should be fairly quick using the since/until time stamps in your queries.

Upvotes: 1

Related Questions