ModifyReplicationTask Foxpro Example
LOCAL loRest
LOCAL lnSuccess
LOCAL loAuthAws
LOCAL loJson
LOCAL loSbRequestBody
LOCAL loSbResponseBody
LOCAL lnRespStatusCode
LOCAL loJResp
LOCAL lcCdcStartPosition
LOCAL lcCdcStopPosition
LOCAL lcLastFailureMessage
LOCAL lcMigrationType
LOCAL lcRecoveryCheckpoint
LOCAL lcReplicationInstanceArn
LOCAL lcReplicationTaskArn
LOCAL lnReplicationTaskCreationDate
LOCAL lcReplicationTaskIdentifier
LOCAL lcReplicationTaskSettings
LOCAL lnReplicationTaskStartDate
LOCAL lnElapsedTimeMillis
LOCAL lnFreshStartDate
LOCAL lnFullLoadFinishDate
LOCAL lnFullLoadProgressPercent
LOCAL lnFullLoadStartDate
LOCAL lnStartDate
LOCAL lnStopDate
LOCAL lnTablesErrored
LOCAL lnTablesLoaded
LOCAL lnTablesLoading
LOCAL lnTablesQueued
LOCAL lcSourceEndpointArn
LOCAL lcStatus
LOCAL lcStopReason
LOCAL lcTableMappings
LOCAL lcTargetEndpointArn
LOCAL lcTargetReplicationInstanceArn
LOCAL lcTaskData
* 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("CdcStartPosition","string")
loJson.UpdateInt("CdcStartTime",123)
loJson.UpdateString("CdcStopPosition","string")
loJson.UpdateString("MigrationType","string")
loJson.UpdateString("ReplicationTaskArn","string")
loJson.UpdateString("ReplicationTaskIdentifier","string")
loJson.UpdateString("ReplicationTaskSettings","string")
loJson.UpdateString("TableMappings","string")
loJson.UpdateString("TaskData","string")
* The JSON request body created by the above code:
* {
* "CdcStartPosition": "string",
* "CdcStartTime": number,
* "CdcStopPosition": "string",
* "MigrationType": "string",
* "ReplicationTaskArn": "string",
* "ReplicationTaskIdentifier": "string",
* "ReplicationTaskSettings": "string",
* "TableMappings": "string",
* "TaskData": "string"
* }
loRest.AddHeader("Content-Type","application/x-amz-json-1.1")
loRest.AddHeader("X-Amz-Target","AmazonDMSv20160101.ModifyReplicationTask")
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
lcCdcStartPosition = loJResp.StringOf("ReplicationTask.CdcStartPosition")
lcCdcStopPosition = loJResp.StringOf("ReplicationTask.CdcStopPosition")
lcLastFailureMessage = loJResp.StringOf("ReplicationTask.LastFailureMessage")
lcMigrationType = loJResp.StringOf("ReplicationTask.MigrationType")
lcRecoveryCheckpoint = loJResp.StringOf("ReplicationTask.RecoveryCheckpoint")
lcReplicationInstanceArn = loJResp.StringOf("ReplicationTask.ReplicationInstanceArn")
lcReplicationTaskArn = loJResp.StringOf("ReplicationTask.ReplicationTaskArn")
lnReplicationTaskCreationDate = loJResp.IntOf("ReplicationTask.ReplicationTaskCreationDate")
lcReplicationTaskIdentifier = loJResp.StringOf("ReplicationTask.ReplicationTaskIdentifier")
lcReplicationTaskSettings = loJResp.StringOf("ReplicationTask.ReplicationTaskSettings")
lnReplicationTaskStartDate = loJResp.IntOf("ReplicationTask.ReplicationTaskStartDate")
lnElapsedTimeMillis = loJResp.IntOf("ReplicationTask.ReplicationTaskStats.ElapsedTimeMillis")
lnFreshStartDate = loJResp.IntOf("ReplicationTask.ReplicationTaskStats.FreshStartDate")
lnFullLoadFinishDate = loJResp.IntOf("ReplicationTask.ReplicationTaskStats.FullLoadFinishDate")
lnFullLoadProgressPercent = loJResp.IntOf("ReplicationTask.ReplicationTaskStats.FullLoadProgressPercent")
lnFullLoadStartDate = loJResp.IntOf("ReplicationTask.ReplicationTaskStats.FullLoadStartDate")
lnStartDate = loJResp.IntOf("ReplicationTask.ReplicationTaskStats.StartDate")
lnStopDate = loJResp.IntOf("ReplicationTask.ReplicationTaskStats.StopDate")
lnTablesErrored = loJResp.IntOf("ReplicationTask.ReplicationTaskStats.TablesErrored")
lnTablesLoaded = loJResp.IntOf("ReplicationTask.ReplicationTaskStats.TablesLoaded")
lnTablesLoading = loJResp.IntOf("ReplicationTask.ReplicationTaskStats.TablesLoading")
lnTablesQueued = loJResp.IntOf("ReplicationTask.ReplicationTaskStats.TablesQueued")
lcSourceEndpointArn = loJResp.StringOf("ReplicationTask.SourceEndpointArn")
lcStatus = loJResp.StringOf("ReplicationTask.Status")
lcStopReason = loJResp.StringOf("ReplicationTask.StopReason")
lcTableMappings = loJResp.StringOf("ReplicationTask.TableMappings")
lcTargetEndpointArn = loJResp.StringOf("ReplicationTask.TargetEndpointArn")
lcTargetReplicationInstanceArn = loJResp.StringOf("ReplicationTask.TargetReplicationInstanceArn")
lcTaskData = loJResp.StringOf("ReplicationTask.TaskData")
* A sample JSON response body parsed by the above code:
* {
* "ReplicationTask": {
* "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"
* }
* }
RELEASE loRest
RELEASE loAuthAws
RELEASE loJson
RELEASE loSbRequestBody
RELEASE loSbResponseBody
RELEASE loJResp
