Chilkat Online Tools

DeleteReplicationInstance Foxpro Example

AWS Database Migration Service

LOCAL loRest
LOCAL lnSuccess
LOCAL loAuthAws
LOCAL loJson
LOCAL loSbRequestBody
LOCAL loSbResponseBody
LOCAL lnRespStatusCode
LOCAL loJResp
LOCAL lcStrVal
LOCAL lcName
LOCAL lcSubnetIdentifier
LOCAL lcSubnetStatus
LOCAL lcStatus
LOCAL lcVpcSecurityGroupId
LOCAL lnAllocatedStorage
LOCAL lnAutoMinorVersionUpgrade
LOCAL lcAvailabilityZone
LOCAL lcDnsNameServers
LOCAL lcEngineVersion
LOCAL lnFreeUntil
LOCAL lnInstanceCreateTime
LOCAL lcKmsKeyId
LOCAL lnMultiAZ
LOCAL lnPendingModifiedValuesAllocatedStorage
LOCAL lcPendingModifiedValuesEngineVersion
LOCAL lnPendingModifiedValuesMultiAZ
LOCAL lcReplicationInstanceClass
LOCAL lcPreferredMaintenanceWindow
LOCAL lnPubliclyAccessible
LOCAL lcReplicationInstanceArn
LOCAL lcReplicationInstanceReplicationInstanceClass
LOCAL lcReplicationInstanceIdentifier
LOCAL lcReplicationInstancePrivateIpAddress
LOCAL lcReplicationInstancePublicIpAddress
LOCAL lcReplicationInstanceStatus
LOCAL lcReplicationSubnetGroupDescription
LOCAL lcReplicationSubnetGroupIdentifier
LOCAL lcSubnetGroupStatus
LOCAL lcVpcId
LOCAL lcSecondaryAvailabilityZone
LOCAL i
LOCAL lnCount_i

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

loRest = CreateObject('Chilkat_9_5_0.Rest')

loAuthAws = CreateObject('Chilkat_9_5_0.AuthAws')
loAuthAws.AccessKey = "AWS_ACCESS_KEY"
loAuthAws.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.)
loAuthAws.Region = "us-west-2"
loAuthAws.ServiceName = "dms"
* SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
loRest.SetAuthAws(loAuthAws)

* URL: https://dms.us-west-2.amazonaws.com/
* Use the same region as specified above.
lnSuccess = loRest.Connect("dms.us-west-2.amazonaws.com",443,1,1)
IF (lnSuccess <> 1) THEN
    ? "ConnectFailReason: " + STR(loRest.ConnectFailReason)
    ? loRest.LastErrorText
    RELEASE loRest
    RELEASE loAuthAws
    CANCEL
ENDIF

* 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

loJson = CreateObject('Chilkat_9_5_0.JsonObject')
loJson.UpdateString("ReplicationInstanceArn","string")

* The JSON request body created by the above code:

* {
*   "ReplicationInstanceArn": "string"
* }

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

loSbRequestBody = CreateObject('Chilkat_9_5_0.StringBuilder')
loJson.EmitSb(loSbRequestBody)
loSbResponseBody = CreateObject('Chilkat_9_5_0.StringBuilder')
lnSuccess = loRest.FullRequestSb("POST","/",loSbRequestBody,loSbResponseBody)
IF (lnSuccess <> 1) THEN
    ? loRest.LastErrorText
    RELEASE loRest
    RELEASE loAuthAws
    RELEASE loJson
    RELEASE loSbRequestBody
    RELEASE loSbResponseBody
    CANCEL
ENDIF

lnRespStatusCode = loRest.ResponseStatusCode
? "response status code = " + STR(lnRespStatusCode)
IF (lnRespStatusCode <> 200) THEN
    ? "Response Header:"
    ? loRest.ResponseHeader
    ? "Response Body:"
    ? loSbResponseBody.GetAsString()
    RELEASE loRest
    RELEASE loAuthAws
    RELEASE loJson
    RELEASE loSbRequestBody
    RELEASE loSbResponseBody
    CANCEL
ENDIF

loJResp = CreateObject('Chilkat_9_5_0.JsonObject')
loJResp.LoadSb(loSbResponseBody)

* 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

