(Excel) Azure Service Bus - Send Batch of Messages to Topic or Queue

See more Azure Service Bus Examples

Shows how to send a batch of messages to a service bus queue or topic.

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 topic (or queue) named "gilaMonster";

topicOrQueueName = "gilaMonster"

' The HTTP request body contains JSON that contains multiple messages.
Dim json As Chilkat.JsonObject
Set json = Chilkat.NewJsonObject
json.I = 0
success = json.UpdateString("messages[i].Body","This is the first message")
success = json.UpdateString("messages[i].BrokerProperties.Label","M1")
success = json.UpdateString("messages[i].BrokerProperties.TimeToLiveTimeSpan","0.00:00:40")

json.I = 1
success = json.UpdateString("messages[i].Body","This is the second message")
success = json.UpdateString("messages[i].BrokerProperties.Label","M2")
success = json.UpdateString("messages[i].UserProperties.Priority","Low")

json.I = 2
success = json.UpdateString("messages[i].Body","This is the third message")
success = json.UpdateString("messages[i].BrokerProperties.Label","M3")
success = json.UpdateString("messages[i].UserProperties.Priority","Medium")
success = json.UpdateString("messages[i].UserProperties.Customer","ABC")


Set jsonA = json.ArrayOf("messages")
jsonA.EmitCompact = False
Debug.Print jsonA.Emit()

' The following JSON array is produced by the above code:

' 	[
' 	  {
' 	    "Body": "This is the first message",
' 	    "BrokerProperties": {
' 	      "Label": "M1",
' 	      "TimeToLiveTimeSpan": "0.00:00:40"
' 	    }
' 	  },
' 	  {
' 	    "Body": "This is the second message",
' 	    "BrokerProperties": {
' 	      "Label": "M2"
' 	    },
' 	    "UserProperties": {
' 	      "Priority": "Low"
' 	    }
' 	  },
' 	  {
' 	    "Body": "This is the third message",
' 	    "BrokerProperties": {
' 	      "Label": "M3"
' 	    },
' 	    "UserProperties": {
' 	      "Priority": "Medium",
' 	      "Customer": "ABC"
' 	    }
' 	  }
' 	]

Dim sbRequestBody As Chilkat.StringBuilder
Set sbRequestBody = Chilkat.NewStringBuilder
jsonA.EmitCompact = True
success = jsonA.EmitSb(sbRequestBody)

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

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

' The Content-Type should be "application/vnd.microsoft.servicebus.json"
success = rest.AddHeader("Content-Type","application/vnd.microsoft.servicebus.json")

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."