DeleteEndpoint VB.NET Example
' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.
Dim rest As New Chilkat.Rest
Dim success As Boolean
Dim authAws As New Chilkat.AuthAws
authAws.AccessKey = "AWS_ACCESS_KEY"
authAws.SecretKey = "AWS_SECRET_KEY"
' Don't forget to change the region to your particular region. (Also make the same change in the call to Connect below.)
authAws.Region = "us-west-2"
authAws.ServiceName = "dms"
' SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
rest.SetAuthAws(authAws)
' URL: https://dms.us-west-2.amazonaws.com/
' Use the same region as specified above.
success = rest.Connect("dms.us-west-2.amazonaws.com",443,True,True)
If (success <> True) Then
Debug.WriteLine("ConnectFailReason: " & rest.ConnectFailReason)
Debug.WriteLine(rest.LastErrorText)
Exit Sub
End If
' The following code creates the JSON request body.
' The JSON created by this code is shown below.
' Use this online tool to generate code from sample JSON:
' Generate Code to Create JSON
Dim json As New Chilkat.JsonObject
json.UpdateString("EndpointArn","string")
' The JSON request body created by the above code:
' {
' "EndpointArn": "string"
' }
rest.AddHeader("Content-Type","application/x-amz-json-1.1")
rest.AddHeader("X-Amz-Target","AmazonDMSv20160101.DeleteEndpoint")
Dim sbRequestBody As New Chilkat.StringBuilder
json.EmitSb(sbRequestBody)
Dim sbResponseBody As New Chilkat.StringBuilder
success = rest.FullRequestSb("POST","/",sbRequestBody,sbResponseBody)
If (success <> True) Then
Debug.WriteLine(rest.LastErrorText)
Exit Sub
End If
Dim respStatusCode As Integer = rest.ResponseStatusCode
Debug.WriteLine("response status code = " & respStatusCode)
If (respStatusCode <> 200) Then
Debug.WriteLine("Response Header:")
Debug.WriteLine(rest.ResponseHeader)
Debug.WriteLine("Response Body:")
Debug.WriteLine(sbResponseBody.GetAsString())
Exit Sub
End If
Dim jResp As New Chilkat.JsonObject
jResp.LoadSb(sbResponseBody)
' The following code parses the JSON response.
' A sample JSON response is shown below the sample code.
' Use this online tool to generate parsing code from sample JSON:
' Generate Parsing Code from JSON
Dim intVal As Integer
Dim CertificateArn As String = jResp.StringOf("Endpoint.CertificateArn")
Dim DatabaseName As String = jResp.StringOf("Endpoint.DatabaseName")
Dim BucketName As String = jResp.StringOf("Endpoint.DmsTransferSettings.BucketName")
Dim ServiceAccessRoleArn As String = jResp.StringOf("Endpoint.DmsTransferSettings.ServiceAccessRoleArn")
Dim DocDbSettingsDatabaseName As String = jResp.StringOf("Endpoint.DocDbSettings.DatabaseName")
Dim DocsToInvestigate As Integer = jResp.IntOf("Endpoint.DocDbSettings.DocsToInvestigate")
Dim ExtractDocId As Integer = jResp.IntOf("Endpoint.DocDbSettings.ExtractDocId")
Dim KmsKeyId As String = jResp.StringOf("Endpoint.DocDbSettings.KmsKeyId")
Dim NestingLevel As String = jResp.StringOf("Endpoint.DocDbSettings.NestingLevel")
Dim Password As String = jResp.StringOf("Endpoint.DocDbSettings.Password")
Dim Port As Integer = jResp.IntOf("Endpoint.DocDbSettings.Port")
Dim SecretsManagerAccessRoleArn As String = jResp.StringOf("Endpoint.DocDbSettings.SecretsManagerAccessRoleArn")
Dim SecretsManagerSecretId As String = jResp.StringOf("Endpoint.DocDbSettings.SecretsManagerSecretId")
Dim ServerName As String = jResp.StringOf("Endpoint.DocDbSettings.ServerName")
Dim Username As String = jResp.StringOf("Endpoint.DocDbSettings.Username")
Dim DynamoDbSettingsServiceAccessRoleArn As String = jResp.StringOf("Endpoint.DynamoDbSettings.ServiceAccessRoleArn")
Dim EndpointUri As String = jResp.StringOf("Endpoint.ElasticsearchSettings.EndpointUri")
Dim ErrorRetryDuration As Integer = jResp.IntOf("Endpoint.ElasticsearchSettings.ErrorRetryDuration")
Dim FullLoadErrorPercentage As Integer = jResp.IntOf("Endpoint.ElasticsearchSettings.FullLoadErrorPercentage")
Dim ElasticsearchSettingsServiceAccessRoleArn As String = jResp.StringOf("Endpoint.ElasticsearchSettings.ServiceAccessRoleArn")
Dim EndpointArn As String = jResp.StringOf("Endpoint.EndpointArn")
Dim EndpointIdentifier As String = jResp.StringOf("Endpoint.EndpointIdentifier")
Dim EndpointType As String = jResp.StringOf("Endpoint.EndpointType")
Dim EngineDisplayName As String = jResp.StringOf("Endpoint.EngineDisplayName")
Dim EngineName As String = jResp.StringOf("Endpoint.EngineName")
Dim ExternalId As String = jResp.StringOf("Endpoint.ExternalId")
Dim ExternalTableDefinition As String = jResp.StringOf("Endpoint.ExternalTableDefinition")
Dim ExtraConnectionAttributes As String = jResp.StringOf("Endpoint.ExtraConnectionAttributes")
Dim AfterConnectScript As String = jResp.StringOf("Endpoint.GcpMySQLSettings.AfterConnectScript")
Dim CleanSourceMetadataOnMismatch As Integer = jResp.IntOf("Endpoint.GcpMySQLSettings.CleanSourceMetadataOnMismatch")
Dim GcpMySQLSettingsDatabaseName As String = jResp.StringOf("Endpoint.GcpMySQLSettings.DatabaseName")
Dim EventsPollInterval As Integer = jResp.IntOf("Endpoint.GcpMySQLSettings.EventsPollInterval")
Dim MaxFileSize As Integer = jResp.IntOf("Endpoint.GcpMySQLSettings.MaxFileSize")
Dim ParallelLoadThreads As Integer = jResp.IntOf("Endpoint.GcpMySQLSettings.ParallelLoadThreads")
Dim GcpMySQLSettingsPassword As String = jResp.StringOf("Endpoint.GcpMySQLSettings.Password")
Dim GcpMySQLSettingsPort As Integer = jResp.IntOf("Endpoint.GcpMySQLSettings.Port")
Dim GcpMySQLSettingsSecretsManagerAccessRoleArn As String = jResp.StringOf("Endpoint.GcpMySQLSettings.SecretsManagerAccessRoleArn")
Dim GcpMySQLSettingsSecretsManagerSecretId As String = jResp.StringOf("Endpoint.GcpMySQLSettings.SecretsManagerSecretId")
Dim GcpMySQLSettingsServerName As String = jResp.StringOf("Endpoint.GcpMySQLSettings.ServerName")
Dim ServerTimezone As String = jResp.StringOf("Endpoint.GcpMySQLSettings.ServerTimezone")
Dim TargetDbType As String = jResp.StringOf("Endpoint.GcpMySQLSettings.TargetDbType")
Dim GcpMySQLSettingsUsername As String = jResp.StringOf("Endpoint.GcpMySQLSettings.Username")
Dim CurrentLsn As String = jResp.StringOf("Endpoint.IBMDb2Settings.CurrentLsn")
Dim IBMDb2SettingsDatabaseName As String = jResp.StringOf("Endpoint.IBMDb2Settings.DatabaseName")
Dim MaxKBytesPerRead As Integer = jResp.IntOf("Endpoint.IBMDb2Settings.MaxKBytesPerRead")
Dim IBMDb2SettingsPassword As String = jResp.StringOf("Endpoint.IBMDb2Settings.Password")
Dim IBMDb2SettingsPort As Integer = jResp.IntOf("Endpoint.IBMDb2Settings.Port")
Dim IBMDb2SettingsSecretsManagerAccessRoleArn As String = jResp.StringOf("Endpoint.IBMDb2Settings.SecretsManagerAccessRoleArn")
Dim IBMDb2SettingsSecretsManagerSecretId As String = jResp.StringOf("Endpoint.IBMDb2Settings.SecretsManagerSecretId")
Dim IBMDb2SettingsServerName As String = jResp.StringOf("Endpoint.IBMDb2Settings.ServerName")
Dim SetDataCaptureChanges As Integer = jResp.IntOf("Endpoint.IBMDb2Settings.SetDataCaptureChanges")
Dim IBMDb2SettingsUsername As String = jResp.StringOf("Endpoint.IBMDb2Settings.Username")
Dim Broker As String = jResp.StringOf("Endpoint.KafkaSettings.Broker")
Dim IncludeControlDetails As Integer = jResp.IntOf("Endpoint.KafkaSettings.IncludeControlDetails")
Dim IncludeNullAndEmpty As Integer = jResp.IntOf("Endpoint.KafkaSettings.IncludeNullAndEmpty")
Dim IncludePartitionValue As Integer = jResp.IntOf("Endpoint.KafkaSettings.IncludePartitionValue")
Dim IncludeTableAlterOperations As Integer = jResp.IntOf("Endpoint.KafkaSettings.IncludeTableAlterOperations")
Dim IncludeTransactionDetails As Integer = jResp.IntOf("Endpoint.KafkaSettings.IncludeTransactionDetails")
Dim MessageFormat As String = jResp.StringOf("Endpoint.KafkaSettings.MessageFormat")
Dim MessageMaxBytes As Integer = jResp.IntOf("Endpoint.KafkaSettings.MessageMaxBytes")
Dim NoHexPrefix As Integer = jResp.IntOf("Endpoint.KafkaSettings.NoHexPrefix")
Dim PartitionIncludeSchemaTable As Integer = jResp.IntOf("Endpoint.KafkaSettings.PartitionIncludeSchemaTable")
Dim SaslPassword As String = jResp.StringOf("Endpoint.KafkaSettings.SaslPassword")
Dim SaslUsername As String = jResp.StringOf("Endpoint.KafkaSettings.SaslUsername")
Dim SecurityProtocol As String = jResp.StringOf("Endpoint.KafkaSettings.SecurityProtocol")
Dim SslCaCertificateArn As String = jResp.StringOf("Endpoint.KafkaSettings.SslCaCertificateArn")
Dim SslClientCertificateArn As String = jResp.StringOf("Endpoint.KafkaSettings.SslClientCertificateArn")
Dim SslClientKeyArn As String = jResp.StringOf("Endpoint.KafkaSettings.SslClientKeyArn")
Dim SslClientKeyPassword As String = jResp.StringOf("Endpoint.KafkaSettings.SslClientKeyPassword")
Dim Topic As String = jResp.StringOf("Endpoint.KafkaSettings.Topic")
Dim KinesisSettingsIncludeControlDetails As Integer = jResp.IntOf("Endpoint.KinesisSettings.IncludeControlDetails")
Dim KinesisSettingsIncludeNullAndEmpty As Integer = jResp.IntOf("Endpoint.KinesisSettings.IncludeNullAndEmpty")
Dim KinesisSettingsIncludePartitionValue As Integer = jResp.IntOf("Endpoint.KinesisSettings.IncludePartitionValue")
Dim KinesisSettingsIncludeTableAlterOperations As Integer = jResp.IntOf("Endpoint.KinesisSettings.IncludeTableAlterOperations")
Dim KinesisSettingsIncludeTransactionDetails As Integer = jResp.IntOf("Endpoint.KinesisSettings.IncludeTransactionDetails")
Dim KinesisSettingsMessageFormat As String = jResp.StringOf("Endpoint.KinesisSettings.MessageFormat")
Dim KinesisSettingsNoHexPrefix As Integer = jResp.IntOf("Endpoint.KinesisSettings.NoHexPrefix")
Dim KinesisSettingsPartitionIncludeSchemaTable As Integer = jResp.IntOf("Endpoint.KinesisSettings.PartitionIncludeSchemaTable")
Dim KinesisSettingsServiceAccessRoleArn As String = jResp.StringOf("Endpoint.KinesisSettings.ServiceAccessRoleArn")
Dim StreamArn As String = jResp.StringOf("Endpoint.KinesisSettings.StreamArn")
Dim EndpointKmsKeyId As String = jResp.StringOf("Endpoint.KmsKeyId")
Dim BcpPacketSize As Integer = jResp.IntOf("Endpoint.MicrosoftSQLServerSettings.BcpPacketSize")
Dim ControlTablesFileGroup As String = jResp.StringOf("Endpoint.MicrosoftSQLServerSettings.ControlTablesFileGroup")
Dim MicrosoftSQLServerSettingsDatabaseName As String = jResp.StringOf("Endpoint.MicrosoftSQLServerSettings.DatabaseName")
Dim MicrosoftSQLServerSettingsPassword As String = jResp.StringOf("Endpoint.MicrosoftSQLServerSettings.Password")
Dim MicrosoftSQLServerSettingsPort As Integer = jResp.IntOf("Endpoint.MicrosoftSQLServerSettings.Port")
Dim QuerySingleAlwaysOnNode As Integer = jResp.IntOf("Endpoint.MicrosoftSQLServerSettings.QuerySingleAlwaysOnNode")
Dim ReadBackupOnly As Integer = jResp.IntOf("Endpoint.MicrosoftSQLServerSettings.ReadBackupOnly")
Dim SafeguardPolicy As String = jResp.StringOf("Endpoint.MicrosoftSQLServerSettings.SafeguardPolicy")
Dim MicrosoftSQLServerSettingsSecretsManagerAccessRoleArn As String = jResp.StringOf("Endpoint.MicrosoftSQLServerSettings.SecretsManagerAccessRoleArn")
Dim MicrosoftSQLServerSettingsSecretsManagerSecretId As String = jResp.StringOf("Endpoint.MicrosoftSQLServerSettings.SecretsManagerSecretId")
Dim MicrosoftSQLServerSettingsServerName As String = jResp.StringOf("Endpoint.MicrosoftSQLServerSettings.ServerName")
Dim UseBcpFullLoad As Integer = jResp.IntOf("Endpoint.MicrosoftSQLServerSettings.UseBcpFullLoad")
Dim MicrosoftSQLServerSettingsUsername As String = jResp.StringOf("Endpoint.MicrosoftSQLServerSettings.Username")
Dim UseThirdPartyBackupDevice As Integer = jResp.IntOf("Endpoint.MicrosoftSQLServerSettings.UseThirdPartyBackupDevice")
Dim AuthMechanism As String = jResp.StringOf("Endpoint.MongoDbSettings.AuthMechanism")
Dim AuthSource As String = jResp.StringOf("Endpoint.MongoDbSettings.AuthSource")
Dim AuthType As String = jResp.StringOf("Endpoint.MongoDbSettings.AuthType")
Dim MongoDbSettingsDatabaseName As String = jResp.StringOf("Endpoint.MongoDbSettings.DatabaseName")
Dim MongoDbSettingsDocsToInvestigate As String = jResp.StringOf("Endpoint.MongoDbSettings.DocsToInvestigate")
Dim MongoDbSettingsExtractDocId As String = jResp.StringOf("Endpoint.MongoDbSettings.ExtractDocId")
Dim MongoDbSettingsKmsKeyId As String = jResp.StringOf("Endpoint.MongoDbSettings.KmsKeyId")
Dim MongoDbSettingsNestingLevel As String = jResp.StringOf("Endpoint.MongoDbSettings.NestingLevel")
Dim MongoDbSettingsPassword As String = jResp.StringOf("Endpoint.MongoDbSettings.Password")
Dim MongoDbSettingsPort As Integer = jResp.IntOf("Endpoint.MongoDbSettings.Port")
Dim MongoDbSettingsSecretsManagerAccessRoleArn As String = jResp.StringOf("Endpoint.MongoDbSettings.SecretsManagerAccessRoleArn")
Dim MongoDbSettingsSecretsManagerSecretId As String = jResp.StringOf("Endpoint.MongoDbSettings.SecretsManagerSecretId")
Dim MongoDbSettingsServerName As String = jResp.StringOf("Endpoint.MongoDbSettings.ServerName")
Dim MongoDbSettingsUsername As String = jResp.StringOf("Endpoint.MongoDbSettings.Username")
Dim MySQLSettingsAfterConnectScript As String = jResp.StringOf("Endpoint.MySQLSettings.AfterConnectScript")
Dim MySQLSettingsCleanSourceMetadataOnMismatch As Integer = jResp.IntOf("Endpoint.MySQLSettings.CleanSourceMetadataOnMismatch")
Dim MySQLSettingsDatabaseName As String = jResp.StringOf("Endpoint.MySQLSettings.DatabaseName")
Dim MySQLSettingsEventsPollInterval As Integer = jResp.IntOf("Endpoint.MySQLSettings.EventsPollInterval")
Dim MySQLSettingsMaxFileSize As Integer = jResp.IntOf("Endpoint.MySQLSettings.MaxFileSize")
Dim MySQLSettingsParallelLoadThreads As Integer = jResp.IntOf("Endpoint.MySQLSettings.ParallelLoadThreads")
Dim MySQLSettingsPassword As String = jResp.StringOf("Endpoint.MySQLSettings.Password")
Dim MySQLSettingsPort As Integer = jResp.IntOf("Endpoint.MySQLSettings.Port")
Dim MySQLSettingsSecretsManagerAccessRoleArn As String = jResp.StringOf("Endpoint.MySQLSettings.SecretsManagerAccessRoleArn")
Dim MySQLSettingsSecretsManagerSecretId As String = jResp.StringOf("Endpoint.MySQLSettings.SecretsManagerSecretId")
Dim MySQLSettingsServerName As String = jResp.StringOf("Endpoint.MySQLSettings.ServerName")
Dim MySQLSettingsServerTimezone As String = jResp.StringOf("Endpoint.MySQLSettings.ServerTimezone")
Dim MySQLSettingsTargetDbType As String = jResp.StringOf("Endpoint.MySQLSettings.TargetDbType")
Dim MySQLSettingsUsername As String = jResp.StringOf("Endpoint.MySQLSettings.Username")
Dim NeptuneSettingsErrorRetryDuration As Integer = jResp.IntOf("Endpoint.NeptuneSettings.ErrorRetryDuration")
Dim IamAuthEnabled As Integer = jResp.IntOf("Endpoint.NeptuneSettings.IamAuthEnabled")
Dim NeptuneSettingsMaxFileSize As Integer = jResp.IntOf("Endpoint.NeptuneSettings.MaxFileSize")
Dim MaxRetryCount As Integer = jResp.IntOf("Endpoint.NeptuneSettings.MaxRetryCount")
Dim S3BucketFolder As String = jResp.StringOf("Endpoint.NeptuneSettings.S3BucketFolder")
Dim S3BucketName As String = jResp.StringOf("Endpoint.NeptuneSettings.S3BucketName")
Dim NeptuneSettingsServiceAccessRoleArn As String = jResp.StringOf("Endpoint.NeptuneSettings.ServiceAccessRoleArn")
Dim AccessAlternateDirectly As Integer = jResp.IntOf("Endpoint.OracleSettings.AccessAlternateDirectly")
Dim AdditionalArchivedLogDestId As Integer = jResp.IntOf("Endpoint.OracleSettings.AdditionalArchivedLogDestId")
Dim AddSupplementalLogging As Integer = jResp.IntOf("Endpoint.OracleSettings.AddSupplementalLogging")
Dim AllowSelectNestedTables As Integer = jResp.IntOf("Endpoint.OracleSettings.AllowSelectNestedTables")
Dim ArchivedLogDestId As Integer = jResp.IntOf("Endpoint.OracleSettings.ArchivedLogDestId")
Dim ArchivedLogsOnly As Integer = jResp.IntOf("Endpoint.OracleSettings.ArchivedLogsOnly")
Dim AsmPassword As String = jResp.StringOf("Endpoint.OracleSettings.AsmPassword")
Dim AsmServer As String = jResp.StringOf("Endpoint.OracleSettings.AsmServer")
Dim AsmUser As String = jResp.StringOf("Endpoint.OracleSettings.AsmUser")
Dim CharLengthSemantics As String = jResp.StringOf("Endpoint.OracleSettings.CharLengthSemantics")
Dim OracleSettingsDatabaseName As String = jResp.StringOf("Endpoint.OracleSettings.DatabaseName")
Dim DirectPathNoLog As Integer = jResp.IntOf("Endpoint.OracleSettings.DirectPathNoLog")
Dim DirectPathParallelLoad As Integer = jResp.IntOf("Endpoint.OracleSettings.DirectPathParallelLoad")
Dim EnableHomogenousTablespace As Integer = jResp.IntOf("Endpoint.OracleSettings.EnableHomogenousTablespace")
Dim FailTasksOnLobTruncation As Integer = jResp.IntOf("Endpoint.OracleSettings.FailTasksOnLobTruncation")
Dim NumberDatatypeScale As Integer = jResp.IntOf("Endpoint.OracleSettings.NumberDatatypeScale")
Dim OraclePathPrefix As String = jResp.StringOf("Endpoint.OracleSettings.OraclePathPrefix")
Dim ParallelAsmReadThreads As Integer = jResp.IntOf("Endpoint.OracleSettings.ParallelAsmReadThreads")
Dim OracleSettingsPassword As String = jResp.StringOf("Endpoint.OracleSettings.Password")
Dim OracleSettingsPort As Integer = jResp.IntOf("Endpoint.OracleSettings.Port")
Dim ReadAheadBlocks As Integer = jResp.IntOf("Endpoint.OracleSettings.ReadAheadBlocks")
Dim ReadTableSpaceName As Integer = jResp.IntOf("Endpoint.OracleSettings.ReadTableSpaceName")
Dim ReplacePathPrefix As Integer = jResp.IntOf("Endpoint.OracleSettings.ReplacePathPrefix")
Dim RetryInterval As Integer = jResp.IntOf("Endpoint.OracleSettings.RetryInterval")
Dim OracleSettingsSecretsManagerAccessRoleArn As String = jResp.StringOf("Endpoint.OracleSettings.SecretsManagerAccessRoleArn")
Dim SecretsManagerOracleAsmAccessRoleArn As String = jResp.StringOf("Endpoint.OracleSettings.SecretsManagerOracleAsmAccessRoleArn")
Dim SecretsManagerOracleAsmSecretId As String = jResp.StringOf("Endpoint.OracleSettings.SecretsManagerOracleAsmSecretId")
Dim OracleSettingsSecretsManagerSecretId As String = jResp.StringOf("Endpoint.OracleSettings.SecretsManagerSecretId")
Dim SecurityDbEncryption As String = jResp.StringOf("Endpoint.OracleSettings.SecurityDbEncryption")
Dim SecurityDbEncryptionName As String = jResp.StringOf("Endpoint.OracleSettings.SecurityDbEncryptionName")
Dim OracleSettingsServerName As String = jResp.StringOf("Endpoint.OracleSettings.ServerName")
Dim SpatialDataOptionToGeoJsonFunctionName As String = jResp.StringOf("Endpoint.OracleSettings.SpatialDataOptionToGeoJsonFunctionName")
Dim StandbyDelayTime As Integer = jResp.IntOf("Endpoint.OracleSettings.StandbyDelayTime")
Dim UseAlternateFolderForOnline As Integer = jResp.IntOf("Endpoint.OracleSettings.UseAlternateFolderForOnline")
Dim UseBFile As Integer = jResp.IntOf("Endpoint.OracleSettings.UseBFile")
Dim UseDirectPathFullLoad As Integer = jResp.IntOf("Endpoint.OracleSettings.UseDirectPathFullLoad")
Dim UseLogminerReader As Integer = jResp.IntOf("Endpoint.OracleSettings.UseLogminerReader")
Dim UsePathPrefix As String = jResp.StringOf("Endpoint.OracleSettings.UsePathPrefix")
Dim OracleSettingsUsername As String = jResp.StringOf("Endpoint.OracleSettings.Username")
Dim EndpointPort As Integer = jResp.IntOf("Endpoint.Port")
Dim PostgreSQLSettingsAfterConnectScript As String = jResp.StringOf("Endpoint.PostgreSQLSettings.AfterConnectScript")
Dim CaptureDdls As Integer = jResp.IntOf("Endpoint.PostgreSQLSettings.CaptureDdls")
Dim PostgreSQLSettingsDatabaseName As String = jResp.StringOf("Endpoint.PostgreSQLSettings.DatabaseName")
Dim DdlArtifactsSchema As String = jResp.StringOf("Endpoint.PostgreSQLSettings.DdlArtifactsSchema")
Dim ExecuteTimeout As Integer = jResp.IntOf("Endpoint.PostgreSQLSettings.ExecuteTimeout")
Dim PostgreSQLSettingsFailTasksOnLobTruncation As Integer = jResp.IntOf("Endpoint.PostgreSQLSettings.FailTasksOnLobTruncation")
Dim HeartbeatEnable As Integer = jResp.IntOf("Endpoint.PostgreSQLSettings.HeartbeatEnable")
Dim HeartbeatFrequency As Integer = jResp.IntOf("Endpoint.PostgreSQLSettings.HeartbeatFrequency")
Dim HeartbeatSchema As String = jResp.StringOf("Endpoint.PostgreSQLSettings.HeartbeatSchema")
Dim PostgreSQLSettingsMaxFileSize As Integer = jResp.IntOf("Endpoint.PostgreSQLSettings.MaxFileSize")
Dim PostgreSQLSettingsPassword As String = jResp.StringOf("Endpoint.PostgreSQLSettings.Password")
Dim PluginName As String = jResp.StringOf("Endpoint.PostgreSQLSettings.PluginName")
Dim PostgreSQLSettingsPort As Integer = jResp.IntOf("Endpoint.PostgreSQLSettings.Port")
Dim PostgreSQLSettingsSecretsManagerAccessRoleArn As String = jResp.StringOf("Endpoint.PostgreSQLSettings.SecretsManagerAccessRoleArn")
Dim PostgreSQLSettingsSecretsManagerSecretId As String = jResp.StringOf("Endpoint.PostgreSQLSettings.SecretsManagerSecretId")
Dim PostgreSQLSettingsServerName As String = jResp.StringOf("Endpoint.PostgreSQLSettings.ServerName")
Dim SlotName As String = jResp.StringOf("Endpoint.PostgreSQLSettings.SlotName")
Dim PostgreSQLSettingsUsername As String = jResp.StringOf("Endpoint.PostgreSQLSettings.Username")
Dim AuthPassword As String = jResp.StringOf("Endpoint.RedisSettings.AuthPassword")
Dim RedisSettingsAuthType As String = jResp.StringOf("Endpoint.RedisSettings.AuthType")
Dim AuthUserName As String = jResp.StringOf("Endpoint.RedisSettings.AuthUserName")
Dim RedisSettingsPort As Integer = jResp.IntOf("Endpoint.RedisSettings.Port")
Dim RedisSettingsServerName As String = jResp.StringOf("Endpoint.RedisSettings.ServerName")
Dim RedisSettingsSslCaCertificateArn As String = jResp.StringOf("Endpoint.RedisSettings.SslCaCertificateArn")
Dim SslSecurityProtocol As String = jResp.StringOf("Endpoint.RedisSettings.SslSecurityProtocol")
Dim AcceptAnyDate As Integer = jResp.IntOf("Endpoint.RedshiftSettings.AcceptAnyDate")
Dim RedshiftSettingsAfterConnectScript As String = jResp.StringOf("Endpoint.RedshiftSettings.AfterConnectScript")
Dim BucketFolder As String = jResp.StringOf("Endpoint.RedshiftSettings.BucketFolder")
Dim RedshiftSettingsBucketName As String = jResp.StringOf("Endpoint.RedshiftSettings.BucketName")
Dim CaseSensitiveNames As Integer = jResp.IntOf("Endpoint.RedshiftSettings.CaseSensitiveNames")
Dim CompUpdate As Integer = jResp.IntOf("Endpoint.RedshiftSettings.CompUpdate")
Dim ConnectionTimeout As Integer = jResp.IntOf("Endpoint.RedshiftSettings.ConnectionTimeout")
Dim RedshiftSettingsDatabaseName As String = jResp.StringOf("Endpoint.RedshiftSettings.DatabaseName")
Dim DateFormat As String = jResp.StringOf("Endpoint.RedshiftSettings.DateFormat")
Dim EmptyAsNull As Integer = jResp.IntOf("Endpoint.RedshiftSettings.EmptyAsNull")
Dim EncryptionMode As String = jResp.StringOf("Endpoint.RedshiftSettings.EncryptionMode")
Dim ExplicitIds As Integer = jResp.IntOf("Endpoint.RedshiftSettings.ExplicitIds")
Dim FileTransferUploadStreams As Integer = jResp.IntOf("Endpoint.RedshiftSettings.FileTransferUploadStreams")
Dim LoadTimeout As Integer = jResp.IntOf("Endpoint.RedshiftSettings.LoadTimeout")
Dim RedshiftSettingsMaxFileSize As Integer = jResp.IntOf("Endpoint.RedshiftSettings.MaxFileSize")
Dim RedshiftSettingsPassword As String = jResp.StringOf("Endpoint.RedshiftSettings.Password")
Dim RedshiftSettingsPort As Integer = jResp.IntOf("Endpoint.RedshiftSettings.Port")
Dim RemoveQuotes As Integer = jResp.IntOf("Endpoint.RedshiftSettings.RemoveQuotes")
Dim ReplaceChars As String = jResp.StringOf("Endpoint.RedshiftSettings.ReplaceChars")
Dim ReplaceInvalidChars As String = jResp.StringOf("Endpoint.RedshiftSettings.ReplaceInvalidChars")
Dim RedshiftSettingsSecretsManagerAccessRoleArn As String = jResp.StringOf("Endpoint.RedshiftSettings.SecretsManagerAccessRoleArn")
Dim RedshiftSettingsSecretsManagerSecretId As String = jResp.StringOf("Endpoint.RedshiftSettings.SecretsManagerSecretId")
Dim RedshiftSettingsServerName As String = jResp.StringOf("Endpoint.RedshiftSettings.ServerName")
Dim ServerSideEncryptionKmsKeyId As String = jResp.StringOf("Endpoint.RedshiftSettings.ServerSideEncryptionKmsKeyId")
Dim RedshiftSettingsServiceAccessRoleArn As String = jResp.StringOf("Endpoint.RedshiftSettings.ServiceAccessRoleArn")
Dim TimeFormat As String = jResp.StringOf("Endpoint.RedshiftSettings.TimeFormat")
Dim TrimBlanks As Integer = jResp.IntOf("Endpoint.RedshiftSettings.TrimBlanks")
Dim TruncateColumns As Integer = jResp.IntOf("Endpoint.RedshiftSettings.TruncateColumns")
Dim RedshiftSettingsUsername As String = jResp.StringOf("Endpoint.RedshiftSettings.Username")
Dim WriteBufferSize As Integer = jResp.IntOf("Endpoint.RedshiftSettings.WriteBufferSize")
Dim AddColumnName As Integer = jResp.IntOf("Endpoint.S3Settings.AddColumnName")
Dim S3SettingsBucketFolder As String = jResp.StringOf("Endpoint.S3Settings.BucketFolder")
Dim S3SettingsBucketName As String = jResp.StringOf("Endpoint.S3Settings.BucketName")
Dim CannedAclForObjects As String = jResp.StringOf("Endpoint.S3Settings.CannedAclForObjects")
Dim CdcInsertsAndUpdates As Integer = jResp.IntOf("Endpoint.S3Settings.CdcInsertsAndUpdates")
Dim CdcInsertsOnly As Integer = jResp.IntOf("Endpoint.S3Settings.CdcInsertsOnly")
Dim CdcMaxBatchInterval As Integer = jResp.IntOf("Endpoint.S3Settings.CdcMaxBatchInterval")
Dim CdcMinFileSize As Integer = jResp.IntOf("Endpoint.S3Settings.CdcMinFileSize")
Dim CdcPath As String = jResp.StringOf("Endpoint.S3Settings.CdcPath")
Dim CompressionType As String = jResp.StringOf("Endpoint.S3Settings.CompressionType")
Dim CsvDelimiter As String = jResp.StringOf("Endpoint.S3Settings.CsvDelimiter")
Dim CsvNoSupValue As String = jResp.StringOf("Endpoint.S3Settings.CsvNoSupValue")
Dim CsvNullValue As String = jResp.StringOf("Endpoint.S3Settings.CsvNullValue")
Dim CsvRowDelimiter As String = jResp.StringOf("Endpoint.S3Settings.CsvRowDelimiter")
Dim DataFormat As String = jResp.StringOf("Endpoint.S3Settings.DataFormat")
Dim DataPageSize As Integer = jResp.IntOf("Endpoint.S3Settings.DataPageSize")
Dim DatePartitionDelimiter As String = jResp.StringOf("Endpoint.S3Settings.DatePartitionDelimiter")
Dim DatePartitionEnabled As Integer = jResp.IntOf("Endpoint.S3Settings.DatePartitionEnabled")
Dim DatePartitionSequence As String = jResp.StringOf("Endpoint.S3Settings.DatePartitionSequence")
Dim DatePartitionTimezone As String = jResp.StringOf("Endpoint.S3Settings.DatePartitionTimezone")
Dim DictPageSizeLimit As Integer = jResp.IntOf("Endpoint.S3Settings.DictPageSizeLimit")
Dim EnableStatistics As Integer = jResp.IntOf("Endpoint.S3Settings.EnableStatistics")
Dim EncodingType As String = jResp.StringOf("Endpoint.S3Settings.EncodingType")
Dim S3SettingsEncryptionMode As String = jResp.StringOf("Endpoint.S3Settings.EncryptionMode")
Dim S3SettingsExternalTableDefinition As String = jResp.StringOf("Endpoint.S3Settings.ExternalTableDefinition")
Dim IgnoreHeaderRows As Integer = jResp.IntOf("Endpoint.S3Settings.IgnoreHeaderRows")
Dim IncludeOpForFullLoad As Integer = jResp.IntOf("Endpoint.S3Settings.IncludeOpForFullLoad")
Dim S3SettingsMaxFileSize As Integer = jResp.IntOf("Endpoint.S3Settings.MaxFileSize")
Dim ParquetTimestampInMillisecond As Integer = jResp.IntOf("Endpoint.S3Settings.ParquetTimestampInMillisecond")
Dim ParquetVersion As String = jResp.StringOf("Endpoint.S3Settings.ParquetVersion")
Dim PreserveTransactions As Integer = jResp.IntOf("Endpoint.S3Settings.PreserveTransactions")
Dim Rfc4180 As Integer = jResp.IntOf("Endpoint.S3Settings.Rfc4180")
Dim RowGroupLength As Integer = jResp.IntOf("Endpoint.S3Settings.RowGroupLength")
Dim S3SettingsServerSideEncryptionKmsKeyId As String = jResp.StringOf("Endpoint.S3Settings.ServerSideEncryptionKmsKeyId")
Dim S3SettingsServiceAccessRoleArn As String = jResp.StringOf("Endpoint.S3Settings.ServiceAccessRoleArn")
Dim TimestampColumnName As String = jResp.StringOf("Endpoint.S3Settings.TimestampColumnName")
Dim UseCsvNoSupValue As Integer = jResp.IntOf("Endpoint.S3Settings.UseCsvNoSupValue")
Dim UseTaskStartTimeForFullLoadTimestamp As Integer = jResp.IntOf("Endpoint.S3Settings.UseTaskStartTimeForFullLoadTimestamp")
Dim EndpointServerName As String = jResp.StringOf("Endpoint.ServerName")
Dim EndpointServiceAccessRoleArn As String = jResp.StringOf("Endpoint.ServiceAccessRoleArn")
Dim SslMode As String = jResp.StringOf("Endpoint.SslMode")
Dim Status As String = jResp.StringOf("Endpoint.Status")
Dim SybaseSettingsDatabaseName As String = jResp.StringOf("Endpoint.SybaseSettings.DatabaseName")
Dim SybaseSettingsPassword As String = jResp.StringOf("Endpoint.SybaseSettings.Password")
Dim SybaseSettingsPort As Integer = jResp.IntOf("Endpoint.SybaseSettings.Port")
Dim SybaseSettingsSecretsManagerAccessRoleArn As String = jResp.StringOf("Endpoint.SybaseSettings.SecretsManagerAccessRoleArn")
Dim SybaseSettingsSecretsManagerSecretId As String = jResp.StringOf("Endpoint.SybaseSettings.SecretsManagerSecretId")
Dim SybaseSettingsServerName As String = jResp.StringOf("Endpoint.SybaseSettings.ServerName")
Dim SybaseSettingsUsername As String = jResp.StringOf("Endpoint.SybaseSettings.Username")
Dim EndpointUsername As String = jResp.StringOf("Endpoint.Username")
Dim i As Integer = 0
Dim count_i As Integer = jResp.SizeOfArray("Endpoint.OracleSettings.ExtraArchivedLogDestIds")
While i < count_i
jResp.I = i
intVal = jResp.IntOf("Endpoint.OracleSettings.ExtraArchivedLogDestIds[i]")
i = i + 1
End While
' 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"
' }
' }
