ModifyEndpoint TCL Example
load ./chilkat.dll
# This example requires the Chilkat API to have been previously unlocked.
# See Global Unlock Sample for sample code.
set rest [new_CkRest]
set authAws [new_CkAuthAws]
CkAuthAws_put_AccessKey $authAws "AWS_ACCESS_KEY"
CkAuthAws_put_SecretKey $authAws "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.)
CkAuthAws_put_Region $authAws "us-west-2"
CkAuthAws_put_ServiceName $authAws "dms"
# SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
CkRest_SetAuthAws $rest $authAws
# URL: https://dms.us-west-2.amazonaws.com/
# Use the same region as specified above.
set success [CkRest_Connect $rest "dms.us-west-2.amazonaws.com" 443 1 1]
if {$success != 1} then {
puts "ConnectFailReason: [CkRest_get_ConnectFailReason $rest]"
puts [CkRest_lastErrorText $rest]
delete_CkRest $rest
delete_CkAuthAws $authAws
exit
}
# 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 [new_CkJsonObject]
CkJsonObject_UpdateString $json "CertificateArn" "string"
CkJsonObject_UpdateString $json "DatabaseName" "string"
CkJsonObject_UpdateString $json "DmsTransferSettings.BucketName" "string"
CkJsonObject_UpdateString $json "DmsTransferSettings.ServiceAccessRoleArn" "string"
CkJsonObject_UpdateString $json "DocDbSettings.DatabaseName" "string"
CkJsonObject_UpdateInt $json "DocDbSettings.DocsToInvestigate" 123
CkJsonObject_UpdateInt $json "DocDbSettings.ExtractDocId" 123
CkJsonObject_UpdateString $json "DocDbSettings.KmsKeyId" "string"
CkJsonObject_UpdateString $json "DocDbSettings.NestingLevel" "string"
CkJsonObject_UpdateString $json "DocDbSettings.Password" "string"
CkJsonObject_UpdateInt $json "DocDbSettings.Port" 123
CkJsonObject_UpdateString $json "DocDbSettings.SecretsManagerAccessRoleArn" "string"
CkJsonObject_UpdateString $json "DocDbSettings.SecretsManagerSecretId" "string"
CkJsonObject_UpdateString $json "DocDbSettings.ServerName" "string"
CkJsonObject_UpdateString $json "DocDbSettings.Username" "string"
CkJsonObject_UpdateString $json "DynamoDbSettings.ServiceAccessRoleArn" "string"
CkJsonObject_UpdateString $json "ElasticsearchSettings.EndpointUri" "string"
CkJsonObject_UpdateInt $json "ElasticsearchSettings.ErrorRetryDuration" 123
CkJsonObject_UpdateInt $json "ElasticsearchSettings.FullLoadErrorPercentage" 123
CkJsonObject_UpdateString $json "ElasticsearchSettings.ServiceAccessRoleArn" "string"
CkJsonObject_UpdateString $json "EndpointArn" "string"
CkJsonObject_UpdateString $json "EndpointIdentifier" "string"
CkJsonObject_UpdateString $json "EndpointType" "string"
CkJsonObject_UpdateString $json "EngineName" "string"
CkJsonObject_UpdateInt $json "ExactSettings" 123
CkJsonObject_UpdateString $json "ExternalTableDefinition" "string"
CkJsonObject_UpdateString $json "ExtraConnectionAttributes" "string"
CkJsonObject_UpdateString $json "GcpMySQLSettings.AfterConnectScript" "string"
CkJsonObject_UpdateInt $json "GcpMySQLSettings.CleanSourceMetadataOnMismatch" 123
CkJsonObject_UpdateString $json "GcpMySQLSettings.DatabaseName" "string"
CkJsonObject_UpdateInt $json "GcpMySQLSettings.EventsPollInterval" 123
CkJsonObject_UpdateInt $json "GcpMySQLSettings.MaxFileSize" 123
CkJsonObject_UpdateInt $json "GcpMySQLSettings.ParallelLoadThreads" 123
CkJsonObject_UpdateString $json "GcpMySQLSettings.Password" "string"
CkJsonObject_UpdateInt $json "GcpMySQLSettings.Port" 123
CkJsonObject_UpdateString $json "GcpMySQLSettings.SecretsManagerAccessRoleArn" "string"
CkJsonObject_UpdateString $json "GcpMySQLSettings.SecretsManagerSecretId" "string"
CkJsonObject_UpdateString $json "GcpMySQLSettings.ServerName" "string"
CkJsonObject_UpdateString $json "GcpMySQLSettings.ServerTimezone" "string"
CkJsonObject_UpdateString $json "GcpMySQLSettings.TargetDbType" "string"
CkJsonObject_UpdateString $json "GcpMySQLSettings.Username" "string"
CkJsonObject_UpdateString $json "IBMDb2Settings.CurrentLsn" "string"
CkJsonObject_UpdateString $json "IBMDb2Settings.DatabaseName" "string"
CkJsonObject_UpdateInt $json "IBMDb2Settings.MaxKBytesPerRead" 123
CkJsonObject_UpdateString $json "IBMDb2Settings.Password" "string"
CkJsonObject_UpdateInt $json "IBMDb2Settings.Port" 123
CkJsonObject_UpdateString $json "IBMDb2Settings.SecretsManagerAccessRoleArn" "string"
CkJsonObject_UpdateString $json "IBMDb2Settings.SecretsManagerSecretId" "string"
CkJsonObject_UpdateString $json "IBMDb2Settings.ServerName" "string"
CkJsonObject_UpdateInt $json "IBMDb2Settings.SetDataCaptureChanges" 123
CkJsonObject_UpdateString $json "IBMDb2Settings.Username" "string"
CkJsonObject_UpdateString $json "KafkaSettings.Broker" "string"
CkJsonObject_UpdateInt $json "KafkaSettings.IncludeControlDetails" 123
CkJsonObject_UpdateInt $json "KafkaSettings.IncludeNullAndEmpty" 123
CkJsonObject_UpdateInt $json "KafkaSettings.IncludePartitionValue" 123
CkJsonObject_UpdateInt $json "KafkaSettings.IncludeTableAlterOperations" 123
CkJsonObject_UpdateInt $json "KafkaSettings.IncludeTransactionDetails" 123
CkJsonObject_UpdateString $json "KafkaSettings.MessageFormat" "string"
CkJsonObject_UpdateInt $json "KafkaSettings.MessageMaxBytes" 123
CkJsonObject_UpdateInt $json "KafkaSettings.NoHexPrefix" 123
CkJsonObject_UpdateInt $json "KafkaSettings.PartitionIncludeSchemaTable" 123
CkJsonObject_UpdateString $json "KafkaSettings.SaslPassword" "string"
CkJsonObject_UpdateString $json "KafkaSettings.SaslUsername" "string"
CkJsonObject_UpdateString $json "KafkaSettings.SecurityProtocol" "string"
CkJsonObject_UpdateString $json "KafkaSettings.SslCaCertificateArn" "string"
CkJsonObject_UpdateString $json "KafkaSettings.SslClientCertificateArn" "string"
CkJsonObject_UpdateString $json "KafkaSettings.SslClientKeyArn" "string"
CkJsonObject_UpdateString $json "KafkaSettings.SslClientKeyPassword" "string"
CkJsonObject_UpdateString $json "KafkaSettings.Topic" "string"
CkJsonObject_UpdateInt $json "KinesisSettings.IncludeControlDetails" 123
CkJsonObject_UpdateInt $json "KinesisSettings.IncludeNullAndEmpty" 123
CkJsonObject_UpdateInt $json "KinesisSettings.IncludePartitionValue" 123
CkJsonObject_UpdateInt $json "KinesisSettings.IncludeTableAlterOperations" 123
CkJsonObject_UpdateInt $json "KinesisSettings.IncludeTransactionDetails" 123
CkJsonObject_UpdateString $json "KinesisSettings.MessageFormat" "string"
CkJsonObject_UpdateInt $json "KinesisSettings.NoHexPrefix" 123
CkJsonObject_UpdateInt $json "KinesisSettings.PartitionIncludeSchemaTable" 123
CkJsonObject_UpdateString $json "KinesisSettings.ServiceAccessRoleArn" "string"
CkJsonObject_UpdateString $json "KinesisSettings.StreamArn" "string"
CkJsonObject_UpdateInt $json "MicrosoftSQLServerSettings.BcpPacketSize" 123
CkJsonObject_UpdateString $json "MicrosoftSQLServerSettings.ControlTablesFileGroup" "string"
CkJsonObject_UpdateString $json "MicrosoftSQLServerSettings.DatabaseName" "string"
CkJsonObject_UpdateString $json "MicrosoftSQLServerSettings.Password" "string"
CkJsonObject_UpdateInt $json "MicrosoftSQLServerSettings.Port" 123
CkJsonObject_UpdateInt $json "MicrosoftSQLServerSettings.QuerySingleAlwaysOnNode" 123
CkJsonObject_UpdateInt $json "MicrosoftSQLServerSettings.ReadBackupOnly" 123
CkJsonObject_UpdateString $json "MicrosoftSQLServerSettings.SafeguardPolicy" "string"
CkJsonObject_UpdateString $json "MicrosoftSQLServerSettings.SecretsManagerAccessRoleArn" "string"
CkJsonObject_UpdateString $json "MicrosoftSQLServerSettings.SecretsManagerSecretId" "string"
CkJsonObject_UpdateString $json "MicrosoftSQLServerSettings.ServerName" "string"
CkJsonObject_UpdateInt $json "MicrosoftSQLServerSettings.UseBcpFullLoad" 123
CkJsonObject_UpdateString $json "MicrosoftSQLServerSettings.Username" "string"
CkJsonObject_UpdateInt $json "MicrosoftSQLServerSettings.UseThirdPartyBackupDevice" 123
CkJsonObject_UpdateString $json "MongoDbSettings.AuthMechanism" "string"
CkJsonObject_UpdateString $json "MongoDbSettings.AuthSource" "string"
CkJsonObject_UpdateString $json "MongoDbSettings.AuthType" "string"
CkJsonObject_UpdateString $json "MongoDbSettings.DatabaseName" "string"
CkJsonObject_UpdateString $json "MongoDbSettings.DocsToInvestigate" "string"
CkJsonObject_UpdateString $json "MongoDbSettings.ExtractDocId" "string"
CkJsonObject_UpdateString $json "MongoDbSettings.KmsKeyId" "string"
CkJsonObject_UpdateString $json "MongoDbSettings.NestingLevel" "string"
CkJsonObject_UpdateString $json "MongoDbSettings.Password" "string"
CkJsonObject_UpdateInt $json "MongoDbSettings.Port" 123
CkJsonObject_UpdateString $json "MongoDbSettings.SecretsManagerAccessRoleArn" "string"
CkJsonObject_UpdateString $json "MongoDbSettings.SecretsManagerSecretId" "string"
CkJsonObject_UpdateString $json "MongoDbSettings.ServerName" "string"
CkJsonObject_UpdateString $json "MongoDbSettings.Username" "string"
CkJsonObject_UpdateString $json "MySQLSettings.AfterConnectScript" "string"
CkJsonObject_UpdateInt $json "MySQLSettings.CleanSourceMetadataOnMismatch" 123
CkJsonObject_UpdateString $json "MySQLSettings.DatabaseName" "string"
CkJsonObject_UpdateInt $json "MySQLSettings.EventsPollInterval" 123
CkJsonObject_UpdateInt $json "MySQLSettings.MaxFileSize" 123
CkJsonObject_UpdateInt $json "MySQLSettings.ParallelLoadThreads" 123
CkJsonObject_UpdateString $json "MySQLSettings.Password" "string"
CkJsonObject_UpdateInt $json "MySQLSettings.Port" 123
CkJsonObject_UpdateString $json "MySQLSettings.SecretsManagerAccessRoleArn" "string"
CkJsonObject_UpdateString $json "MySQLSettings.SecretsManagerSecretId" "string"
CkJsonObject_UpdateString $json "MySQLSettings.ServerName" "string"
CkJsonObject_UpdateString $json "MySQLSettings.ServerTimezone" "string"
CkJsonObject_UpdateString $json "MySQLSettings.TargetDbType" "string"
CkJsonObject_UpdateString $json "MySQLSettings.Username" "string"
CkJsonObject_UpdateInt $json "NeptuneSettings.ErrorRetryDuration" 123
CkJsonObject_UpdateInt $json "NeptuneSettings.IamAuthEnabled" 123
CkJsonObject_UpdateInt $json "NeptuneSettings.MaxFileSize" 123
CkJsonObject_UpdateInt $json "NeptuneSettings.MaxRetryCount" 123
CkJsonObject_UpdateString $json "NeptuneSettings.S3BucketFolder" "string"
CkJsonObject_UpdateString $json "NeptuneSettings.S3BucketName" "string"
CkJsonObject_UpdateString $json "NeptuneSettings.ServiceAccessRoleArn" "string"
CkJsonObject_UpdateInt $json "OracleSettings.AccessAlternateDirectly" 123
CkJsonObject_UpdateInt $json "OracleSettings.AdditionalArchivedLogDestId" 123
CkJsonObject_UpdateInt $json "OracleSettings.AddSupplementalLogging" 123
CkJsonObject_UpdateInt $json "OracleSettings.AllowSelectNestedTables" 123
CkJsonObject_UpdateInt $json "OracleSettings.ArchivedLogDestId" 123
CkJsonObject_UpdateInt $json "OracleSettings.ArchivedLogsOnly" 123
CkJsonObject_UpdateString $json "OracleSettings.AsmPassword" "string"
CkJsonObject_UpdateString $json "OracleSettings.AsmServer" "string"
CkJsonObject_UpdateString $json "OracleSettings.AsmUser" "string"
CkJsonObject_UpdateString $json "OracleSettings.CharLengthSemantics" "string"
CkJsonObject_UpdateString $json "OracleSettings.DatabaseName" "string"
CkJsonObject_UpdateInt $json "OracleSettings.DirectPathNoLog" 123
CkJsonObject_UpdateInt $json "OracleSettings.DirectPathParallelLoad" 123
CkJsonObject_UpdateInt $json "OracleSettings.EnableHomogenousTablespace" 123
ERROR: Undefined variable(number)
ERROR: Undefined variable(number)
ERROR: Undefined variable(number)
ERROR: Undefined variable(number)
ERROR: Undefined variable(number)
ERROR: Undefined variable(number)
ERROR: Undefined variable(number)
CkJsonObject_UpdateInt $json "OracleSettings.ExtraArchivedLogDestIds[0]" $numberERROR: Undefined variable(number)
CkJsonObject_UpdateInt $json "OracleSettings.FailTasksOnLobTruncation" 123
CkJsonObject_UpdateInt $json "OracleSettings.NumberDatatypeScale" 123
CkJsonObject_UpdateString $json "OracleSettings.OraclePathPrefix" "string"
CkJsonObject_UpdateInt $json "OracleSettings.ParallelAsmReadThreads" 123
CkJsonObject_UpdateString $json "OracleSettings.Password" "string"
CkJsonObject_UpdateInt $json "OracleSettings.Port" 123
CkJsonObject_UpdateInt $json "OracleSettings.ReadAheadBlocks" 123
CkJsonObject_UpdateInt $json "OracleSettings.ReadTableSpaceName" 123
CkJsonObject_UpdateInt $json "OracleSettings.ReplacePathPrefix" 123
CkJsonObject_UpdateInt $json "OracleSettings.RetryInterval" 123
CkJsonObject_UpdateString $json "OracleSettings.SecretsManagerAccessRoleArn" "string"
CkJsonObject_UpdateString $json "OracleSettings.SecretsManagerOracleAsmAccessRoleArn" "string"
CkJsonObject_UpdateString $json "OracleSettings.SecretsManagerOracleAsmSecretId" "string"
CkJsonObject_UpdateString $json "OracleSettings.SecretsManagerSecretId" "string"
CkJsonObject_UpdateString $json "OracleSettings.SecurityDbEncryption" "string"
CkJsonObject_UpdateString $json "OracleSettings.SecurityDbEncryptionName" "string"
CkJsonObject_UpdateString $json "OracleSettings.ServerName" "string"
CkJsonObject_UpdateString $json "OracleSettings.SpatialDataOptionToGeoJsonFunctionName" "string"
CkJsonObject_UpdateInt $json "OracleSettings.StandbyDelayTime" 123
CkJsonObject_UpdateInt $json "OracleSettings.UseAlternateFolderForOnline" 123
CkJsonObject_UpdateInt $json "OracleSettings.UseBFile" 123
CkJsonObject_UpdateInt $json "OracleSettings.UseDirectPathFullLoad" 123
CkJsonObject_UpdateInt $json "OracleSettings.UseLogminerReader" 123
CkJsonObject_UpdateString $json "OracleSettings.UsePathPrefix" "string"
CkJsonObject_UpdateString $json "OracleSettings.Username" "string"
CkJsonObject_UpdateString $json "Password" "string"
CkJsonObject_UpdateInt $json "Port" 123
CkJsonObject_UpdateString $json "PostgreSQLSettings.AfterConnectScript" "string"
CkJsonObject_UpdateInt $json "PostgreSQLSettings.CaptureDdls" 123
CkJsonObject_UpdateString $json "PostgreSQLSettings.DatabaseName" "string"
CkJsonObject_UpdateString $json "PostgreSQLSettings.DdlArtifactsSchema" "string"
CkJsonObject_UpdateInt $json "PostgreSQLSettings.ExecuteTimeout" 123
CkJsonObject_UpdateInt $json "PostgreSQLSettings.FailTasksOnLobTruncation" 123
CkJsonObject_UpdateInt $json "PostgreSQLSettings.HeartbeatEnable" 123
CkJsonObject_UpdateInt $json "PostgreSQLSettings.HeartbeatFrequency" 123
CkJsonObject_UpdateString $json "PostgreSQLSettings.HeartbeatSchema" "string"
CkJsonObject_UpdateInt $json "PostgreSQLSettings.MaxFileSize" 123
CkJsonObject_UpdateString $json "PostgreSQLSettings.Password" "string"
CkJsonObject_UpdateString $json "PostgreSQLSettings.PluginName" "string"
CkJsonObject_UpdateInt $json "PostgreSQLSettings.Port" 123
CkJsonObject_UpdateString $json "PostgreSQLSettings.SecretsManagerAccessRoleArn" "string"
CkJsonObject_UpdateString $json "PostgreSQLSettings.SecretsManagerSecretId" "string"
CkJsonObject_UpdateString $json "PostgreSQLSettings.ServerName" "string"
CkJsonObject_UpdateString $json "PostgreSQLSettings.SlotName" "string"
CkJsonObject_UpdateString $json "PostgreSQLSettings.Username" "string"
CkJsonObject_UpdateString $json "RedisSettings.AuthPassword" "string"
CkJsonObject_UpdateString $json "RedisSettings.AuthType" "string"
CkJsonObject_UpdateString $json "RedisSettings.AuthUserName" "string"
CkJsonObject_UpdateInt $json "RedisSettings.Port" 123
CkJsonObject_UpdateString $json "RedisSettings.ServerName" "string"
CkJsonObject_UpdateString $json "RedisSettings.SslCaCertificateArn" "string"
CkJsonObject_UpdateString $json "RedisSettings.SslSecurityProtocol" "string"
CkJsonObject_UpdateInt $json "RedshiftSettings.AcceptAnyDate" 123
CkJsonObject_UpdateString $json "RedshiftSettings.AfterConnectScript" "string"
CkJsonObject_UpdateString $json "RedshiftSettings.BucketFolder" "string"
CkJsonObject_UpdateString $json "RedshiftSettings.BucketName" "string"
CkJsonObject_UpdateInt $json "RedshiftSettings.CaseSensitiveNames" 123
CkJsonObject_UpdateInt $json "RedshiftSettings.CompUpdate" 123
CkJsonObject_UpdateInt $json "RedshiftSettings.ConnectionTimeout" 123
CkJsonObject_UpdateString $json "RedshiftSettings.DatabaseName" "string"
CkJsonObject_UpdateString $json "RedshiftSettings.DateFormat" "string"
CkJsonObject_UpdateInt $json "RedshiftSettings.EmptyAsNull" 123
CkJsonObject_UpdateString $json "RedshiftSettings.EncryptionMode" "string"
CkJsonObject_UpdateInt $json "RedshiftSettings.ExplicitIds" 123
CkJsonObject_UpdateInt $json "RedshiftSettings.FileTransferUploadStreams" 123
CkJsonObject_UpdateInt $json "RedshiftSettings.LoadTimeout" 123
CkJsonObject_UpdateInt $json "RedshiftSettings.MaxFileSize" 123
CkJsonObject_UpdateString $json "RedshiftSettings.Password" "string"
CkJsonObject_UpdateInt $json "RedshiftSettings.Port" 123
CkJsonObject_UpdateInt $json "RedshiftSettings.RemoveQuotes" 123
CkJsonObject_UpdateString $json "RedshiftSettings.ReplaceChars" "string"
CkJsonObject_UpdateString $json "RedshiftSettings.ReplaceInvalidChars" "string"
CkJsonObject_UpdateString $json "RedshiftSettings.SecretsManagerAccessRoleArn" "string"
CkJsonObject_UpdateString $json "RedshiftSettings.SecretsManagerSecretId" "string"
CkJsonObject_UpdateString $json "RedshiftSettings.ServerName" "string"
CkJsonObject_UpdateString $json "RedshiftSettings.ServerSideEncryptionKmsKeyId" "string"
CkJsonObject_UpdateString $json "RedshiftSettings.ServiceAccessRoleArn" "string"
CkJsonObject_UpdateString $json "RedshiftSettings.TimeFormat" "string"
CkJsonObject_UpdateInt $json "RedshiftSettings.TrimBlanks" 123
CkJsonObject_UpdateInt $json "RedshiftSettings.TruncateColumns" 123
CkJsonObject_UpdateString $json "RedshiftSettings.Username" "string"
CkJsonObject_UpdateInt $json "RedshiftSettings.WriteBufferSize" 123
CkJsonObject_UpdateInt $json "S3Settings.AddColumnName" 123
CkJsonObject_UpdateString $json "S3Settings.BucketFolder" "string"
CkJsonObject_UpdateString $json "S3Settings.BucketName" "string"
CkJsonObject_UpdateString $json "S3Settings.CannedAclForObjects" "string"
CkJsonObject_UpdateInt $json "S3Settings.CdcInsertsAndUpdates" 123
CkJsonObject_UpdateInt $json "S3Settings.CdcInsertsOnly" 123
CkJsonObject_UpdateInt $json "S3Settings.CdcMaxBatchInterval" 123
CkJsonObject_UpdateInt $json "S3Settings.CdcMinFileSize" 123
CkJsonObject_UpdateString $json "S3Settings.CdcPath" "string"
CkJsonObject_UpdateString $json "S3Settings.CompressionType" "string"
CkJsonObject_UpdateString $json "S3Settings.CsvDelimiter" "string"
CkJsonObject_UpdateString $json "S3Settings.CsvNoSupValue" "string"
CkJsonObject_UpdateString $json "S3Settings.CsvNullValue" "string"
CkJsonObject_UpdateString $json "S3Settings.CsvRowDelimiter" "string"
CkJsonObject_UpdateString $json "S3Settings.DataFormat" "string"
CkJsonObject_UpdateInt $json "S3Settings.DataPageSize" 123
CkJsonObject_UpdateString $json "S3Settings.DatePartitionDelimiter" "string"
CkJsonObject_UpdateInt $json "S3Settings.DatePartitionEnabled" 123
CkJsonObject_UpdateString $json "S3Settings.DatePartitionSequence" "string"
CkJsonObject_UpdateString $json "S3Settings.DatePartitionTimezone" "string"
CkJsonObject_UpdateInt $json "S3Settings.DictPageSizeLimit" 123
CkJsonObject_UpdateInt $json "S3Settings.EnableStatistics" 123
CkJsonObject_UpdateString $json "S3Settings.EncodingType" "string"
CkJsonObject_UpdateString $json "S3Settings.EncryptionMode" "string"
CkJsonObject_UpdateString $json "S3Settings.ExternalTableDefinition" "string"
CkJsonObject_UpdateInt $json "S3Settings.IgnoreHeaderRows" 123
CkJsonObject_UpdateInt $json "S3Settings.IncludeOpForFullLoad" 123
CkJsonObject_UpdateInt $json "S3Settings.MaxFileSize" 123
CkJsonObject_UpdateInt $json "S3Settings.ParquetTimestampInMillisecond" 123
CkJsonObject_UpdateString $json "S3Settings.ParquetVersion" "string"
CkJsonObject_UpdateInt $json "S3Settings.PreserveTransactions" 123
CkJsonObject_UpdateInt $json "S3Settings.Rfc4180" 123
CkJsonObject_UpdateInt $json "S3Settings.RowGroupLength" 123
CkJsonObject_UpdateString $json "S3Settings.ServerSideEncryptionKmsKeyId" "string"
CkJsonObject_UpdateString $json "S3Settings.ServiceAccessRoleArn" "string"
CkJsonObject_UpdateString $json "S3Settings.TimestampColumnName" "string"
CkJsonObject_UpdateInt $json "S3Settings.UseCsvNoSupValue" 123
CkJsonObject_UpdateInt $json "S3Settings.UseTaskStartTimeForFullLoadTimestamp" 123
CkJsonObject_UpdateString $json "ServerName" "string"
CkJsonObject_UpdateString $json "ServiceAccessRoleArn" "string"
CkJsonObject_UpdateString $json "SslMode" "string"
CkJsonObject_UpdateString $json "SybaseSettings.DatabaseName" "string"
CkJsonObject_UpdateString $json "SybaseSettings.Password" "string"
CkJsonObject_UpdateInt $json "SybaseSettings.Port" 123
CkJsonObject_UpdateString $json "SybaseSettings.SecretsManagerAccessRoleArn" "string"
CkJsonObject_UpdateString $json "SybaseSettings.SecretsManagerSecretId" "string"
CkJsonObject_UpdateString $json "SybaseSettings.ServerName" "string"
CkJsonObject_UpdateString $json "SybaseSettings.Username" "string"
CkJsonObject_UpdateString $json "Username" "string"
# The JSON request body created by the above code:
# {
# "CertificateArn": "string",
# "DatabaseName": "string",
# "DmsTransferSettings": {
# "BucketName": "string",
# "ServiceAccessRoleArn": "string"
# },
# "DocDbSettings": {
# "DatabaseName": "string",
# "DocsToInvestigate": number,
# "ExtractDocId": boolean,
# "KmsKeyId": "string",
# "NestingLevel": "string",
# "Password": "string",
# "Port": number,
# "SecretsManagerAccessRoleArn": "string",
# "SecretsManagerSecretId": "string",
# "ServerName": "string",
# "Username": "string"
# },
# "DynamoDbSettings": {
# "ServiceAccessRoleArn": "string"
# },
# "ElasticsearchSettings": {
# "EndpointUri": "string",
# "ErrorRetryDuration": number,
# "FullLoadErrorPercentage": number,
# "ServiceAccessRoleArn": "string"
# },
# "EndpointArn": "string",
# "EndpointIdentifier": "string",
# "EndpointType": "string",
# "EngineName": "string",
# "ExactSettings": boolean,
# "ExternalTableDefinition": "string",
# "ExtraConnectionAttributes": "string",
# "GcpMySQLSettings": {
# "AfterConnectScript": "string",
# "CleanSourceMetadataOnMismatch": boolean,
# "DatabaseName": "string",
# "EventsPollInterval": number,
# "MaxFileSize": number,
# "ParallelLoadThreads": number,
# "Password": "string",
# "Port": number,
# "SecretsManagerAccessRoleArn": "string",
# "SecretsManagerSecretId": "string",
# "ServerName": "string",
# "ServerTimezone": "string",
# "TargetDbType": "string",
# "Username": "string"
# },
# "IBMDb2Settings": {
# "CurrentLsn": "string",
# "DatabaseName": "string",
# "MaxKBytesPerRead": number,
# "Password": "string",
# "Port": number,
# "SecretsManagerAccessRoleArn": "string",
# "SecretsManagerSecretId": "string",
# "ServerName": "string",
# "SetDataCaptureChanges": boolean,
# "Username": "string"
# },
# "KafkaSettings": {
# "Broker": "string",
# "IncludeControlDetails": boolean,
# "IncludeNullAndEmpty": boolean,
# "IncludePartitionValue": boolean,
# "IncludeTableAlterOperations": boolean,
# "IncludeTransactionDetails": boolean,
# "MessageFormat": "string",
# "MessageMaxBytes": number,
# "NoHexPrefix": boolean,
# "PartitionIncludeSchemaTable": boolean,
# "SaslPassword": "string",
# "SaslUsername": "string",
# "SecurityProtocol": "string",
# "SslCaCertificateArn": "string",
# "SslClientCertificateArn": "string",
# "SslClientKeyArn": "string",
# "SslClientKeyPassword": "string",
# "Topic": "string"
# },
# "KinesisSettings": {
# "IncludeControlDetails": boolean,
# "IncludeNullAndEmpty": boolean,
# "IncludePartitionValue": boolean,
# "IncludeTableAlterOperations": boolean,
# "IncludeTransactionDetails": boolean,
# "MessageFormat": "string",
# "NoHexPrefix": boolean,
# "PartitionIncludeSchemaTable": boolean,
# "ServiceAccessRoleArn": "string",
# "StreamArn": "string"
# },
# "MicrosoftSQLServerSettings": {
# "BcpPacketSize": number,
# "ControlTablesFileGroup": "string",
# "DatabaseName": "string",
# "Password": "string",
# "Port": number,
# "QuerySingleAlwaysOnNode": boolean,
# "ReadBackupOnly": boolean,
# "SafeguardPolicy": "string",
# "SecretsManagerAccessRoleArn": "string",
# "SecretsManagerSecretId": "string",
# "ServerName": "string",
# "UseBcpFullLoad": boolean,
# "Username": "string",
# "UseThirdPartyBackupDevice": boolean
# },
# "MongoDbSettings": {
# "AuthMechanism": "string",
# "AuthSource": "string",
# "AuthType": "string",
# "DatabaseName": "string",
# "DocsToInvestigate": "string",
# "ExtractDocId": "string",
# "KmsKeyId": "string",
# "NestingLevel": "string",
# "Password": "string",
# "Port": number,
# "SecretsManagerAccessRoleArn": "string",
# "SecretsManagerSecretId": "string",
# "ServerName": "string",
# "Username": "string"
# },
# "MySQLSettings": {
# "AfterConnectScript": "string",
# "CleanSourceMetadataOnMismatch": boolean,
# "DatabaseName": "string",
# "EventsPollInterval": number,
# "MaxFileSize": number,
# "ParallelLoadThreads": number,
# "Password": "string",
# "Port": number,
# "SecretsManagerAccessRoleArn": "string",
# "SecretsManagerSecretId": "string",
# "ServerName": "string",
# "ServerTimezone": "string",
# "TargetDbType": "string",
# "Username": "string"
# },
# "NeptuneSettings": {
# "ErrorRetryDuration": number,
# "IamAuthEnabled": boolean,
# "MaxFileSize": number,
# "MaxRetryCount": number,
# "S3BucketFolder": "string",
# "S3BucketName": "string",
# "ServiceAccessRoleArn": "string"
# },
# "OracleSettings": {
# "AccessAlternateDirectly": boolean,
# "AdditionalArchivedLogDestId": number,
# "AddSupplementalLogging": boolean,
# "AllowSelectNestedTables": boolean,
# "ArchivedLogDestId": number,
# "ArchivedLogsOnly": boolean,
# "AsmPassword": "string",
# "AsmServer": "string",
# "AsmUser": "string",
# "CharLengthSemantics": "string",
# "DatabaseName": "string",
# "DirectPathNoLog": boolean,
# "DirectPathParallelLoad": boolean,
# "EnableHomogenousTablespace": boolean,
# "ExtraArchivedLogDestIds": [
# number
# ],
# "FailTasksOnLobTruncation": boolean,
# "NumberDatatypeScale": number,
# "OraclePathPrefix": "string",
# "ParallelAsmReadThreads": number,
# "Password": "string",
# "Port": number,
# "ReadAheadBlocks": number,
# "ReadTableSpaceName": boolean,
# "ReplacePathPrefix": boolean,
# "RetryInterval": number,
# "SecretsManagerAccessRoleArn": "string",
# "SecretsManagerOracleAsmAccessRoleArn": "string",
# "SecretsManagerOracleAsmSecretId": "string",
# "SecretsManagerSecretId": "string",
# "SecurityDbEncryption": "string",
# "SecurityDbEncryptionName": "string",
# "ServerName": "string",
# "SpatialDataOptionToGeoJsonFunctionName": "string",
# "StandbyDelayTime": number,
# "UseAlternateFolderForOnline": boolean,
# "UseBFile": boolean,
# "UseDirectPathFullLoad": boolean,
# "UseLogminerReader": boolean,
# "UsePathPrefix": "string",
# "Username": "string"
# },
# "Password": "string",
# "Port": number,
# "PostgreSQLSettings": {
# "AfterConnectScript": "string",
# "CaptureDdls": boolean,
# "DatabaseName": "string",
# "DdlArtifactsSchema": "string",
# "ExecuteTimeout": number,
# "FailTasksOnLobTruncation": boolean,
# "HeartbeatEnable": boolean,
# "HeartbeatFrequency": number,
# "HeartbeatSchema": "string",
# "MaxFileSize": number,
# "Password": "string",
# "PluginName": "string",
# "Port": number,
# "SecretsManagerAccessRoleArn": "string",
# "SecretsManagerSecretId": "string",
# "ServerName": "string",
# "SlotName": "string",
# "Username": "string"
# },
# "RedisSettings": {
# "AuthPassword": "string",
# "AuthType": "string",
# "AuthUserName": "string",
# "Port": number,
# "ServerName": "string",
# "SslCaCertificateArn": "string",
# "SslSecurityProtocol": "string"
# },
# "RedshiftSettings": {
# "AcceptAnyDate": boolean,
# "AfterConnectScript": "string",
# "BucketFolder": "string",
# "BucketName": "string",
# "CaseSensitiveNames": boolean,
# "CompUpdate": boolean,
# "ConnectionTimeout": number,
# "DatabaseName": "string",
# "DateFormat": "string",
# "EmptyAsNull": boolean,
# "EncryptionMode": "string",
# "ExplicitIds": boolean,
# "FileTransferUploadStreams": number,
# "LoadTimeout": number,
# "MaxFileSize": number,
# "Password": "string",
# "Port": number,
# "RemoveQuotes": boolean,
# "ReplaceChars": "string",
# "ReplaceInvalidChars": "string",
# "SecretsManagerAccessRoleArn": "string",
# "SecretsManagerSecretId": "string",
# "ServerName": "string",
# "ServerSideEncryptionKmsKeyId": "string",
# "ServiceAccessRoleArn": "string",
# "TimeFormat": "string",
# "TrimBlanks": boolean,
# "TruncateColumns": boolean,
# "Username": "string",
# "WriteBufferSize": number
# },
# "S3Settings": {
# "AddColumnName": boolean,
# "BucketFolder": "string",
# "BucketName": "string",
# "CannedAclForObjects": "string",
# "CdcInsertsAndUpdates": boolean,
# "CdcInsertsOnly": boolean,
# "CdcMaxBatchInterval": number,
# "CdcMinFileSize": number,
# "CdcPath": "string",
# "CompressionType": "string",
# "CsvDelimiter": "string",
# "CsvNoSupValue": "string",
# "CsvNullValue": "string",
# "CsvRowDelimiter": "string",
# "DataFormat": "string",
# "DataPageSize": number,
# "DatePartitionDelimiter": "string",
# "DatePartitionEnabled": boolean,
# "DatePartitionSequence": "string",
# "DatePartitionTimezone": "string",
# "DictPageSizeLimit": number,
# "EnableStatistics": boolean,
# "EncodingType": "string",
# "EncryptionMode": "string",
# "ExternalTableDefinition": "string",
# "IgnoreHeaderRows": number,
# "IncludeOpForFullLoad": boolean,
# "MaxFileSize": number,
# "ParquetTimestampInMillisecond": boolean,
# "ParquetVersion": "string",
# "PreserveTransactions": boolean,
# "Rfc4180": boolean,
# "RowGroupLength": number,
# "ServerSideEncryptionKmsKeyId": "string",
# "ServiceAccessRoleArn": "string",
# "TimestampColumnName": "string",
# "UseCsvNoSupValue": boolean,
# "UseTaskStartTimeForFullLoadTimestamp": boolean
# },
# "ServerName": "string",
# "ServiceAccessRoleArn": "string",
# "SslMode": "string",
# "SybaseSettings": {
# "DatabaseName": "string",
# "Password": "string",
# "Port": number,
# "SecretsManagerAccessRoleArn": "string",
# "SecretsManagerSecretId": "string",
# "ServerName": "string",
# "Username": "string"
# },
# "Username": "string"
# }
CkRest_AddHeader $rest "Content-Type" "application/x-amz-json-1.1"
CkRest_AddHeader $rest "X-Amz-Target" "AmazonDMSv20160101.ModifyEndpoint"
set sbRequestBody [new_CkStringBuilder]
CkJsonObject_EmitSb $json $sbRequestBody
set sbResponseBody [new_CkStringBuilder]
set success [CkRest_FullRequestSb $rest "POST" "/" $sbRequestBody $sbResponseBody]
if {$success != 1} then {
puts [CkRest_lastErrorText $rest]
delete_CkRest $rest
delete_CkAuthAws $authAws
delete_CkJsonObject $json
delete_CkStringBuilder $sbRequestBody
delete_CkStringBuilder $sbResponseBody
exit
}
set respStatusCode [CkRest_get_ResponseStatusCode $rest]
puts "response status code = $respStatusCode"
if {$respStatusCode != 200} then {
puts "Response Header:"
puts [CkRest_responseHeader $rest]
puts "Response Body:"
puts [CkStringBuilder_getAsString $sbResponseBody]
delete_CkRest $rest
delete_CkAuthAws $authAws
delete_CkJsonObject $json
delete_CkStringBuilder $sbRequestBody
delete_CkStringBuilder $sbResponseBody
exit
}
set jResp [new_CkJsonObject]
CkJsonObject_LoadSb $jResp $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
set CertificateArn [CkJsonObject_stringOf $jResp "Endpoint.CertificateArn"]
set DatabaseName [CkJsonObject_stringOf $jResp "Endpoint.DatabaseName"]
set BucketName [CkJsonObject_stringOf $jResp "Endpoint.DmsTransferSettings.BucketName"]
set ServiceAccessRoleArn [CkJsonObject_stringOf $jResp "Endpoint.DmsTransferSettings.ServiceAccessRoleArn"]
set DocDbSettingsDatabaseName [CkJsonObject_stringOf $jResp "Endpoint.DocDbSettings.DatabaseName"]
set DocsToInvestigate [CkJsonObject_IntOf $jResp "Endpoint.DocDbSettings.DocsToInvestigate"]
set ExtractDocId [CkJsonObject_IntOf $jResp "Endpoint.DocDbSettings.ExtractDocId"]
set KmsKeyId [CkJsonObject_stringOf $jResp "Endpoint.DocDbSettings.KmsKeyId"]
set NestingLevel [CkJsonObject_stringOf $jResp "Endpoint.DocDbSettings.NestingLevel"]
set Password [CkJsonObject_stringOf $jResp "Endpoint.DocDbSettings.Password"]
set Port [CkJsonObject_IntOf $jResp "Endpoint.DocDbSettings.Port"]
set SecretsManagerAccessRoleArn [CkJsonObject_stringOf $jResp "Endpoint.DocDbSettings.SecretsManagerAccessRoleArn"]
set SecretsManagerSecretId [CkJsonObject_stringOf $jResp "Endpoint.DocDbSettings.SecretsManagerSecretId"]
set ServerName [CkJsonObject_stringOf $jResp "Endpoint.DocDbSettings.ServerName"]
set Username [CkJsonObject_stringOf $jResp "Endpoint.DocDbSettings.Username"]
set DynamoDbSettingsServiceAccessRoleArn [CkJsonObject_stringOf $jResp "Endpoint.DynamoDbSettings.ServiceAccessRoleArn"]
set EndpointUri [CkJsonObject_stringOf $jResp "Endpoint.ElasticsearchSettings.EndpointUri"]
set ErrorRetryDuration [CkJsonObject_IntOf $jResp "Endpoint.ElasticsearchSettings.ErrorRetryDuration"]
set FullLoadErrorPercentage [CkJsonObject_IntOf $jResp "Endpoint.ElasticsearchSettings.FullLoadErrorPercentage"]
set ElasticsearchSettingsServiceAccessRoleArn [CkJsonObject_stringOf $jResp "Endpoint.ElasticsearchSettings.ServiceAccessRoleArn"]
set EndpointArn [CkJsonObject_stringOf $jResp "Endpoint.EndpointArn"]
set EndpointIdentifier [CkJsonObject_stringOf $jResp "Endpoint.EndpointIdentifier"]
set EndpointType [CkJsonObject_stringOf $jResp "Endpoint.EndpointType"]
set EngineDisplayName [CkJsonObject_stringOf $jResp "Endpoint.EngineDisplayName"]
set EngineName [CkJsonObject_stringOf $jResp "Endpoint.EngineName"]
set ExternalId [CkJsonObject_stringOf $jResp "Endpoint.ExternalId"]
set ExternalTableDefinition [CkJsonObject_stringOf $jResp "Endpoint.ExternalTableDefinition"]
set ExtraConnectionAttributes [CkJsonObject_stringOf $jResp "Endpoint.ExtraConnectionAttributes"]
set AfterConnectScript [CkJsonObject_stringOf $jResp "Endpoint.GcpMySQLSettings.AfterConnectScript"]
set CleanSourceMetadataOnMismatch [CkJsonObject_IntOf $jResp "Endpoint.GcpMySQLSettings.CleanSourceMetadataOnMismatch"]
set GcpMySQLSettingsDatabaseName [CkJsonObject_stringOf $jResp "Endpoint.GcpMySQLSettings.DatabaseName"]
set EventsPollInterval [CkJsonObject_IntOf $jResp "Endpoint.GcpMySQLSettings.EventsPollInterval"]
set MaxFileSize [CkJsonObject_IntOf $jResp "Endpoint.GcpMySQLSettings.MaxFileSize"]
set ParallelLoadThreads [CkJsonObject_IntOf $jResp "Endpoint.GcpMySQLSettings.ParallelLoadThreads"]
set GcpMySQLSettingsPassword [CkJsonObject_stringOf $jResp "Endpoint.GcpMySQLSettings.Password"]
set GcpMySQLSettingsPort [CkJsonObject_IntOf $jResp "Endpoint.GcpMySQLSettings.Port"]
set GcpMySQLSettingsSecretsManagerAccessRoleArn [CkJsonObject_stringOf $jResp "Endpoint.GcpMySQLSettings.SecretsManagerAccessRoleArn"]
set GcpMySQLSettingsSecretsManagerSecretId [CkJsonObject_stringOf $jResp "Endpoint.GcpMySQLSettings.SecretsManagerSecretId"]
set GcpMySQLSettingsServerName [CkJsonObject_stringOf $jResp "Endpoint.GcpMySQLSettings.ServerName"]
set ServerTimezone [CkJsonObject_stringOf $jResp "Endpoint.GcpMySQLSettings.ServerTimezone"]
set TargetDbType [CkJsonObject_stringOf $jResp "Endpoint.GcpMySQLSettings.TargetDbType"]
set GcpMySQLSettingsUsername [CkJsonObject_stringOf $jResp "Endpoint.GcpMySQLSettings.Username"]
set CurrentLsn [CkJsonObject_stringOf $jResp "Endpoint.IBMDb2Settings.CurrentLsn"]
set IBMDb2SettingsDatabaseName [CkJsonObject_stringOf $jResp "Endpoint.IBMDb2Settings.DatabaseName"]
set MaxKBytesPerRead [CkJsonObject_IntOf $jResp "Endpoint.IBMDb2Settings.MaxKBytesPerRead"]
set IBMDb2SettingsPassword [CkJsonObject_stringOf $jResp "Endpoint.IBMDb2Settings.Password"]
set IBMDb2SettingsPort [CkJsonObject_IntOf $jResp "Endpoint.IBMDb2Settings.Port"]
set IBMDb2SettingsSecretsManagerAccessRoleArn [CkJsonObject_stringOf $jResp "Endpoint.IBMDb2Settings.SecretsManagerAccessRoleArn"]
set IBMDb2SettingsSecretsManagerSecretId [CkJsonObject_stringOf $jResp "Endpoint.IBMDb2Settings.SecretsManagerSecretId"]
set IBMDb2SettingsServerName [CkJsonObject_stringOf $jResp "Endpoint.IBMDb2Settings.ServerName"]
set SetDataCaptureChanges [CkJsonObject_IntOf $jResp "Endpoint.IBMDb2Settings.SetDataCaptureChanges"]
set IBMDb2SettingsUsername [CkJsonObject_stringOf $jResp "Endpoint.IBMDb2Settings.Username"]
set Broker [CkJsonObject_stringOf $jResp "Endpoint.KafkaSettings.Broker"]
set IncludeControlDetails [CkJsonObject_IntOf $jResp "Endpoint.KafkaSettings.IncludeControlDetails"]
set IncludeNullAndEmpty [CkJsonObject_IntOf $jResp "Endpoint.KafkaSettings.IncludeNullAndEmpty"]
set IncludePartitionValue [CkJsonObject_IntOf $jResp "Endpoint.KafkaSettings.IncludePartitionValue"]
set IncludeTableAlterOperations [CkJsonObject_IntOf $jResp "Endpoint.KafkaSettings.IncludeTableAlterOperations"]
set IncludeTransactionDetails [CkJsonObject_IntOf $jResp "Endpoint.KafkaSettings.IncludeTransactionDetails"]
set MessageFormat [CkJsonObject_stringOf $jResp "Endpoint.KafkaSettings.MessageFormat"]
set MessageMaxBytes [CkJsonObject_IntOf $jResp "Endpoint.KafkaSettings.MessageMaxBytes"]
set NoHexPrefix [CkJsonObject_IntOf $jResp "Endpoint.KafkaSettings.NoHexPrefix"]
set PartitionIncludeSchemaTable [CkJsonObject_IntOf $jResp "Endpoint.KafkaSettings.PartitionIncludeSchemaTable"]
set SaslPassword [CkJsonObject_stringOf $jResp "Endpoint.KafkaSettings.SaslPassword"]
set SaslUsername [CkJsonObject_stringOf $jResp "Endpoint.KafkaSettings.SaslUsername"]
set SecurityProtocol [CkJsonObject_stringOf $jResp "Endpoint.KafkaSettings.SecurityProtocol"]
set SslCaCertificateArn [CkJsonObject_stringOf $jResp "Endpoint.KafkaSettings.SslCaCertificateArn"]
set SslClientCertificateArn [CkJsonObject_stringOf $jResp "Endpoint.KafkaSettings.SslClientCertificateArn"]
set SslClientKeyArn [CkJsonObject_stringOf $jResp "Endpoint.KafkaSettings.SslClientKeyArn"]
set SslClientKeyPassword [CkJsonObject_stringOf $jResp "Endpoint.KafkaSettings.SslClientKeyPassword"]
set Topic [CkJsonObject_stringOf $jResp "Endpoint.KafkaSettings.Topic"]
set KinesisSettingsIncludeControlDetails [CkJsonObject_IntOf $jResp "Endpoint.KinesisSettings.IncludeControlDetails"]
set KinesisSettingsIncludeNullAndEmpty [CkJsonObject_IntOf $jResp "Endpoint.KinesisSettings.IncludeNullAndEmpty"]
set KinesisSettingsIncludePartitionValue [CkJsonObject_IntOf $jResp "Endpoint.KinesisSettings.IncludePartitionValue"]
set KinesisSettingsIncludeTableAlterOperations [CkJsonObject_IntOf $jResp "Endpoint.KinesisSettings.IncludeTableAlterOperations"]
set KinesisSettingsIncludeTransactionDetails [CkJsonObject_IntOf $jResp "Endpoint.KinesisSettings.IncludeTransactionDetails"]
set KinesisSettingsMessageFormat [CkJsonObject_stringOf $jResp "Endpoint.KinesisSettings.MessageFormat"]
set KinesisSettingsNoHexPrefix [CkJsonObject_IntOf $jResp "Endpoint.KinesisSettings.NoHexPrefix"]
set KinesisSettingsPartitionIncludeSchemaTable [CkJsonObject_IntOf $jResp "Endpoint.KinesisSettings.PartitionIncludeSchemaTable"]
set KinesisSettingsServiceAccessRoleArn [CkJsonObject_stringOf $jResp "Endpoint.KinesisSettings.ServiceAccessRoleArn"]
set StreamArn [CkJsonObject_stringOf $jResp "Endpoint.KinesisSettings.StreamArn"]
set EndpointKmsKeyId [CkJsonObject_stringOf $jResp "Endpoint.KmsKeyId"]
set BcpPacketSize [CkJsonObject_IntOf $jResp "Endpoint.MicrosoftSQLServerSettings.BcpPacketSize"]
set ControlTablesFileGroup [CkJsonObject_stringOf $jResp "Endpoint.MicrosoftSQLServerSettings.ControlTablesFileGroup"]
set MicrosoftSQLServerSettingsDatabaseName [CkJsonObject_stringOf $jResp "Endpoint.MicrosoftSQLServerSettings.DatabaseName"]
set MicrosoftSQLServerSettingsPassword [CkJsonObject_stringOf $jResp "Endpoint.MicrosoftSQLServerSettings.Password"]
set MicrosoftSQLServerSettingsPort [CkJsonObject_IntOf $jResp "Endpoint.MicrosoftSQLServerSettings.Port"]
set QuerySingleAlwaysOnNode [CkJsonObject_IntOf $jResp "Endpoint.MicrosoftSQLServerSettings.QuerySingleAlwaysOnNode"]
set ReadBackupOnly [CkJsonObject_IntOf $jResp "Endpoint.MicrosoftSQLServerSettings.ReadBackupOnly"]
set SafeguardPolicy [CkJsonObject_stringOf $jResp "Endpoint.MicrosoftSQLServerSettings.SafeguardPolicy"]
set MicrosoftSQLServerSettingsSecretsManagerAccessRoleArn [CkJsonObject_stringOf $jResp "Endpoint.MicrosoftSQLServerSettings.SecretsManagerAccessRoleArn"]
set MicrosoftSQLServerSettingsSecretsManagerSecretId [CkJsonObject_stringOf $jResp "Endpoint.MicrosoftSQLServerSettings.SecretsManagerSecretId"]
set MicrosoftSQLServerSettingsServerName [CkJsonObject_stringOf $jResp "Endpoint.MicrosoftSQLServerSettings.ServerName"]
set UseBcpFullLoad [CkJsonObject_IntOf $jResp "Endpoint.MicrosoftSQLServerSettings.UseBcpFullLoad"]
set MicrosoftSQLServerSettingsUsername [CkJsonObject_stringOf $jResp "Endpoint.MicrosoftSQLServerSettings.Username"]
set UseThirdPartyBackupDevice [CkJsonObject_IntOf $jResp "Endpoint.MicrosoftSQLServerSettings.UseThirdPartyBackupDevice"]
set AuthMechanism [CkJsonObject_stringOf $jResp "Endpoint.MongoDbSettings.AuthMechanism"]
set AuthSource [CkJsonObject_stringOf $jResp "Endpoint.MongoDbSettings.AuthSource"]
set AuthType [CkJsonObject_stringOf $jResp "Endpoint.MongoDbSettings.AuthType"]
set MongoDbSettingsDatabaseName [CkJsonObject_stringOf $jResp "Endpoint.MongoDbSettings.DatabaseName"]
set MongoDbSettingsDocsToInvestigate [CkJsonObject_stringOf $jResp "Endpoint.MongoDbSettings.DocsToInvestigate"]
set MongoDbSettingsExtractDocId [CkJsonObject_stringOf $jResp "Endpoint.MongoDbSettings.ExtractDocId"]
set MongoDbSettingsKmsKeyId [CkJsonObject_stringOf $jResp "Endpoint.MongoDbSettings.KmsKeyId"]
set MongoDbSettingsNestingLevel [CkJsonObject_stringOf $jResp "Endpoint.MongoDbSettings.NestingLevel"]
set MongoDbSettingsPassword [CkJsonObject_stringOf $jResp "Endpoint.MongoDbSettings.Password"]
set MongoDbSettingsPort [CkJsonObject_IntOf $jResp "Endpoint.MongoDbSettings.Port"]
set MongoDbSettingsSecretsManagerAccessRoleArn [CkJsonObject_stringOf $jResp "Endpoint.MongoDbSettings.SecretsManagerAccessRoleArn"]
set MongoDbSettingsSecretsManagerSecretId [CkJsonObject_stringOf $jResp "Endpoint.MongoDbSettings.SecretsManagerSecretId"]
set MongoDbSettingsServerName [CkJsonObject_stringOf $jResp "Endpoint.MongoDbSettings.ServerName"]
set MongoDbSettingsUsername [CkJsonObject_stringOf $jResp "Endpoint.MongoDbSettings.Username"]
set MySQLSettingsAfterConnectScript [CkJsonObject_stringOf $jResp "Endpoint.MySQLSettings.AfterConnectScript"]
set MySQLSettingsCleanSourceMetadataOnMismatch [CkJsonObject_IntOf $jResp "Endpoint.MySQLSettings.CleanSourceMetadataOnMismatch"]
set MySQLSettingsDatabaseName [CkJsonObject_stringOf $jResp "Endpoint.MySQLSettings.DatabaseName"]
set MySQLSettingsEventsPollInterval [CkJsonObject_IntOf $jResp "Endpoint.MySQLSettings.EventsPollInterval"]
set MySQLSettingsMaxFileSize [CkJsonObject_IntOf $jResp "Endpoint.MySQLSettings.MaxFileSize"]
set MySQLSettingsParallelLoadThreads [CkJsonObject_IntOf $jResp "Endpoint.MySQLSettings.ParallelLoadThreads"]
set MySQLSettingsPassword [CkJsonObject_stringOf $jResp "Endpoint.MySQLSettings.Password"]
set MySQLSettingsPort [CkJsonObject_IntOf $jResp "Endpoint.MySQLSettings.Port"]
set MySQLSettingsSecretsManagerAccessRoleArn [CkJsonObject_stringOf $jResp "Endpoint.MySQLSettings.SecretsManagerAccessRoleArn"]
set MySQLSettingsSecretsManagerSecretId [CkJsonObject_stringOf $jResp "Endpoint.MySQLSettings.SecretsManagerSecretId"]
set MySQLSettingsServerName [CkJsonObject_stringOf $jResp "Endpoint.MySQLSettings.ServerName"]
set MySQLSettingsServerTimezone [CkJsonObject_stringOf $jResp "Endpoint.MySQLSettings.ServerTimezone"]
set MySQLSettingsTargetDbType [CkJsonObject_stringOf $jResp "Endpoint.MySQLSettings.TargetDbType"]
set MySQLSettingsUsername [CkJsonObject_stringOf $jResp "Endpoint.MySQLSettings.Username"]
set NeptuneSettingsErrorRetryDuration [CkJsonObject_IntOf $jResp "Endpoint.NeptuneSettings.ErrorRetryDuration"]
set IamAuthEnabled [CkJsonObject_IntOf $jResp "Endpoint.NeptuneSettings.IamAuthEnabled"]
set NeptuneSettingsMaxFileSize [CkJsonObject_IntOf $jResp "Endpoint.NeptuneSettings.MaxFileSize"]
set MaxRetryCount [CkJsonObject_IntOf $jResp "Endpoint.NeptuneSettings.MaxRetryCount"]
set S3BucketFolder [CkJsonObject_stringOf $jResp "Endpoint.NeptuneSettings.S3BucketFolder"]
set S3BucketName [CkJsonObject_stringOf $jResp "Endpoint.NeptuneSettings.S3BucketName"]
set NeptuneSettingsServiceAccessRoleArn [CkJsonObject_stringOf $jResp "Endpoint.NeptuneSettings.ServiceAccessRoleArn"]
set AccessAlternateDirectly [CkJsonObject_IntOf $jResp "Endpoint.OracleSettings.AccessAlternateDirectly"]
set AdditionalArchivedLogDestId [CkJsonObject_IntOf $jResp "Endpoint.OracleSettings.AdditionalArchivedLogDestId"]
set AddSupplementalLogging [CkJsonObject_IntOf $jResp "Endpoint.OracleSettings.AddSupplementalLogging"]
set AllowSelectNestedTables [CkJsonObject_IntOf $jResp "Endpoint.OracleSettings.AllowSelectNestedTables"]
set ArchivedLogDestId [CkJsonObject_IntOf $jResp "Endpoint.OracleSettings.ArchivedLogDestId"]
set ArchivedLogsOnly [CkJsonObject_IntOf $jResp "Endpoint.OracleSettings.ArchivedLogsOnly"]
set AsmPassword [CkJsonObject_stringOf $jResp "Endpoint.OracleSettings.AsmPassword"]
set AsmServer [CkJsonObject_stringOf $jResp "Endpoint.OracleSettings.AsmServer"]
set AsmUser [CkJsonObject_stringOf $jResp "Endpoint.OracleSettings.AsmUser"]
set CharLengthSemantics [CkJsonObject_stringOf $jResp "Endpoint.OracleSettings.CharLengthSemantics"]
set OracleSettingsDatabaseName [CkJsonObject_stringOf $jResp "Endpoint.OracleSettings.DatabaseName"]
set DirectPathNoLog [CkJsonObject_IntOf $jResp "Endpoint.OracleSettings.DirectPathNoLog"]
set DirectPathParallelLoad [CkJsonObject_IntOf $jResp "Endpoint.OracleSettings.DirectPathParallelLoad"]
set EnableHomogenousTablespace [CkJsonObject_IntOf $jResp "Endpoint.OracleSettings.EnableHomogenousTablespace"]
set FailTasksOnLobTruncation [CkJsonObject_IntOf $jResp "Endpoint.OracleSettings.FailTasksOnLobTruncation"]
set NumberDatatypeScale [CkJsonObject_IntOf $jResp "Endpoint.OracleSettings.NumberDatatypeScale"]
set OraclePathPrefix [CkJsonObject_stringOf $jResp "Endpoint.OracleSettings.OraclePathPrefix"]
set ParallelAsmReadThreads [CkJsonObject_IntOf $jResp "Endpoint.OracleSettings.ParallelAsmReadThreads"]
set OracleSettingsPassword [CkJsonObject_stringOf $jResp "Endpoint.OracleSettings.Password"]
set OracleSettingsPort [CkJsonObject_IntOf $jResp "Endpoint.OracleSettings.Port"]
set ReadAheadBlocks [CkJsonObject_IntOf $jResp "Endpoint.OracleSettings.ReadAheadBlocks"]
set ReadTableSpaceName [CkJsonObject_IntOf $jResp "Endpoint.OracleSettings.ReadTableSpaceName"]
set ReplacePathPrefix [CkJsonObject_IntOf $jResp "Endpoint.OracleSettings.ReplacePathPrefix"]
set RetryInterval [CkJsonObject_IntOf $jResp "Endpoint.OracleSettings.RetryInterval"]
set OracleSettingsSecretsManagerAccessRoleArn [CkJsonObject_stringOf $jResp "Endpoint.OracleSettings.SecretsManagerAccessRoleArn"]
set SecretsManagerOracleAsmAccessRoleArn [CkJsonObject_stringOf $jResp "Endpoint.OracleSettings.SecretsManagerOracleAsmAccessRoleArn"]
set SecretsManagerOracleAsmSecretId [CkJsonObject_stringOf $jResp "Endpoint.OracleSettings.SecretsManagerOracleAsmSecretId"]
set OracleSettingsSecretsManagerSecretId [CkJsonObject_stringOf $jResp "Endpoint.OracleSettings.SecretsManagerSecretId"]
set SecurityDbEncryption [CkJsonObject_stringOf $jResp "Endpoint.OracleSettings.SecurityDbEncryption"]
set SecurityDbEncryptionName [CkJsonObject_stringOf $jResp "Endpoint.OracleSettings.SecurityDbEncryptionName"]
set OracleSettingsServerName [CkJsonObject_stringOf $jResp "Endpoint.OracleSettings.ServerName"]
set SpatialDataOptionToGeoJsonFunctionName [CkJsonObject_stringOf $jResp "Endpoint.OracleSettings.SpatialDataOptionToGeoJsonFunctionName"]
set StandbyDelayTime [CkJsonObject_IntOf $jResp "Endpoint.OracleSettings.StandbyDelayTime"]
set UseAlternateFolderForOnline [CkJsonObject_IntOf $jResp "Endpoint.OracleSettings.UseAlternateFolderForOnline"]
set UseBFile [CkJsonObject_IntOf $jResp "Endpoint.OracleSettings.UseBFile"]
set UseDirectPathFullLoad [CkJsonObject_IntOf $jResp "Endpoint.OracleSettings.UseDirectPathFullLoad"]
set UseLogminerReader [CkJsonObject_IntOf $jResp "Endpoint.OracleSettings.UseLogminerReader"]
set UsePathPrefix [CkJsonObject_stringOf $jResp "Endpoint.OracleSettings.UsePathPrefix"]
set OracleSettingsUsername [CkJsonObject_stringOf $jResp "Endpoint.OracleSettings.Username"]
set EndpointPort [CkJsonObject_IntOf $jResp "Endpoint.Port"]
set PostgreSQLSettingsAfterConnectScript [CkJsonObject_stringOf $jResp "Endpoint.PostgreSQLSettings.AfterConnectScript"]
set CaptureDdls [CkJsonObject_IntOf $jResp "Endpoint.PostgreSQLSettings.CaptureDdls"]
set PostgreSQLSettingsDatabaseName [CkJsonObject_stringOf $jResp "Endpoint.PostgreSQLSettings.DatabaseName"]
set DdlArtifactsSchema [CkJsonObject_stringOf $jResp "Endpoint.PostgreSQLSettings.DdlArtifactsSchema"]
set ExecuteTimeout [CkJsonObject_IntOf $jResp "Endpoint.PostgreSQLSettings.ExecuteTimeout"]
set PostgreSQLSettingsFailTasksOnLobTruncation [CkJsonObject_IntOf $jResp "Endpoint.PostgreSQLSettings.FailTasksOnLobTruncation"]
set HeartbeatEnable [CkJsonObject_IntOf $jResp "Endpoint.PostgreSQLSettings.HeartbeatEnable"]
set HeartbeatFrequency [CkJsonObject_IntOf $jResp "Endpoint.PostgreSQLSettings.HeartbeatFrequency"]
set HeartbeatSchema [CkJsonObject_stringOf $jResp "Endpoint.PostgreSQLSettings.HeartbeatSchema"]
set PostgreSQLSettingsMaxFileSize [CkJsonObject_IntOf $jResp "Endpoint.PostgreSQLSettings.MaxFileSize"]
set PostgreSQLSettingsPassword [CkJsonObject_stringOf $jResp "Endpoint.PostgreSQLSettings.Password"]
set PluginName [CkJsonObject_stringOf $jResp "Endpoint.PostgreSQLSettings.PluginName"]
set PostgreSQLSettingsPort [CkJsonObject_IntOf $jResp "Endpoint.PostgreSQLSettings.Port"]
set PostgreSQLSettingsSecretsManagerAccessRoleArn [CkJsonObject_stringOf $jResp "Endpoint.PostgreSQLSettings.SecretsManagerAccessRoleArn"]
set PostgreSQLSettingsSecretsManagerSecretId [CkJsonObject_stringOf $jResp "Endpoint.PostgreSQLSettings.SecretsManagerSecretId"]
set PostgreSQLSettingsServerName [CkJsonObject_stringOf $jResp "Endpoint.PostgreSQLSettings.ServerName"]
set SlotName [CkJsonObject_stringOf $jResp "Endpoint.PostgreSQLSettings.SlotName"]
set PostgreSQLSettingsUsername [CkJsonObject_stringOf $jResp "Endpoint.PostgreSQLSettings.Username"]
set AuthPassword [CkJsonObject_stringOf $jResp "Endpoint.RedisSettings.AuthPassword"]
set RedisSettingsAuthType [CkJsonObject_stringOf $jResp "Endpoint.RedisSettings.AuthType"]
set AuthUserName [CkJsonObject_stringOf $jResp "Endpoint.RedisSettings.AuthUserName"]
set RedisSettingsPort [CkJsonObject_IntOf $jResp "Endpoint.RedisSettings.Port"]
set RedisSettingsServerName [CkJsonObject_stringOf $jResp "Endpoint.RedisSettings.ServerName"]
set RedisSettingsSslCaCertificateArn [CkJsonObject_stringOf $jResp "Endpoint.RedisSettings.SslCaCertificateArn"]
set SslSecurityProtocol [CkJsonObject_stringOf $jResp "Endpoint.RedisSettings.SslSecurityProtocol"]
set AcceptAnyDate [CkJsonObject_IntOf $jResp "Endpoint.RedshiftSettings.AcceptAnyDate"]
set RedshiftSettingsAfterConnectScript [CkJsonObject_stringOf $jResp "Endpoint.RedshiftSettings.AfterConnectScript"]
set BucketFolder [CkJsonObject_stringOf $jResp "Endpoint.RedshiftSettings.BucketFolder"]
set RedshiftSettingsBucketName [CkJsonObject_stringOf $jResp "Endpoint.RedshiftSettings.BucketName"]
set CaseSensitiveNames [CkJsonObject_IntOf $jResp "Endpoint.RedshiftSettings.CaseSensitiveNames"]
set CompUpdate [CkJsonObject_IntOf $jResp "Endpoint.RedshiftSettings.CompUpdate"]
set ConnectionTimeout [CkJsonObject_IntOf $jResp "Endpoint.RedshiftSettings.ConnectionTimeout"]
set RedshiftSettingsDatabaseName [CkJsonObject_stringOf $jResp "Endpoint.RedshiftSettings.DatabaseName"]
set DateFormat [CkJsonObject_stringOf $jResp "Endpoint.RedshiftSettings.DateFormat"]
set EmptyAsNull [CkJsonObject_IntOf $jResp "Endpoint.RedshiftSettings.EmptyAsNull"]
set EncryptionMode [CkJsonObject_stringOf $jResp "Endpoint.RedshiftSettings.EncryptionMode"]
set ExplicitIds [CkJsonObject_IntOf $jResp "Endpoint.RedshiftSettings.ExplicitIds"]
set FileTransferUploadStreams [CkJsonObject_IntOf $jResp "Endpoint.RedshiftSettings.FileTransferUploadStreams"]
set LoadTimeout [CkJsonObject_IntOf $jResp "Endpoint.RedshiftSettings.LoadTimeout"]
set RedshiftSettingsMaxFileSize [CkJsonObject_IntOf $jResp "Endpoint.RedshiftSettings.MaxFileSize"]
set RedshiftSettingsPassword [CkJsonObject_stringOf $jResp "Endpoint.RedshiftSettings.Password"]
set RedshiftSettingsPort [CkJsonObject_IntOf $jResp "Endpoint.RedshiftSettings.Port"]
set RemoveQuotes [CkJsonObject_IntOf $jResp "Endpoint.RedshiftSettings.RemoveQuotes"]
set ReplaceChars [CkJsonObject_stringOf $jResp "Endpoint.RedshiftSettings.ReplaceChars"]
set ReplaceInvalidChars [CkJsonObject_stringOf $jResp "Endpoint.RedshiftSettings.ReplaceInvalidChars"]
set RedshiftSettingsSecretsManagerAccessRoleArn [CkJsonObject_stringOf $jResp "Endpoint.RedshiftSettings.SecretsManagerAccessRoleArn"]
set RedshiftSettingsSecretsManagerSecretId [CkJsonObject_stringOf $jResp "Endpoint.RedshiftSettings.SecretsManagerSecretId"]
set RedshiftSettingsServerName [CkJsonObject_stringOf $jResp "Endpoint.RedshiftSettings.ServerName"]
set ServerSideEncryptionKmsKeyId [CkJsonObject_stringOf $jResp "Endpoint.RedshiftSettings.ServerSideEncryptionKmsKeyId"]
set RedshiftSettingsServiceAccessRoleArn [CkJsonObject_stringOf $jResp "Endpoint.RedshiftSettings.ServiceAccessRoleArn"]
set TimeFormat [CkJsonObject_stringOf $jResp "Endpoint.RedshiftSettings.TimeFormat"]
set TrimBlanks [CkJsonObject_IntOf $jResp "Endpoint.RedshiftSettings.TrimBlanks"]
set TruncateColumns [CkJsonObject_IntOf $jResp "Endpoint.RedshiftSettings.TruncateColumns"]
set RedshiftSettingsUsername [CkJsonObject_stringOf $jResp "Endpoint.RedshiftSettings.Username"]
set WriteBufferSize [CkJsonObject_IntOf $jResp "Endpoint.RedshiftSettings.WriteBufferSize"]
set AddColumnName [CkJsonObject_IntOf $jResp "Endpoint.S3Settings.AddColumnName"]
set S3SettingsBucketFolder [CkJsonObject_stringOf $jResp "Endpoint.S3Settings.BucketFolder"]
set S3SettingsBucketName [CkJsonObject_stringOf $jResp "Endpoint.S3Settings.BucketName"]
set CannedAclForObjects [CkJsonObject_stringOf $jResp "Endpoint.S3Settings.CannedAclForObjects"]
set CdcInsertsAndUpdates [CkJsonObject_IntOf $jResp "Endpoint.S3Settings.CdcInsertsAndUpdates"]
set CdcInsertsOnly [CkJsonObject_IntOf $jResp "Endpoint.S3Settings.CdcInsertsOnly"]
set CdcMaxBatchInterval [CkJsonObject_IntOf $jResp "Endpoint.S3Settings.CdcMaxBatchInterval"]
set CdcMinFileSize [CkJsonObject_IntOf $jResp "Endpoint.S3Settings.CdcMinFileSize"]
set CdcPath [CkJsonObject_stringOf $jResp "Endpoint.S3Settings.CdcPath"]
set CompressionType [CkJsonObject_stringOf $jResp "Endpoint.S3Settings.CompressionType"]
set CsvDelimiter [CkJsonObject_stringOf $jResp "Endpoint.S3Settings.CsvDelimiter"]
set CsvNoSupValue [CkJsonObject_stringOf $jResp "Endpoint.S3Settings.CsvNoSupValue"]
set CsvNullValue [CkJsonObject_stringOf $jResp "Endpoint.S3Settings.CsvNullValue"]
set CsvRowDelimiter [CkJsonObject_stringOf $jResp "Endpoint.S3Settings.CsvRowDelimiter"]
set DataFormat [CkJsonObject_stringOf $jResp "Endpoint.S3Settings.DataFormat"]
set DataPageSize [CkJsonObject_IntOf $jResp "Endpoint.S3Settings.DataPageSize"]
set DatePartitionDelimiter [CkJsonObject_stringOf $jResp "Endpoint.S3Settings.DatePartitionDelimiter"]
set DatePartitionEnabled [CkJsonObject_IntOf $jResp "Endpoint.S3Settings.DatePartitionEnabled"]
set DatePartitionSequence [CkJsonObject_stringOf $jResp "Endpoint.S3Settings.DatePartitionSequence"]
set DatePartitionTimezone [CkJsonObject_stringOf $jResp "Endpoint.S3Settings.DatePartitionTimezone"]
set DictPageSizeLimit [CkJsonObject_IntOf $jResp "Endpoint.S3Settings.DictPageSizeLimit"]
set EnableStatistics [CkJsonObject_IntOf $jResp "Endpoint.S3Settings.EnableStatistics"]
set EncodingType [CkJsonObject_stringOf $jResp "Endpoint.S3Settings.EncodingType"]
set S3SettingsEncryptionMode [CkJsonObject_stringOf $jResp "Endpoint.S3Settings.EncryptionMode"]
set S3SettingsExternalTableDefinition [CkJsonObject_stringOf $jResp "Endpoint.S3Settings.ExternalTableDefinition"]
set IgnoreHeaderRows [CkJsonObject_IntOf $jResp "Endpoint.S3Settings.IgnoreHeaderRows"]
set IncludeOpForFullLoad [CkJsonObject_IntOf $jResp "Endpoint.S3Settings.IncludeOpForFullLoad"]
set S3SettingsMaxFileSize [CkJsonObject_IntOf $jResp "Endpoint.S3Settings.MaxFileSize"]
set ParquetTimestampInMillisecond [CkJsonObject_IntOf $jResp "Endpoint.S3Settings.ParquetTimestampInMillisecond"]
set ParquetVersion [CkJsonObject_stringOf $jResp "Endpoint.S3Settings.ParquetVersion"]
set PreserveTransactions [CkJsonObject_IntOf $jResp "Endpoint.S3Settings.PreserveTransactions"]
set Rfc4180 [CkJsonObject_IntOf $jResp "Endpoint.S3Settings.Rfc4180"]
set RowGroupLength [CkJsonObject_IntOf $jResp "Endpoint.S3Settings.RowGroupLength"]
set S3SettingsServerSideEncryptionKmsKeyId [CkJsonObject_stringOf $jResp "Endpoint.S3Settings.ServerSideEncryptionKmsKeyId"]
set S3SettingsServiceAccessRoleArn [CkJsonObject_stringOf $jResp "Endpoint.S3Settings.ServiceAccessRoleArn"]
set TimestampColumnName [CkJsonObject_stringOf $jResp "Endpoint.S3Settings.TimestampColumnName"]
set UseCsvNoSupValue [CkJsonObject_IntOf $jResp "Endpoint.S3Settings.UseCsvNoSupValue"]
set UseTaskStartTimeForFullLoadTimestamp [CkJsonObject_IntOf $jResp "Endpoint.S3Settings.UseTaskStartTimeForFullLoadTimestamp"]
set EndpointServerName [CkJsonObject_stringOf $jResp "Endpoint.ServerName"]
set EndpointServiceAccessRoleArn [CkJsonObject_stringOf $jResp "Endpoint.ServiceAccessRoleArn"]
set SslMode [CkJsonObject_stringOf $jResp "Endpoint.SslMode"]
set Status [CkJsonObject_stringOf $jResp "Endpoint.Status"]
set SybaseSettingsDatabaseName [CkJsonObject_stringOf $jResp "Endpoint.SybaseSettings.DatabaseName"]
set SybaseSettingsPassword [CkJsonObject_stringOf $jResp "Endpoint.SybaseSettings.Password"]
set SybaseSettingsPort [CkJsonObject_IntOf $jResp "Endpoint.SybaseSettings.Port"]
set SybaseSettingsSecretsManagerAccessRoleArn [CkJsonObject_stringOf $jResp "Endpoint.SybaseSettings.SecretsManagerAccessRoleArn"]
set SybaseSettingsSecretsManagerSecretId [CkJsonObject_stringOf $jResp "Endpoint.SybaseSettings.SecretsManagerSecretId"]
set SybaseSettingsServerName [CkJsonObject_stringOf $jResp "Endpoint.SybaseSettings.ServerName"]
set SybaseSettingsUsername [CkJsonObject_stringOf $jResp "Endpoint.SybaseSettings.Username"]
set EndpointUsername [CkJsonObject_stringOf $jResp "Endpoint.Username"]
set i 0
set count_i [CkJsonObject_SizeOfArray $jResp "Endpoint.OracleSettings.ExtraArchivedLogDestIds"]
while {$i < $count_i} {
CkJsonObject_put_I $jResp $i
set intVal [CkJsonObject_IntOf $jResp "Endpoint.OracleSettings.ExtraArchivedLogDestIds[i]"]
set i [expr $i + 1]
}
# A sample JSON response body parsed by the above code:
# {
# "Endpoint": {
# "CertificateArn": "string",
# "DatabaseName": "string",
# "DmsTransferSettings": {
# "BucketName": "string",
# "ServiceAccessRoleArn": "string"
# },
# "DocDbSettings": {
# "DatabaseName": "string",
# "DocsToInvestigate": number,
# "ExtractDocId": boolean,
# "KmsKeyId": "string",
# "NestingLevel": "string",
# "Password": "string",
# "Port": number,
# "SecretsManagerAccessRoleArn": "string",
# "SecretsManagerSecretId": "string",
# "ServerName": "string",
# "Username": "string"
# },
# "DynamoDbSettings": {
# "ServiceAccessRoleArn": "string"
# },
# "ElasticsearchSettings": {
# "EndpointUri": "string",
# "ErrorRetryDuration": number,
# "FullLoadErrorPercentage": number,
# "ServiceAccessRoleArn": "string"
# },
# "EndpointArn": "string",
# "EndpointIdentifier": "string",
# "EndpointType": "string",
# "EngineDisplayName": "string",
# "EngineName": "string",
# "ExternalId": "string",
# "ExternalTableDefinition": "string",
# "ExtraConnectionAttributes": "string",
# "GcpMySQLSettings": {
# "AfterConnectScript": "string",
# "CleanSourceMetadataOnMismatch": boolean,
# "DatabaseName": "string",
# "EventsPollInterval": number,
# "MaxFileSize": number,
# "ParallelLoadThreads": number,
# "Password": "string",
# "Port": number,
# "SecretsManagerAccessRoleArn": "string",
# "SecretsManagerSecretId": "string",
# "ServerName": "string",
# "ServerTimezone": "string",
# "TargetDbType": "string",
# "Username": "string"
# },
# "IBMDb2Settings": {
# "CurrentLsn": "string",
# "DatabaseName": "string",
# "MaxKBytesPerRead": number,
# "Password": "string",
# "Port": number,
# "SecretsManagerAccessRoleArn": "string",
# "SecretsManagerSecretId": "string",
# "ServerName": "string",
# "SetDataCaptureChanges": boolean,
# "Username": "string"
# },
# "KafkaSettings": {
# "Broker": "string",
# "IncludeControlDetails": boolean,
# "IncludeNullAndEmpty": boolean,
# "IncludePartitionValue": boolean,
# "IncludeTableAlterOperations": boolean,
# "IncludeTransactionDetails": boolean,
# "MessageFormat": "string",
# "MessageMaxBytes": number,
# "NoHexPrefix": boolean,
# "PartitionIncludeSchemaTable": boolean,
# "SaslPassword": "string",
# "SaslUsername": "string",
# "SecurityProtocol": "string",
# "SslCaCertificateArn": "string",
# "SslClientCertificateArn": "string",
# "SslClientKeyArn": "string",
# "SslClientKeyPassword": "string",
# "Topic": "string"
# },
# "KinesisSettings": {
# "IncludeControlDetails": boolean,
# "IncludeNullAndEmpty": boolean,
# "IncludePartitionValue": boolean,
# "IncludeTableAlterOperations": boolean,
# "IncludeTransactionDetails": boolean,
# "MessageFormat": "string",
# "NoHexPrefix": boolean,
# "PartitionIncludeSchemaTable": boolean,
# "ServiceAccessRoleArn": "string",
# "StreamArn": "string"
# },
# "KmsKeyId": "string",
# "MicrosoftSQLServerSettings": {
# "BcpPacketSize": number,
# "ControlTablesFileGroup": "string",
# "DatabaseName": "string",
# "Password": "string",
# "Port": number,
# "QuerySingleAlwaysOnNode": boolean,
# "ReadBackupOnly": boolean,
# "SafeguardPolicy": "string",
# "SecretsManagerAccessRoleArn": "string",
# "SecretsManagerSecretId": "string",
# "ServerName": "string",
# "UseBcpFullLoad": boolean,
# "Username": "string",
# "UseThirdPartyBackupDevice": boolean
# },
# "MongoDbSettings": {
# "AuthMechanism": "string",
# "AuthSource": "string",
# "AuthType": "string",
# "DatabaseName": "string",
# "DocsToInvestigate": "string",
# "ExtractDocId": "string",
# "KmsKeyId": "string",
# "NestingLevel": "string",
# "Password": "string",
# "Port": number,
# "SecretsManagerAccessRoleArn": "string",
# "SecretsManagerSecretId": "string",
# "ServerName": "string",
# "Username": "string"
# },
# "MySQLSettings": {
# "AfterConnectScript": "string",
# "CleanSourceMetadataOnMismatch": boolean,
# "DatabaseName": "string",
# "EventsPollInterval": number,
# "MaxFileSize": number,
# "ParallelLoadThreads": number,
# "Password": "string",
# "Port": number,
# "SecretsManagerAccessRoleArn": "string",
# "SecretsManagerSecretId": "string",
# "ServerName": "string",
# "ServerTimezone": "string",
# "TargetDbType": "string",
# "Username": "string"
# },
# "NeptuneSettings": {
# "ErrorRetryDuration": number,
# "IamAuthEnabled": boolean,
# "MaxFileSize": number,
# "MaxRetryCount": number,
# "S3BucketFolder": "string",
# "S3BucketName": "string",
# "ServiceAccessRoleArn": "string"
# },
# "OracleSettings": {
# "AccessAlternateDirectly": boolean,
# "AdditionalArchivedLogDestId": number,
# "AddSupplementalLogging": boolean,
# "AllowSelectNestedTables": boolean,
# "ArchivedLogDestId": number,
# "ArchivedLogsOnly": boolean,
# "AsmPassword": "string",
# "AsmServer": "string",
# "AsmUser": "string",
# "CharLengthSemantics": "string",
# "DatabaseName": "string",
# "DirectPathNoLog": boolean,
# "DirectPathParallelLoad": boolean,
# "EnableHomogenousTablespace": boolean,
# "ExtraArchivedLogDestIds": [
# number
# ],
# "FailTasksOnLobTruncation": boolean,
# "NumberDatatypeScale": number,
# "OraclePathPrefix": "string",
# "ParallelAsmReadThreads": number,
# "Password": "string",
# "Port": number,
# "ReadAheadBlocks": number,
# "ReadTableSpaceName": boolean,
# "ReplacePathPrefix": boolean,
# "RetryInterval": number,
# "SecretsManagerAccessRoleArn": "string",
# "SecretsManagerOracleAsmAccessRoleArn": "string",
# "SecretsManagerOracleAsmSecretId": "string",
# "SecretsManagerSecretId": "string",
# "SecurityDbEncryption": "string",
# "SecurityDbEncryptionName": "string",
# "ServerName": "string",
# "SpatialDataOptionToGeoJsonFunctionName": "string",
# "StandbyDelayTime": number,
# "UseAlternateFolderForOnline": boolean,
# "UseBFile": boolean,
# "UseDirectPathFullLoad": boolean,
# "UseLogminerReader": boolean,
# "UsePathPrefix": "string",
# "Username": "string"
# },
# "Port": number,
# "PostgreSQLSettings": {
# "AfterConnectScript": "string",
# "CaptureDdls": boolean,
# "DatabaseName": "string",
# "DdlArtifactsSchema": "string",
# "ExecuteTimeout": number,
# "FailTasksOnLobTruncation": boolean,
# "HeartbeatEnable": boolean,
# "HeartbeatFrequency": number,
# "HeartbeatSchema": "string",
# "MaxFileSize": number,
# "Password": "string",
# "PluginName": "string",
# "Port": number,
# "SecretsManagerAccessRoleArn": "string",
# "SecretsManagerSecretId": "string",
# "ServerName": "string",
# "SlotName": "string",
# "Username": "string"
# },
# "RedisSettings": {
# "AuthPassword": "string",
# "AuthType": "string",
# "AuthUserName": "string",
# "Port": number,
# "ServerName": "string",
# "SslCaCertificateArn": "string",
# "SslSecurityProtocol": "string"
# },
# "RedshiftSettings": {
# "AcceptAnyDate": boolean,
# "AfterConnectScript": "string",
# "BucketFolder": "string",
# "BucketName": "string",
# "CaseSensitiveNames": boolean,
# "CompUpdate": boolean,
# "ConnectionTimeout": number,
# "DatabaseName": "string",
# "DateFormat": "string",
# "EmptyAsNull": boolean,
# "EncryptionMode": "string",
# "ExplicitIds": boolean,
# "FileTransferUploadStreams": number,
# "LoadTimeout": number,
# "MaxFileSize": number,
# "Password": "string",
# "Port": number,
# "RemoveQuotes": boolean,
# "ReplaceChars": "string",
# "ReplaceInvalidChars": "string",
# "SecretsManagerAccessRoleArn": "string",
# "SecretsManagerSecretId": "string",
# "ServerName": "string",
# "ServerSideEncryptionKmsKeyId": "string",
# "ServiceAccessRoleArn": "string",
# "TimeFormat": "string",
# "TrimBlanks": boolean,
# "TruncateColumns": boolean,
# "Username": "string",
# "WriteBufferSize": number
# },
# "S3Settings": {
# "AddColumnName": boolean,
# "BucketFolder": "string",
# "BucketName": "string",
# "CannedAclForObjects": "string",
# "CdcInsertsAndUpdates": boolean,
# "CdcInsertsOnly": boolean,
# "CdcMaxBatchInterval": number,
# "CdcMinFileSize": number,
# "CdcPath": "string",
# "CompressionType": "string",
# "CsvDelimiter": "string",
# "CsvNoSupValue": "string",
# "CsvNullValue": "string",
# "CsvRowDelimiter": "string",
# "DataFormat": "string",
# "DataPageSize": number,
# "DatePartitionDelimiter": "string",
# "DatePartitionEnabled": boolean,
# "DatePartitionSequence": "string",
# "DatePartitionTimezone": "string",
# "DictPageSizeLimit": number,
# "EnableStatistics": boolean,
# "EncodingType": "string",
# "EncryptionMode": "string",
# "ExternalTableDefinition": "string",
# "IgnoreHeaderRows": number,
# "IncludeOpForFullLoad": boolean,
# "MaxFileSize": number,
# "ParquetTimestampInMillisecond": boolean,
# "ParquetVersion": "string",
# "PreserveTransactions": boolean,
# "Rfc4180": boolean,
# "RowGroupLength": number,
# "ServerSideEncryptionKmsKeyId": "string",
# "ServiceAccessRoleArn": "string",
# "TimestampColumnName": "string",
# "UseCsvNoSupValue": boolean,
# "UseTaskStartTimeForFullLoadTimestamp": boolean
# },
# "ServerName": "string",
# "ServiceAccessRoleArn": "string",
# "SslMode": "string",
# "Status": "string",
# "SybaseSettings": {
# "DatabaseName": "string",
# "Password": "string",
# "Port": number,
# "SecretsManagerAccessRoleArn": "string",
# "SecretsManagerSecretId": "string",
# "ServerName": "string",
# "Username": "string"
# },
# "Username": "string"
# }
# }
delete_CkRest $rest
delete_CkAuthAws $authAws
delete_CkJsonObject $json
delete_CkStringBuilder $sbRequestBody
delete_CkStringBuilder $sbResponseBody
delete_CkJsonObject $jResp
