(SQL Server) Twitter - Tweet with Multiple Images

Example to post a status update with multiple associated images/photos (or videos).

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @iTmp0 int
    -- Important: Do not use nvarchar(max).  See the warning about using nvarchar(max).
    DECLARE @sTmp0 nvarchar(4000)
    -- This example 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..
    DECLARE @json int
    -- Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @json OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    DECLARE @success int
    EXEC sp_OAMethod @json, 'LoadFile', @success OUT, 'qa_data/tokens/twitter.json'

    DECLARE @rest int
    -- Use "Chilkat_9_5_0.Rest" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.Rest', @rest OUT

    DECLARE @oauth1 int
    -- Use "Chilkat_9_5_0.OAuth1" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.OAuth1', @oauth1 OUT

    EXEC sp_OASetProperty @oauth1, 'ConsumerKey', 'TWITTER_CONSUMER_KEY'
    EXEC sp_OASetProperty @oauth1, 'ConsumerSecret', 'TWITTER_CONSUMER_SECRET'
    EXEC sp_OAMethod @json, 'StringOf', @sTmp0 OUT, 'oauth_token'
    EXEC sp_OASetProperty @oauth1, 'Token', @sTmp0
    EXEC sp_OAMethod @json, 'StringOf', @sTmp0 OUT, 'oauth_token_secret'
    EXEC sp_OASetProperty @oauth1, 'TokenSecret', @sTmp0
    EXEC sp_OASetProperty @oauth1, 'SignatureMethod', 'HMAC-SHA1'
    EXEC sp_OAMethod @oauth1, 'GenNonce', @success OUT, 16

    EXEC sp_OAMethod @rest, 'SetAuthOAuth1', @success OUT, @oauth1, 0

    DECLARE @bAutoReconnect int
    SELECT @bAutoReconnect = 1
    EXEC sp_OAMethod @rest, 'Connect', @success OUT, 'api.twitter.com', 443, 1, @bAutoReconnect
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @rest, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @json
        EXEC @hr = sp_OADestroy @rest
        EXEC @hr = sp_OADestroy @oauth1
        RETURN
      END

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

    DECLARE @tweetContent nvarchar(4000)
    SELECT @tweetContent = 'This is a test tweet with multiple images.'

    -- Send a tweet...
    EXEC sp_OAMethod @rest, 'ClearAllQueryParams', @success OUT
    EXEC sp_OAMethod @rest, 'AddQueryParam', @success OUT, 'status', @tweetContent

    -- Add list of comma separated media_ids to associate with the Tweet. 
    -- You may include up to 4 photos or 1 animated GIF or 1 video in a Tweet.
    -- The image needs to have been previously uploaded.  The upload response gave us
    -- the media ID we'll use to associate this tweet with the image (or video)
    -- See Twitter Upload Media for sample code.
    EXEC sp_OAMethod @rest, 'AddQueryParam', @success OUT, 'media_ids', '793137045996646400,793192201392041984'

    DECLARE @resp nvarchar(4000)
    EXEC sp_OAMethod @rest, 'FullRequestFormUrlEncoded', @resp OUT, 'POST', '/1.1/statuses/update.json'
    EXEC sp_OAGetProperty @rest, 'LastMethodSuccess', @iTmp0 OUT
    IF @iTmp0 <> 1
      BEGIN
        EXEC sp_OAGetProperty @rest, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @json
        EXEC @hr = sp_OADestroy @rest
        EXEC @hr = sp_OADestroy @oauth1
        RETURN
      END

    DECLARE @jsonResponse int
    -- Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @jsonResponse OUT

    EXEC sp_OASetProperty @jsonResponse, 'EmitCompact', 0
    EXEC sp_OAMethod @jsonResponse, 'Load', @success OUT, @resp

    EXEC sp_OAGetProperty @rest, 'ResponseStatusCode', @iTmp0 OUT
    IF @iTmp0 <> 200
      BEGIN
        EXEC sp_OAMethod @jsonResponse, 'Emit', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @json
        EXEC @hr = sp_OADestroy @rest
        EXEC @hr = sp_OADestroy @oauth1
        EXEC @hr = sp_OADestroy @jsonResponse
        RETURN
      END

    -- Show the successful response:
    EXEC sp_OAMethod @jsonResponse, 'Emit', @sTmp0 OUT
    PRINT @sTmp0

    PRINT 'Success.'

    EXEC @hr = sp_OADestroy @json
    EXEC @hr = sp_OADestroy @rest
    EXEC @hr = sp_OADestroy @oauth1
    EXEC @hr = sp_OADestroy @jsonResponse


END
GO