Chilkat Online Tools

DescribeReplicationTasks Xojo Example

AWS Database Migration Service

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

Dim rest As New Chilkat.Rest
Dim success As Boolean

Dim authAws As New Chilkat.AuthAws
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,True,True)
If (success <> True) Then
    System.DebugLog("ConnectFailReason: " + Str(rest.ConnectFailReason))
    System.DebugLog(rest.LastErrorText)
    Return
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 Chilkat.JsonObject
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 Chilkat.StringBuilder
success = json.EmitSb(sbRequestBody)
Dim sbResponseBody As New Chilkat.StringBuilder
success = rest.FullRequestSb("POST","/",sbRequestBody,sbResponseBody)
If (success <> True) Then
    System.DebugLog(rest.LastErrorText)
    Return
End If

Dim respStatusCode As Int32
respStatusCode = rest.ResponseStatusCode
System.DebugLog("response status code = " + Str(respStatusCode))
If (respStatusCode <> 200) Then
    System.DebugLog("Response Header:")
    System.DebugLog(rest.ResponseHeader)
    System.DebugLog("Response Body:")
    System.DebugLog(sbResponseBody.GetAsString())
    Return
End If

Dim jResp As New Chilkat.JsonObject
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 Int32
Dim ReplicationTaskIdentifier As String
Dim ReplicationTaskSettings As String
Dim ReplicationTaskStartDate As Int32
Dim ElapsedTimeMillis As Int32
Dim FreshStartDate As Int32
Dim FullLoadFinishDate As Int32
Dim FullLoadProgressPercent As Int32
Dim FullLoadStartDate As Int32
Dim StartDate As Int32
Dim StopDate As Int32
Dim TablesErrored As Int32
Dim TablesLoaded As Int32
Dim TablesLoading As Int32
Dim TablesQueued As Int32
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 Int32
i = 0
Dim count_i As Int32
count_i = jResp.SizeOfArray("ReplicationTasks")
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
Wend

// 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"
//     }
//   ]
// }