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

Facebook
GeoOp
Jira
PayPal
Peoplevox
QuickBooks

Shopify
Stripe
SugarCRM
Twitter
VoiceBase
Walmart
Xero
eBay
effectconnect

 

 

 

(Excel) Emoji Tweet

Demonstrates posting a status update that includes an emoji character.

Download Excel Class Modules

Chilkat Excel Class Modules

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

' ----------------------------------------------------------------------
' This initial setup, which involves setting the OAuth1 properties and connecting
' to api.twitter.com, is only required once at the beginning.  Once connected, the same
' object instance may be re-used, and if necessary, it will automatically reconnect
' as needed.

' Assume we've previously obtained an access token and saved it to a JSON file..
Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject

success = json.LoadFile("qa_data/tokens/twitter.json")

Dim rest As Chilkat.Rest
Set rest = Chilkat.NewRest
Dim oauth1 As Chilkat.OAuth1
Set oauth1 = Chilkat.NewOAuth1

oauth1.ConsumerKey = "TWITTER_CONSUMER_KEY"
oauth1.ConsumerSecret = "TWITTER_CONSUMER_SECRET"
oauth1.Token = json.StringOf("oauth_token")
oauth1.TokenSecret = json.StringOf("oauth_token_secret")
oauth1.SignatureMethod = "HMAC-SHA1"
success = oauth1.GenNonce(16)

success = rest.SetAuthOAuth1(oauth1,False)


bAutoReconnect = True
success = rest.Connect("api.twitter.com",443,True,bAutoReconnect)
If (success <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' This ends the initial setup...
' ----------------------------------------------------------------------

' For this example, I've pre-created a text file containing two emoji
' characters (the "ghost" emoji, and a "face savouring delicious food" emoji).  
' This text file was saved using the utf-8 encoding.

' The utf-8 bytes for the ghost emoji are 0x9f 0x91 0xbb.  (Note: This is the utf-8
' representation that does not use surrogate pairs.)
' 
' The utf-8 bytes for the "face savouring delicious food" emoji are \xF0\x9F\x98\x8B.

Dim sbText As Chilkat.StringBuilder
Set sbText = Chilkat.NewStringBuilder
success = sbText.LoadFile("qa_data/txt/ghost_emoji.txt","utf-8")
success = sbText.Prepend("Test tweet using two emoji chars: ")

' Send a tweet...
success = rest.ClearAllQueryParams()
success = rest.AddQueryParam("status",sbText.GetAsString())

resp = rest.FullRequestFormUrlEncoded("POST","/1.1/statuses/update.json")
If (rest.LastMethodSuccess <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

Dim jsonResponse As Chilkat.JsonObject
Set jsonResponse = Chilkat.NewJsonObject
jsonResponse.EmitCompact = False
success = jsonResponse.Load(resp)

If (rest.ResponseStatusCode <> 200) Then
    Debug.Print jsonResponse.Emit()
    Exit Sub
End If

' Show the successful response:
Debug.Print jsonResponse.Emit()
Debug.Print "Success."

 

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