What's new in Excel Add-In for Twitter 15.0.5816

Mar 29, 2016
  • Due to changes in the Twitter API, version 2 has a few changes that can break software developed with the previous version. These incompatibilities are mentioned below.
  • No Unauthenticated Requests
  • As of Twitter API 1.1, all requests now require authentication. This means that all tables now require an OAuthAccessToken and potentially an OAuthAccessTokenSecret. You can read about these changes here: https://dev.twitter.com/blog/changes-coming-to-twitter-api
  • Changes to tables
  • Due to changes in the Twitter API, some tables and columns have been removed or renamed due to either removal of features supported by the Twitter API or changes in how data is returned. Specifically these changes are:
  • DirectMessagesReceived:
  • Sender_URL renamed to Sender_Profile_URL.
  • Recipient_URL renamed to Recipient_Profile_URL.
  • DirectMessagesSent:
  • Sender_URL renamed to Sender_Profile_URL.
  • Recipient_URL renamed to Recipient_Profile_URL.
  • Favorites:
  • Geo, To_User_Name, Recent_Retweets columns removed.
  • User_URL renamed to From_User_Profile_URL.
  • Profile_Image_Url renamed to From_User_Profile_Image_URL.
  • Iso_Language_Code renamed to From_User_Lang.
  • User_Location renamed to From_User_Location.
  • Followers: URL renamed to Profile_URL.
  • Following: URL renamed to Profile_URL.
  • ListMembers: URL renamed to Profile_URL.
  • ListSubscribers: URL renamed to Profile_URL.
  • Mentions: User_URL renamed to User_Profile_URL.
  • Retweets:
  • Screen_Name and User_Id may no longer be used from the WHERE clause.
  • User_URL renamed to User_Profile_URL.
  • Trends: Table now requires either a Longitude and Latitude input or a Where on Earth Id to be specified.
  • TrendsWeekly: Table has been removed.
  • Tweets:
  • To_User_Name, Geo, Result_Type, Recent_Retweets columns removed.
  • From_User renamed to From_User_Screen_Name.
  • Iso_Language_Code renamed to From_User_Lang.
  • Profile_Image_URL renamed to From_User_Profile_Image_URL.
  • To_User renamed to To_User_Screen_Name.
  • User_Location renamed to From_User_Location.
  • User_URL renamed to From_User_Profile_URL.
  • Users: URL renamed to Profile_URL.
  • Other Changes
  • The following stored procedures and connection string properties have been renamed:
  • Connection String Properties
  • Token has been renamed to OAuthAccessToken.
  • SecretKey has been renamed to OAuthAccessTokenSecret.
  • ConsumerKey has been renamed to OAuthClientId.
  • ConsumerSecret has been renamed to OAuthClientSecret.
  • Stored Procedures
  • The Authenticate stored procedure has been renamed to GetOAuthAccessToken.
  • The AuthURL stored procedure has been renamed to GetOAuthAuthorizationURL.
  • The RemainingRequests stored procedure has been renamed to GetRemainingRequests.