lnAllocatedStorage = loJResp.IntOf("ReplicationInstance.AllocatedStorage")
lnAutoMinorVersionUpgrade = loJResp.IntOf("ReplicationInstance.AutoMinorVersionUpgrade")
lcAvailabilityZone = loJResp.StringOf("ReplicationInstance.AvailabilityZone")
lcDnsNameServers = loJResp.StringOf("ReplicationInstance.DnsNameServers")
lcEngineVersion = loJResp.StringOf("ReplicationInstance.EngineVersion")
lnFreeUntil = loJResp.IntOf("ReplicationInstance.FreeUntil")
lnInstanceCreateTime = loJResp.IntOf("ReplicationInstance.InstanceCreateTime")
lcKmsKeyId = loJResp.StringOf("ReplicationInstance.KmsKeyId")
lnMultiAZ = loJResp.IntOf("ReplicationInstance.MultiAZ")
lnPendingModifiedValuesAllocatedStorage = loJResp.IntOf("ReplicationInstance.PendingModifiedValues.AllocatedStorage")
lcPendingModifiedValuesEngineVersion = loJResp.StringOf("ReplicationInstance.PendingModifiedValues.EngineVersion")
lnPendingModifiedValuesMultiAZ = loJResp.IntOf("ReplicationInstance.PendingModifiedValues.MultiAZ")
lcReplicationInstanceClass = loJResp.StringOf("ReplicationInstance.PendingModifiedValues.ReplicationInstanceClass")
lcPreferredMaintenanceWindow = loJResp.StringOf("ReplicationInstance.PreferredMaintenanceWindow")
lnPubliclyAccessible = loJResp.IntOf("ReplicationInstance.PubliclyAccessible")
lcReplicationInstanceArn = loJResp.StringOf("ReplicationInstance.ReplicationInstanceArn")
lcReplicationInstanceReplicationInstanceClass = loJResp.StringOf("ReplicationInstance.ReplicationInstanceClass")
lcReplicationInstanceIdentifier = loJResp.StringOf("ReplicationInstance.ReplicationInstanceIdentifier")
lcReplicationInstancePrivateIpAddress = loJResp.StringOf("ReplicationInstance.ReplicationInstancePrivateIpAddress")
lcReplicationInstancePublicIpAddress = loJResp.StringOf("ReplicationInstance.ReplicationInstancePublicIpAddress")
lcReplicationInstanceStatus = loJResp.StringOf("ReplicationInstance.ReplicationInstanceStatus")
lcReplicationSubnetGroupDescription = loJResp.StringOf("ReplicationInstance.ReplicationSubnetGroup.ReplicationSubnetGroupDescription")
lcReplicationSubnetGroupIdentifier = loJResp.StringOf("ReplicationInstance.ReplicationSubnetGroup.ReplicationSubnetGroupIdentifier")
lcSubnetGroupStatus = loJResp.StringOf("ReplicationInstance.ReplicationSubnetGroup.SubnetGroupStatus")
lcVpcId = loJResp.StringOf("ReplicationInstance.ReplicationSubnetGroup.VpcId")
lcSecondaryAvailabilityZone = loJResp.StringOf("ReplicationInstance.SecondaryAvailabilityZone")
i = 0
lnCount_i = loJResp.SizeOfArray("ReplicationInstance.ReplicationInstancePrivateIpAddresses")
DO WHILE i < lnCount_i
    loJResp.I = i
    lcStrVal = loJResp.StringOf("ReplicationInstance.ReplicationInstancePrivateIpAddresses[i]")
    i = i + 1
ENDDO
i = 0
lnCount_i = loJResp.SizeOfArray("ReplicationInstance.ReplicationInstancePublicIpAddresses")
DO WHILE i < lnCount_i
    loJResp.I = i
    lcStrVal = loJResp.StringOf("ReplicationInstance.ReplicationInstancePublicIpAddresses[i]")
    i = i + 1
ENDDO
i = 0
lnCount_i = loJResp.SizeOfArray("ReplicationInstance.ReplicationSubnetGroup.Subnets")
DO WHILE i < lnCount_i
    loJResp.I = i
    lcName = loJResp.StringOf("ReplicationInstance.ReplicationSubnetGroup.Subnets[i].SubnetAvailabilityZone.Name")
    lcSubnetIdentifier = loJResp.StringOf("ReplicationInstance.ReplicationSubnetGroup.Subnets[i].SubnetIdentifier")
    lcSubnetStatus = loJResp.StringOf("ReplicationInstance.ReplicationSubnetGroup.Subnets[i].SubnetStatus")
    i = i + 1
ENDDO
i = 0
lnCount_i = loJResp.SizeOfArray("ReplicationInstance.VpcSecurityGroups")
DO WHILE i < lnCount_i
    loJResp.I = i
    lcStatus = loJResp.StringOf("ReplicationInstance.VpcSecurityGroups[i].Status")
    lcVpcSecurityGroupId = loJResp.StringOf("ReplicationInstance.VpcSecurityGroups[i].VpcSecurityGroupId")
    i = i + 1
ENDDO

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

* {
*   "ReplicationInstance": {
*     "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"
*       }
*     ]
*   }
* }

RELEASE loRest
RELEASE loAuthAws
RELEASE loJson
RELEASE loSbRequestBody
RELEASE loSbResponseBody
RELEASE loJResp