Social Media Fetching via API.
We are in need of a programmer to develop Software to connect to API's of Youtube, Facebook and Twitter and fetch data from a list of users based in our SQL DB.
Main part is capturing data (and posting to SQL DB), second part is analysis information.
All API's need to capture -
Title (subject).
Full Text of post in html format (if in html)
We need links to original posts for all and original link to the user account.
All API's need to connect to master database for users and check for new changed info - Software needs to provide logs and alerts if accounts are wrong/expired.
Any DB (SQL) information will be provided to programmer selected for the project.
Programming language should be in PHP or VBSCRIPT. If you want to provide this in compile code then only C# is acceptable. Source code to be fully commented.
Twitter -
Twitter Stream API allows constant monitoring of users on list for constant new tweets.
Need 2 parts (if cant be on one system we can use a second computer with different IP address).
Live stream -
New tweet gets processed and posted to SQL database.
If Tweets have links - links are sent to [login to view URL] API and anything returned is added to "Full" wire text.
Old tweets
1. For new users we would like back data.
2. If for some reason we need to check for missed tweets in down time of live stream application.
We need capability for software to connect to Twitter regular API and check by user and by date/time range.
Twitter basic API is limited to 150 calls per hour so it will have to check up to 150 users per hour - if multiple new users are added.
Since Twitter has the 150 calls per hour limitation - if we want multiple accounts checked it needs to check 140 users per hour for all or new users as selected based on timeframe selected - Software will need to wait an hour+ and do next set of 140 and so on.
Analysis -
Twitter provides data of retweets, Favorited and mentioned information. We are looking for any of our users posts that are retweeted, Favorited and mentioned and sent to our DB - will send new post and link to new post and link of original post by our user to send back to our DB or the ID of the post we captured already.
Facebook
We have an API key/token - capture full post upload to DB.
We are not clear on call rate limitations - please check in Facebook documentation - we want them captured as live as possible as allowed by Facebook.
Analysis -
Any "likes", "Comments" - just need updating count - no need for who or what they said.
Youtube -
Full wire is if there is any text associated and the Youtube Embed code.
We are not clear on call rate limitations - please check in Youtube documentation - we want them captured as live as possible as allowed byYoutube .
Analysis -
Just number of views.
I have tried to give as much information as possible. If you have specific questiosn, feel free to ask them, but there isn't any more specifications. To be considered to this project, you MUST send a PM that starts with 'wire api'