DescribeReplicationTasks VB6 Example
' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.
Dim rest As New ChilkatRest
Dim success As Long
Dim authAws As New ChilkatAuthAws
authAws.AccessKey = "AWS_ACCESS_KEY"
authAws.SecretKey = "AWS_SECRET_KEY"
' Don't forget to change the region to your particular region. (Also make the same change in the call to Connect below.)
authAws.Region = "us-west-2"
authAws.ServiceName = "dms"
' SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
success = rest.SetAuthAws(authAws)
' URL: https://dms.us-west-2.amazonaws.com/
' Use the same region as specified above.
success = rest.Connect("dms.us-west-2.amazonaws.com",443,1,1)
If (success <> 1) Then
Debug.Print "ConnectFailReason: " & rest.ConnectFailReason
Debug.Print rest.LastErrorText
Exit Sub
End If
' The following code creates the JSON request body.
' The JSON created by this code is shown below.
' Use this online tool to generate code from sample JSON:
' Generate Code to Create JSON
Dim json As New ChilkatJsonObject
success = json.UpdateString("Filters[0].Name","string")
success = json.UpdateString("Filters[0].Values[0]","string")
success = json.UpdateString("Marker","string")
success = json.UpdateInt("MaxRecords",123)
success = json.UpdateInt("WithoutSettings",123)
' The JSON request body created by the above code:
' {
' "Filters": [
' {
' "Name": "string",
' "Values": [
' "string"
' ]
' }
' ],
' "Marker": "string",
' "MaxRecords": number,
' "WithoutSettings": boolean
' }
success = rest.AddHeader("Content-Type","application/x-amz-json-1.1")
success = rest.AddHeader("X-Amz-Target","AmazonDMSv20160101.DescribeReplicationTasks")
Dim sbRequestBody As New ChilkatStringBuilder
success = json.EmitSb(sbRequestBody)
Dim sbResponseBody As New ChilkatStringBuilder
success = rest.FullRequestSb("POST","/",sbRequestBody,sbResponseBody)
If (success <> 1) Then
Debug.Print rest.LastErrorText
Exit Sub
End If
Dim respStatusCode As Long
respStatusCode = rest.ResponseStatusCode
Debug.Print "response status code = " & respStatusCode
If (respStatusCode <> 200) Then
Debug.Print "Response Header:"
Debug.Print rest.ResponseHeader
Debug.Print "Response Body:"
Debug.Print sbResponseBody.GetAsString()
Exit Sub
End If
Dim jResp As New ChilkatJsonObject
success = jResp.LoadSb(sbResponseBody)
' The following code parses the JSON response.
' A sample JSON response is shown below the sample code.
' Use this online tool to generate parsing code from sample JSON:
' Generate Parsing Code from JSON
Dim CdcStartPosition As String
Dim CdcStopPosition As String
Dim LastFailureMessage As String
Dim MigrationType As String
Dim RecoveryCheckpoint As String
Dim ReplicationInstanceArn As String
Dim ReplicationTaskArn As String
Dim ReplicationTaskCreationDate As Long
Dim ReplicationTaskIdentifier As String
Dim ReplicationTaskSettings As String
Dim ReplicationTaskStartDate As Long
Dim ElapsedTimeMillis As Long
Dim FreshStartDate As Long
Dim FullLoadFinishDate As Long
Dim FullLoadProgressPercent As Long
Dim FullLoadStartDate As Long
Dim StartDate As Long
Dim StopDate As Long
Dim TablesErrored As Long
Dim TablesLoaded As Long
Dim TablesLoading As Long
Dim TablesQueued As Long
Dim SourceEndpointArn As String
Dim Status As String
Dim StopReason As String
Dim TableMappings As String
Dim TargetEndpointArn As String
Dim TargetReplicationInstanceArn As String
Dim TaskData As String
Dim Marker As String
Marker = jResp.StringOf("Marker")
Dim i As Long
i = 0
Dim count_i As Long
count_i = jResp.SizeOfArray("ReplicationTasks")
Do While i < count_i
jResp.I = i
CdcStartPosition = jResp.StringOf("ReplicationTasks[i].CdcStartPosition")
CdcStopPosition = jResp.StringOf("ReplicationTasks[i].CdcStopPosition")
LastFailureMessage = jResp.StringOf("ReplicationTasks[i].LastFailureMessage")
MigrationType = jResp.StringOf("ReplicationTasks[i].MigrationType")
RecoveryCheckpoint = jResp.StringOf("ReplicationTasks[i].RecoveryCheckpoint")
ReplicationInstanceArn = jResp.StringOf("ReplicationTasks[i].ReplicationInstanceArn")
ReplicationTaskArn = jResp.StringOf("ReplicationTasks[i].ReplicationTaskArn")
ReplicationTaskCreationDate = jResp.IntOf("ReplicationTasks[i].ReplicationTaskCreationDate")
ReplicationTaskIdentifier = jResp.StringOf("ReplicationTasks[i].ReplicationTaskIdentifier")
ReplicationTaskSettings = jResp.StringOf("ReplicationTasks[i].ReplicationTaskSettings")
ReplicationTaskStartDate = jResp.IntOf("ReplicationTasks[i].ReplicationTaskStartDate")
ElapsedTimeMillis = jResp.IntOf("ReplicationTasks[i].ReplicationTaskStats.ElapsedTimeMillis")
FreshStartDate = jResp.IntOf("ReplicationTasks[i].ReplicationTaskStats.FreshStartDate")
FullLoadFinishDate = jResp.IntOf("ReplicationTasks[i].ReplicationTaskStats.FullLoadFinishDate")
FullLoadProgressPercent = jResp.IntOf("ReplicationTasks[i].ReplicationTaskStats.FullLoadProgressPercent")
FullLoadStartDate = jResp.IntOf("ReplicationTasks[i].ReplicationTaskStats.FullLoadStartDate")
StartDate = jResp.IntOf("ReplicationTasks[i].ReplicationTaskStats.StartDate")
StopDate = jResp.IntOf("ReplicationTasks[i].ReplicationTaskStats.StopDate")
TablesErrored = jResp.IntOf("ReplicationTasks[i].ReplicationTaskStats.TablesErrored")
TablesLoaded = jResp.IntOf("ReplicationTasks[i].ReplicationTaskStats.TablesLoaded")
TablesLoading = jResp.IntOf("ReplicationTasks[i].ReplicationTaskStats.TablesLoading")
TablesQueued = jResp.IntOf("ReplicationTasks[i].ReplicationTaskStats.TablesQueued")
SourceEndpointArn = jResp.StringOf("ReplicationTasks[i].SourceEndpointArn")
Status = jResp.StringOf("ReplicationTasks[i].Status")
StopReason = jResp.StringOf("ReplicationTasks[i].StopReason")
TableMappings = jResp.StringOf("ReplicationTasks[i].TableMappings")
TargetEndpointArn = jResp.StringOf("ReplicationTasks[i].TargetEndpointArn")
TargetReplicationInstanceArn = jResp.StringOf("ReplicationTasks[i].TargetReplicationInstanceArn")
TaskData = jResp.StringOf("ReplicationTasks[i].TaskData")
i = i + 1
Loop
' A sample JSON response body parsed by the above code:
' {
' "Marker": "string",
' "ReplicationTasks": [
' {
' "CdcStartPosition": "string",
' "CdcStopPosition": "string",
' "LastFailureMessage": "string",
' "MigrationType": "string",
' "RecoveryCheckpoint": "string",
' "ReplicationInstanceArn": "string",
' "ReplicationTaskArn": "string",
' "ReplicationTaskCreationDate": number,
' "ReplicationTaskIdentifier": "string",
' "ReplicationTaskSettings": "string",
' "ReplicationTaskStartDate": number,
' "ReplicationTaskStats": {
' "ElapsedTimeMillis": number,
' "FreshStartDate": number,
' "FullLoadFinishDate": number,
' "FullLoadProgressPercent": number,
' "FullLoadStartDate": number,
' "StartDate": number,
' "StopDate": number,
' "TablesErrored": number,
' "TablesLoaded": number,
' "TablesLoading": number,
' "TablesQueued": number
' },
' "SourceEndpointArn": "string",
' "Status": "string",
' "StopReason": "string",
' "TableMappings": "string",
' "TargetEndpointArn": "string",
' "TargetReplicationInstanceArn": "string",
' "TaskData": "string"
' }
' ]
' }
