Chilkat Online Tools

DescribeReplicationInstances VBScript Example

AWS Database Migration Service

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
Set outFile = fso.CreateTextFile("output.txt", True)

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

set rest = CreateObject("Chilkat_9_5_0.Rest")

set authAws = CreateObject("Chilkat_9_5_0.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,1,1)
If (success <> 1) Then
    outFile.WriteLine("ConnectFailReason: " & rest.ConnectFailReason)
    outFile.WriteLine(rest.LastErrorText)
    WScript.Quit
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

set json = CreateObject("Chilkat_9_5_0.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)

' The JSON request body created by the above code:

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

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

set sbRequestBody = CreateObject("Chilkat_9_5_0.StringBuilder")
success = json.EmitSb(sbRequestBody)
set sbResponseBody = CreateObject("Chilkat_9_5_0.StringBuilder")
success = rest.FullRequestSb("POST","/",sbRequestBody,sbResponseBody)
If (success <> 1) Then
    outFile.WriteLine(rest.LastErrorText)
    WScript.Quit
End If

respStatusCode = rest.ResponseStatusCode
outFile.WriteLine("response status code = " & respStatusCode)
If (respStatusCode <> 200) Then
    outFile.WriteLine("Response Header:")
    outFile.WriteLine(rest.ResponseHeader)
    outFile.WriteLine("Response Body:")
    outFile.WriteLine(sbResponseBody.GetAsString())
    WScript.Quit
End If

set jResp = CreateObject("Chilkat_9_5_0.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

Marker = jResp.StringOf("Marker")
i = 0
count_i = jResp.SizeOfArray("ReplicationInstances")
Do While i < count_i
    jResp.I = i
    AllocatedStorage = jResp.IntOf("ReplicationInstances[i].AllocatedStorage")
    AutoMinorVersionUpgrade = jResp.IntOf("ReplicationInstances[i].AutoMinorVersionUpgrade")
    AvailabilityZone = jResp.StringOf("ReplicationInstances[i].AvailabilityZone")
    DnsNameServers = jResp.StringOf("ReplicationInstances[i].DnsNameServers")
    EngineVersion = jResp.StringOf("ReplicationInstances[i].EngineVersion")
    FreeUntil = jResp.IntOf("ReplicationInstances[i].FreeUntil")
    InstanceCreateTime = jResp.IntOf("ReplicationInstances[i].InstanceCreateTime")
    KmsKeyId = jResp.StringOf("ReplicationInstances[i].KmsKeyId")
    MultiAZ = jResp.IntOf("ReplicationInstances[i].MultiAZ")
    PendingModifiedValuesAllocatedStorage = jResp.IntOf("ReplicationInstances[i].PendingModifiedValues.AllocatedStorage")
    PendingModifiedValuesEngineVersion = jResp.StringOf("ReplicationInstances[i].PendingModifiedValues.EngineVersion")
    PendingModifiedValuesMultiAZ = jResp.IntOf("ReplicationInstances[i].PendingModifiedValues.MultiAZ")
    ReplicationInstanceClass = jResp.StringOf("ReplicationInstances[i].PendingModifiedValues.ReplicationInstanceClass")
    PreferredMaintenanceWindow = jResp.StringOf("ReplicationInstances[i].PreferredMaintenanceWindow")
    PubliclyAccessible = jResp.IntOf("ReplicationInstances[i].PubliclyAccessible")
    ReplicationInstanceArn = jResp.StringOf("ReplicationInstances[i].ReplicationInstanceArn")
    ReplicationInstanceClass = jResp.StringOf("ReplicationInstances[i].ReplicationInstanceClass")
    ReplicationInstanceIdentifier = jResp.StringOf("ReplicationInstances[i].ReplicationInstanceIdentifier")
    ReplicationInstancePrivateIpAddress = jResp.StringOf("ReplicationInstances[i].ReplicationInstancePrivateIpAddress")
    ReplicationInstancePublicIpAddress = jResp.StringOf("ReplicationInstances[i].ReplicationInstancePublicIpAddress")
    ReplicationInstanceStatus = jResp.StringOf("ReplicationInstances[i].ReplicationInstanceStatus")
    ReplicationSubnetGroupDescription = jResp.StringOf("ReplicationInstances[i].ReplicationSubnetGroup.ReplicationSubnetGroupDescription")
    ReplicationSubnetGroupIdentifier = jResp.StringOf("ReplicationInstances[i].ReplicationSubnetGroup.ReplicationSubnetGroupIdentifier")
    SubnetGroupStatus = jResp.StringOf("ReplicationInstances[i].ReplicationSubnetGroup.SubnetGroupStatus")
    VpcId = jResp.StringOf("ReplicationInstances[i].ReplicationSubnetGroup.VpcId")
    SecondaryAvailabilityZone = jResp.StringOf("ReplicationInstances[i].SecondaryAvailabilityZone")
    j = 0
    count_j = jResp.SizeOfArray("ReplicationInstances[i].ReplicationInstancePrivateIpAddresses")
    Do While j < count_j
        jResp.J = j
        strVal = jResp.StringOf("ReplicationInstances[i].ReplicationInstancePrivateIpAddresses[j]")
        j = j + 1
    Loop
    j = 0
    count_j = jResp.SizeOfArray("ReplicationInstances[i].ReplicationInstancePublicIpAddresses")
    Do While j < count_j
        jResp.J = j
        strVal = jResp.StringOf("ReplicationInstances[i].ReplicationInstancePublicIpAddresses[j]")
        j = j + 1
    Loop
    j = 0
    count_j = jResp.SizeOfArray("ReplicationInstances[i].ReplicationSubnetGroup.Subnets")
    Do While j < count_j
        jResp.J = j
        Name = jResp.StringOf("ReplicationInstances[i].ReplicationSubnetGroup.Subnets[j].SubnetAvailabilityZone.Name")
        SubnetIdentifier = jResp.StringOf("ReplicationInstances[i].ReplicationSubnetGroup.Subnets[j].SubnetIdentifier")
        SubnetStatus = jResp.StringOf("ReplicationInstances[i].ReplicationSubnetGroup.Subnets[j].SubnetStatus")
        j = j + 1
    Loop
    j = 0
    count_j = jResp.SizeOfArray("ReplicationInstances[i].VpcSecurityGroups")
    Do While j < count_j
        jResp.J = j
        Status = jResp.StringOf("ReplicationInstances[i].VpcSecurityGroups[j].Status")
        VpcSecurityGroupId = jResp.StringOf("ReplicationInstances[i].VpcSecurityGroups[j].VpcSecurityGroupId")
        j = j + 1
    Loop
    i = i + 1
Loop

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

' {
'   "Marker": "string",
'   "ReplicationInstances": [
'     {
'       "AllocatedStorage": number,
'       "AutoMinorVersionUpgrade": boolean,
'       "AvailabilityZone": "string",
'       "DnsNameServers": "string",
'       "EngineVersion": "string",
'       "FreeUntil": number,
'       "InstanceCreateTime": number,
'       "KmsKeyId": "string",
'       "MultiAZ": boolean,
'       "PendingModifiedValues": {
'         "AllocatedStorage": number,
'         "EngineVersion": "string",
'         "MultiAZ": boolean,
'         "ReplicationInstanceClass": "string"
'       },
'       "PreferredMaintenanceWindow": "string",
'       "PubliclyAccessible": boolean,
'       "ReplicationInstanceArn": "string",
'       "ReplicationInstanceClass": "string",
'       "ReplicationInstanceIdentifier": "string",
'       "ReplicationInstancePrivateIpAddress": "string",
'       "ReplicationInstancePrivateIpAddresses": [
'         "string"
'       ],
'       "ReplicationInstancePublicIpAddress": "string",
'       "ReplicationInstancePublicIpAddresses": [
'         "string"
'       ],
'       "ReplicationInstanceStatus": "string",
'       "ReplicationSubnetGroup": {
'         "ReplicationSubnetGroupDescription": "string",
'         "ReplicationSubnetGroupIdentifier": "string",
'         "SubnetGroupStatus": "string",
'         "Subnets": [
'           {
'             "SubnetAvailabilityZone": {
'               "Name": "string"
'             },
'             "SubnetIdentifier": "string",
'             "SubnetStatus": "string"
'           }
'         ],
'         "VpcId": "string"
'       },
'       "SecondaryAvailabilityZone": "string",
'       "VpcSecurityGroups": [
'         {
'           "Status": "string",
'           "VpcSecurityGroupId": "string"
'         }
'       ]
'     }
'   ]
' }

outFile.Close