Chilkat Online Tools

DescribeTableStatistics VB.NET 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
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
    Debug.WriteLine("ConnectFailReason: " & rest.ConnectFailReason)
    Debug.WriteLine(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 Chilkat.JsonObject
json.UpdateString("Filters[0].Name","string")
json.UpdateString("Filters[0].Values[0]","string")
json.UpdateString("Marker","string")
json.UpdateInt("MaxRecords",123)
json.UpdateString("ReplicationTaskArn","string")

' The JSON request body created by the above code:

' {
'   "Filters": [
'     {
'       "Name": "string",
'       "Values": [
'         "string"
'       ]
'     }
'   ],
'   "Marker": "string",
'   "MaxRecords": number,
'   "ReplicationTaskArn": "string"
' }

rest.AddHeader("Content-Type","application/x-amz-json-1.1")
rest.AddHeader("X-Amz-Target","AmazonDMSv20160101.DescribeTableStatistics")

Dim sbRequestBody As New Chilkat.StringBuilder
json.EmitSb(sbRequestBody)
Dim sbResponseBody As New Chilkat.StringBuilder
success = rest.FullRequestSb("POST","/",sbRequestBody,sbResponseBody)
If (success <> True) Then
    Debug.WriteLine(rest.LastErrorText)
    Exit Sub
End If

Dim respStatusCode As Integer = rest.ResponseStatusCode
Debug.WriteLine("response status code = " & respStatusCode)
If (respStatusCode <> 200) Then
    Debug.WriteLine("Response Header:")
    Debug.WriteLine(rest.ResponseHeader)
    Debug.WriteLine("Response Body:")
    Debug.WriteLine(sbResponseBody.GetAsString())
    Exit Sub
End If


Dim jResp As New Chilkat.JsonObject
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 Ddls As Integer
Dim Deletes As Integer
Dim FullLoadCondtnlChkFailedRows As Integer
Dim FullLoadEndTime As Integer
Dim FullLoadErrorRows As Integer
Dim FullLoadReloaded As Integer
Dim FullLoadRows As Integer
Dim FullLoadStartTime As Integer
Dim Inserts As Integer
Dim LastUpdateTime As Integer
Dim SchemaName As String
Dim TableName As String
Dim TableState As String
Dim Updates As Integer
Dim ValidationFailedRecords As Integer
Dim ValidationPendingRecords As Integer
Dim ValidationState As String
Dim ValidationStateDetails As String
Dim ValidationSuspendedRecords As Integer

Dim Marker As String = jResp.StringOf("Marker")
Dim ReplicationTaskArn As String = jResp.StringOf("ReplicationTaskArn")
Dim i As Integer = 0
Dim count_i As Integer = jResp.SizeOfArray("TableStatistics")
While i < count_i
    jResp.I = i
    Ddls = jResp.IntOf("TableStatistics[i].Ddls")
    Deletes = jResp.IntOf("TableStatistics[i].Deletes")
    FullLoadCondtnlChkFailedRows = jResp.IntOf("TableStatistics[i].FullLoadCondtnlChkFailedRows")
    FullLoadEndTime = jResp.IntOf("TableStatistics[i].FullLoadEndTime")
    FullLoadErrorRows = jResp.IntOf("TableStatistics[i].FullLoadErrorRows")
    FullLoadReloaded = jResp.IntOf("TableStatistics[i].FullLoadReloaded")
    FullLoadRows = jResp.IntOf("TableStatistics[i].FullLoadRows")
    FullLoadStartTime = jResp.IntOf("TableStatistics[i].FullLoadStartTime")
    Inserts = jResp.IntOf("TableStatistics[i].Inserts")
    LastUpdateTime = jResp.IntOf("TableStatistics[i].LastUpdateTime")
    SchemaName = jResp.StringOf("TableStatistics[i].SchemaName")
    TableName = jResp.StringOf("TableStatistics[i].TableName")
    TableState = jResp.StringOf("TableStatistics[i].TableState")
    Updates = jResp.IntOf("TableStatistics[i].Updates")
    ValidationFailedRecords = jResp.IntOf("TableStatistics[i].ValidationFailedRecords")
    ValidationPendingRecords = jResp.IntOf("TableStatistics[i].ValidationPendingRecords")
    ValidationState = jResp.StringOf("TableStatistics[i].ValidationState")
    ValidationStateDetails = jResp.StringOf("TableStatistics[i].ValidationStateDetails")
    ValidationSuspendedRecords = jResp.IntOf("TableStatistics[i].ValidationSuspendedRecords")
    i = i + 1
End While


' A sample JSON response body parsed by the above code:

' {
'   "Marker": "string",
'   "ReplicationTaskArn": "string",
'   "TableStatistics": [
'     {
'       "Ddls": number,
'       "Deletes": number,
'       "FullLoadCondtnlChkFailedRows": number,
'       "FullLoadEndTime": number,
'       "FullLoadErrorRows": number,
'       "FullLoadReloaded": boolean,
'       "FullLoadRows": number,
'       "FullLoadStartTime": number,
'       "Inserts": number,
'       "LastUpdateTime": number,
'       "SchemaName": "string",
'       "TableName": "string",
'       "TableState": "string",
'       "Updates": number,
'       "ValidationFailedRecords": number,
'       "ValidationPendingRecords": number,
'       "ValidationState": "string",
'       "ValidationStateDetails": "string",
'       "ValidationSuspendedRecords": number
'     }
'   ]
' }