(Excel) Azure Service Bus - Send Message to Queue

See more Azure Service Bus Examples

Demonstrates sending a message to an Azure Service Bus Queue.

Download Excel Class Modules Chilkat Excel Class Modules

' Note: Requires Chilkat v9.5.0.65 or greater.

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

' Make the initial connection.
' A single REST object, once connected, can be used for many Azure Service Bus REST API calls.
' The auto-reconnect indicates that if the already-established HTTPS connection is closed,
' then it will be automatically re-established as needed.
Dim rest As Chilkat.Rest
Set rest = Chilkat.NewRest

bAutoReconnect = True

success = rest.Connect("<yournamespace>.servicebus.windows.net",443,True,bAutoReconnect)
If (success <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

' ----------------------------------------------------------------------------------------------
' The code above this comment could be placed inside a function/subroutine within the application
' because the connection does not need to be made for every request.  Once the connection is made
' the app may send many requests..
' ----------------------------------------------------------------------------------------------

' Let's load a previously computed SAS token and use it.
' See Azure Shared Access Signature for an example to genenerate an Azure SAS token.
Dim sbToken As Chilkat.StringBuilder
Set sbToken = Chilkat.NewStringBuilder
Dim success As Boolean
success = sbToken.LoadFile("qa_data/tokens/serviceBusSas.txt","utf-8")

' Tell the REST object to use the Azure Shared Access Signature for authorization.
success = sbToken.Prepend("SharedAccessSignature ")
success = rest.AddHeader("Authorization",sbToken.GetAsString())

' ----------------------------------------------------------------------------------------------

' Send to a queue named "gila";

queueName = "gila"

' The HTTP request body contains the content of the message sent to the queue.
Dim sbRequestBody As Chilkat.StringBuilder
Set sbRequestBody = Chilkat.NewStringBuilder
success = sbRequestBody.Append("Hello, I'm a gila monster, and I may bite!")

' Build the path..
Dim sbPath As Chilkat.StringBuilder
Set sbPath = Chilkat.NewStringBuilder
success = sbPath.Append("/")
success = sbPath.Append(queueName)
success = sbPath.Append("/messages")

' Add timeout and api-version query parameters.
success = rest.AddQueryParam("timeout","20")
success = rest.AddQueryParam("api-version","2013-08")

' Standard brokered message properties are placed in a BrokerProperties HTTP header. 
' The broker properties must be serialized in JSON format. To specify a TimeToLive value of 3600 seconds 
' and to add a message label "M1" to the message..
Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
success = json.AppendInt("TimeToLive",3600)
success = json.AppendString("Label","M1")
success = rest.AddHeader("BrokerProperties",json.Emit())

' To add custom properties, such as "Priority" and "Color"
success = rest.AddHeader("Priority","High")
success = rest.AddHeader("Customer","12345")

Dim sbResponseBody As Chilkat.StringBuilder
Set sbResponseBody = Chilkat.NewStringBuilder
success = rest.FullRequestSb("POST",sbPath.GetAsString(),sbRequestBody,sbResponseBody)
If (success <> True) Then
    Debug.Print rest.LastErrorText
    Exit Sub
End If

Debug.Print "Response Status Code = "; rest.ResponseStatusCode

' Check for a success response.
If (rest.ResponseStatusCode <> 201) Then
    Debug.Print rest.LastRequestStartLine
    Debug.Print rest.LastRequestHeader
    Debug.Print sbResponseBody.GetAsString()
    Debug.Print "Failed."
    Exit Sub
End If

' If successful, the 201 response will have no response body.

Debug.Print "Success."