Chilkat Examples

ChilkatHOMEAndroid™Classic ASPCC++C#Mono C#.NET Core C#C# UWP/WinRTDataFlexDelphi ActiveXDelphi DLLVisual FoxProJavaLianjaMFCObjective-CPerlPHP ActiveXPHP ExtensionPowerBuilderPowerShellPureBasicCkPythonChilkat2-PythonRubySQL ServerSwift 2Swift 3/4TclUnicode CUnicode C++Visual Basic 6.0VB.NETVB.NET UWP/WinRTVBScriptXojo PluginNode.jsExcelGo

Excel Web API Examples

Primary Categories

CardConnect
Facebook
GeoOp
Jira
Microsoft Calendar
PayPal
Peoplevox

QuickBooks
Shopify
Stripe
SugarCRM
Twitter
VoiceBase
Walmart
Xero
eBay
effectconnect

 

 

 

(Excel) Twitter - Application Only Authentication

Demonstrates how to get a Twitter OAuth2 token for application-only authentication.

This allows you to issue authenticated requests on behalf of the application itself (as opposed to on behalf of a specific user). You don’t have the context of an authenticated user and this means that any request to API for endpoints that require user context, such as posting Tweets, will not work. However, the set of endpoints that will still be available can have a higher rate limit.

Your app will be able to, for example:

  • Pull user timelines;
  • Access friends and followers of any account;
  • Access lists resources;
  • Search in Tweets;
  • Retrieve any user information;

And it will not be able to:

  • Post Tweets or other resources;
  • Connect to Streaming endpoints;
  • Search for users;
  • Use any geo endpoint;
  • Access Direct Messages or account credentials;

Download Excel Class Modules

Chilkat Excel Class Modules

' It requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

' Note: Define your Twitter apps at https://apps.twitter.com/

' We're going to send an HTTPS POST that looks like this:

' POST /oauth2/token HTTP/1.1
' Host: api.twitter.com
' User-Agent: My Twitter App v1.0.23
' Authorization: Basic eHZ6MWV2RlM0d0VFUFRHRUZQSEJvZzpMOHFxOVBaeVJn
'                      NmllS0dFS2hab2xHQzB2SldMdzhpRUo4OERSZHlPZw==
' Content-Type: application/x-www-form-urlencoded;charset=UTF-8
' Content-Length: 29
' Accept-Encoding: gzip
' 
' grant_type=client_credentials

' Update these values with your consumer key and secret (also known as API key and API secret).

consumerKey = "TWITTER_CONSUMER_KEY"

consumerSecret = "TWITTER_CONSUMER_SECRET"

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

http.BasicAuth = True
http.Login = consumerKey
http.Password = consumerSecret

Dim req As Chilkat.HttpRequest
Set req = Chilkat.NewHttpRequest
req.AddParam "grant_type","client_credentials"


Set resp = http.PostUrlEncoded("https://api.twitter.com/oauth2/token",req)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print "Response Status Code: "; resp.StatusCode

If (resp.StatusCode <> 200) Then
    Debug.Print "Expected a 200 response status code for success."
    Debug.Print resp.BodyStr
    Exit Sub
End If

' We should get a JSON response like this:

' {
'     "token_type":"bearer",
'     "access_token":"..."
' }

Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
Dim success As Boolean
success = json.Load(resp.BodyStr)

Debug.Print "Access token = "; json.StringOf("access_token")


 

© 2000-2019 Chilkat Software, Inc. All Rights Reserved.