CreateEndpoint PowerBuilder Example
integer li_rc
oleobject loo_Rest
integer li_Success
oleobject loo_AuthAws
oleobject loo_Json
oleobject loo_SbRequestBody
oleobject loo_SbResponseBody
integer li_RespStatusCode
oleobject loo_JResp
integer li_IntVal
string ls_CertificateArn
string ls_DatabaseName
string ls_BucketName
string ls_ServiceAccessRoleArn
string ls_DocDbSettingsDatabaseName
integer li_DocsToInvestigate
integer li_ExtractDocId
string ls_KmsKeyId
string ls_NestingLevel
string ls_Password
integer li_Port
string ls_SecretsManagerAccessRoleArn
string ls_SecretsManagerSecretId
string ls_ServerName
string ls_Username
string ls_DynamoDbSettingsServiceAccessRoleArn
string ls_EndpointUri
integer li_ErrorRetryDuration
integer li_FullLoadErrorPercentage
string ls_ElasticsearchSettingsServiceAccessRoleArn
string ls_EndpointArn
string ls_EndpointIdentifier
string ls_EndpointType
string ls_EngineDisplayName
string ls_EngineName
string ls_ExternalId
string ls_ExternalTableDefinition
string ls_ExtraConnectionAttributes
string ls_AfterConnectScript
integer li_CleanSourceMetadataOnMismatch
string ls_GcpMySQLSettingsDatabaseName
integer li_EventsPollInterval
integer li_MaxFileSize
integer li_ParallelLoadThreads
string ls_GcpMySQLSettingsPassword
integer li_GcpMySQLSettingsPort
string ls_GcpMySQLSettingsSecretsManagerAccessRoleArn
string ls_GcpMySQLSettingsSecretsManagerSecretId
string ls_GcpMySQLSettingsServerName
string ls_ServerTimezone
string ls_TargetDbType
string ls_GcpMySQLSettingsUsername
string ls_CurrentLsn
string ls_IBMDb2SettingsDatabaseName
integer li_MaxKBytesPerRead
string ls_IBMDb2SettingsPassword
integer li_IBMDb2SettingsPort
string ls_IBMDb2SettingsSecretsManagerAccessRoleArn
string ls_IBMDb2SettingsSecretsManagerSecretId
string ls_IBMDb2SettingsServerName
integer li_SetDataCaptureChanges
string ls_IBMDb2SettingsUsername
string ls_Broker
integer li_IncludeControlDetails
integer li_IncludeNullAndEmpty
integer li_IncludePartitionValue
integer li_IncludeTableAlterOperations
integer li_IncludeTransactionDetails
string ls_MessageFormat
integer li_MessageMaxBytes
integer li_NoHexPrefix
integer li_PartitionIncludeSchemaTable
string ls_SaslPassword
string ls_SaslUsername
string ls_SecurityProtocol
string ls_SslCaCertificateArn
string ls_SslClientCertificateArn
string ls_SslClientKeyArn
string ls_SslClientKeyPassword
string ls_Topic
integer li_KinesisSettingsIncludeControlDetails
integer li_KinesisSettingsIncludeNullAndEmpty
integer li_KinesisSettingsIncludePartitionValue
integer li_KinesisSettingsIncludeTableAlterOperations
integer li_KinesisSettingsIncludeTransactionDetails
string ls_KinesisSettingsMessageFormat
integer li_KinesisSettingsNoHexPrefix
integer li_KinesisSettingsPartitionIncludeSchemaTable
string ls_KinesisSettingsServiceAccessRoleArn
string ls_StreamArn
string ls_EndpointKmsKeyId
integer li_BcpPacketSize
string ls_ControlTablesFileGroup
string ls_MicrosoftSQLServerSettingsDatabaseName
string ls_MicrosoftSQLServerSettingsPassword
integer li_MicrosoftSQLServerSettingsPort
integer li_QuerySingleAlwaysOnNode
integer li_ReadBackupOnly
string ls_SafeguardPolicy
string ls_MicrosoftSQLServerSettingsSecretsManagerAccessRoleArn
string ls_MicrosoftSQLServerSettingsSecretsManagerSecretId
string ls_MicrosoftSQLServerSettingsServerName
integer li_UseBcpFullLoad
string ls_MicrosoftSQLServerSettingsUsername
integer li_UseThirdPartyBackupDevice
string ls_AuthMechanism
string ls_AuthSource
string ls_AuthType
string ls_MongoDbSettingsDatabaseName
string ls_MongoDbSettingsDocsToInvestigate
string ls_MongoDbSettingsExtractDocId
string ls_MongoDbSettingsKmsKeyId
string ls_MongoDbSettingsNestingLevel
string ls_MongoDbSettingsPassword
integer li_MongoDbSettingsPort
string ls_MongoDbSettingsSecretsManagerAccessRoleArn
string ls_MongoDbSettingsSecretsManagerSecretId
string ls_MongoDbSettingsServerName
string ls_MongoDbSettingsUsername
string ls_MySQLSettingsAfterConnectScript
integer li_MySQLSettingsCleanSourceMetadataOnMismatch
string ls_MySQLSettingsDatabaseName
integer li_MySQLSettingsEventsPollInterval
integer li_MySQLSettingsMaxFileSize
integer li_MySQLSettingsParallelLoadThreads
string ls_MySQLSettingsPassword
integer li_MySQLSettingsPort
string ls_MySQLSettingsSecretsManagerAccessRoleArn
string ls_MySQLSettingsSecretsManagerSecretId
string ls_MySQLSettingsServerName
string ls_MySQLSettingsServerTimezone
string ls_MySQLSettingsTargetDbType
string ls_MySQLSettingsUsername
integer li_NeptuneSettingsErrorRetryDuration
integer li_IamAuthEnabled
integer li_NeptuneSettingsMaxFileSize
integer li_MaxRetryCount
string ls_S3BucketFolder
string ls_S3BucketName
string ls_NeptuneSettingsServiceAccessRoleArn
integer li_AccessAlternateDirectly
integer li_AdditionalArchivedLogDestId
integer li_AddSupplementalLogging
integer li_AllowSelectNestedTables
integer li_ArchivedLogDestId
integer li_ArchivedLogsOnly
string ls_AsmPassword
string ls_AsmServer
string ls_AsmUser
string ls_CharLengthSemantics
string ls_OracleSettingsDatabaseName
integer li_DirectPathNoLog
integer li_DirectPathParallelLoad
integer li_EnableHomogenousTablespace
integer li_FailTasksOnLobTruncation
integer li_NumberDatatypeScale
string ls_OraclePathPrefix
integer li_ParallelAsmReadThreads
string ls_OracleSettingsPassword
integer li_OracleSettingsPort
integer li_ReadAheadBlocks
integer li_ReadTableSpaceName
integer li_ReplacePathPrefix
integer li_RetryInterval
string ls_OracleSettingsSecretsManagerAccessRoleArn
string ls_SecretsManagerOracleAsmAccessRoleArn
string ls_SecretsManagerOracleAsmSecretId
string ls_OracleSettingsSecretsManagerSecretId
string ls_SecurityDbEncryption
string ls_SecurityDbEncryptionName
string ls_OracleSettingsServerName
string ls_SpatialDataOptionToGeoJsonFunctionName
integer li_StandbyDelayTime
integer li_UseAlternateFolderForOnline
integer li_UseBFile
integer li_UseDirectPathFullLoad
integer li_UseLogminerReader
string ls_UsePathPrefix
string ls_OracleSettingsUsername
integer li_EndpointPort
string ls_PostgreSQLSettingsAfterConnectScript
integer li_CaptureDdls
string ls_PostgreSQLSettingsDatabaseName
string ls_DdlArtifactsSchema
integer li_ExecuteTimeout
integer li_PostgreSQLSettingsFailTasksOnLobTruncation
integer li_HeartbeatEnable
integer li_HeartbeatFrequency
string ls_HeartbeatSchema
integer li_PostgreSQLSettingsMaxFileSize
string ls_PostgreSQLSettingsPassword
string ls_PluginName
integer li_PostgreSQLSettingsPort
string ls_PostgreSQLSettingsSecretsManagerAccessRoleArn
string ls_PostgreSQLSettingsSecretsManagerSecretId
string ls_PostgreSQLSettingsServerName
string ls_SlotName
string ls_PostgreSQLSettingsUsername
string ls_AuthPassword
string ls_RedisSettingsAuthType
string ls_AuthUserName
integer li_RedisSettingsPort
string ls_RedisSettingsServerName
string ls_RedisSettingsSslCaCertificateArn
string ls_SslSecurityProtocol
integer li_AcceptAnyDate
string ls_RedshiftSettingsAfterConnectScript
string ls_BucketFolder
string ls_RedshiftSettingsBucketName
integer li_CaseSensitiveNames
integer li_CompUpdate
integer li_ConnectionTimeout
string ls_RedshiftSettingsDatabaseName
string ls_DateFormat
integer li_EmptyAsNull
string ls_EncryptionMode
integer li_ExplicitIds
integer li_FileTransferUploadStreams
integer li_LoadTimeout
integer li_RedshiftSettingsMaxFileSize
string ls_RedshiftSettingsPassword
integer li_RedshiftSettingsPort
integer li_RemoveQuotes
string ls_ReplaceChars
string ls_ReplaceInvalidChars
string ls_RedshiftSettingsSecretsManagerAccessRoleArn
string ls_RedshiftSettingsSecretsManagerSecretId
string ls_RedshiftSettingsServerName
string ls_ServerSideEncryptionKmsKeyId
string ls_RedshiftSettingsServiceAccessRoleArn
string ls_TimeFormat
integer li_TrimBlanks
integer li_TruncateColumns
string ls_RedshiftSettingsUsername
integer li_WriteBufferSize
integer li_AddColumnName
string ls_S3SettingsBucketFolder
string ls_S3SettingsBucketName
string ls_CannedAclForObjects
integer li_CdcInsertsAndUpdates
integer li_CdcInsertsOnly
integer li_CdcMaxBatchInterval
integer li_CdcMinFileSize
string ls_CdcPath
string ls_CompressionType
string ls_CsvDelimiter
string ls_CsvNoSupValue
string ls_CsvNullValue
string ls_CsvRowDelimiter
string ls_DataFormat
integer li_DataPageSize
string ls_DatePartitionDelimiter
integer li_DatePartitionEnabled
string ls_DatePartitionSequence
string ls_DatePartitionTimezone
integer li_DictPageSizeLimit
integer li_EnableStatistics
string ls_EncodingType
string ls_S3SettingsEncryptionMode
string ls_S3SettingsExternalTableDefinition
integer li_IgnoreHeaderRows
integer li_IncludeOpForFullLoad
integer li_S3SettingsMaxFileSize
integer li_ParquetTimestampInMillisecond
string ls_ParquetVersion
integer li_PreserveTransactions
integer li_Rfc4180
integer li_RowGroupLength
string ls_S3SettingsServerSideEncryptionKmsKeyId
string ls_S3SettingsServiceAccessRoleArn
string ls_TimestampColumnName
integer li_UseCsvNoSupValue
integer li_UseTaskStartTimeForFullLoadTimestamp
string ls_EndpointServerName
string ls_EndpointServiceAccessRoleArn
string ls_SslMode
string ls_Status
string ls_SybaseSettingsDatabaseName
string ls_SybaseSettingsPassword
integer li_SybaseSettingsPort
string ls_SybaseSettingsSecretsManagerAccessRoleArn
string ls_SybaseSettingsSecretsManagerSecretId
string ls_SybaseSettingsServerName
string ls_SybaseSettingsUsername
string ls_EndpointUsername
integer i
integer li_Count_i
// This example requires the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
loo_Rest = create oleobject
li_rc = loo_Rest.ConnectToNewObject("Chilkat_9_5_0.Rest")
if li_rc < 0 then
destroy loo_Rest
MessageBox("Error","Connecting to COM object failed")
return
end if
loo_AuthAws = create oleobject
li_rc = loo_AuthAws.ConnectToNewObject("Chilkat_9_5_0.AuthAws")
loo_AuthAws.AccessKey = "AWS_ACCESS_KEY"
loo_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.)
loo_AuthAws.Region = "us-west-2"
loo_AuthAws.ServiceName = "dms"
// SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
loo_Rest.SetAuthAws(loo_AuthAws)
// URL: https://dms.us-west-2.amazonaws.com/
// Use the same region as specified above.
li_Success = loo_Rest.Connect("dms.us-west-2.amazonaws.com",443,1,1)
if li_Success <> 1 then
Write-Debug "ConnectFailReason: " + string(loo_Rest.ConnectFailReason)
Write-Debug loo_Rest.LastErrorText
destroy loo_Rest
destroy loo_AuthAws
return
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
loo_Json = create oleobject
li_rc = loo_Json.ConnectToNewObject("Chilkat_9_5_0.JsonObject")
loo_Json.UpdateString("CertificateArn","string")
loo_Json.UpdateString("DatabaseName","string")
loo_Json.UpdateString("DmsTransferSettings.BucketName","string")
loo_Json.UpdateString("DmsTransferSettings.ServiceAccessRoleArn","string")
loo_Json.UpdateString("DocDbSettings.DatabaseName","string")
loo_Json.UpdateInt("DocDbSettings.DocsToInvestigate",123)
loo_Json.UpdateInt("DocDbSettings.ExtractDocId",123)
loo_Json.UpdateString("DocDbSettings.KmsKeyId","string")
loo_Json.UpdateString("DocDbSettings.NestingLevel","string")
loo_Json.UpdateString("DocDbSettings.Password","string")
loo_Json.UpdateInt("DocDbSettings.Port",123)
loo_Json.UpdateString("DocDbSettings.SecretsManagerAccessRoleArn","string")
loo_Json.UpdateString("DocDbSettings.SecretsManagerSecretId","string")
loo_Json.UpdateString("DocDbSettings.ServerName","string")
loo_Json.UpdateString("DocDbSettings.Username","string")
loo_Json.UpdateString("DynamoDbSettings.ServiceAccessRoleArn","string")
loo_Json.UpdateString("ElasticsearchSettings.EndpointUri","string")
loo_Json.UpdateInt("ElasticsearchSettings.ErrorRetryDuration",123)
loo_Json.UpdateInt("ElasticsearchSettings.FullLoadErrorPercentage",123)
loo_Json.UpdateString("ElasticsearchSettings.ServiceAccessRoleArn","string")
loo_Json.UpdateString("EndpointIdentifier","string")
loo_Json.UpdateString("EndpointType","string")
loo_Json.UpdateString("EngineName","string")
loo_Json.UpdateString("ExternalTableDefinition","string")
loo_Json.UpdateString("ExtraConnectionAttributes","string")
loo_Json.UpdateString("GcpMySQLSettings.AfterConnectScript","string")
loo_Json.UpdateInt("GcpMySQLSettings.CleanSourceMetadataOnMismatch",123)
loo_Json.UpdateString("GcpMySQLSettings.DatabaseName","string")
loo_Json.UpdateInt("GcpMySQLSettings.EventsPollInterval",123)
loo_Json.UpdateInt("GcpMySQLSettings.MaxFileSize",123)
loo_Json.UpdateInt("GcpMySQLSettings.ParallelLoadThreads",123)
loo_Json.UpdateString("GcpMySQLSettings.Password","string")
loo_Json.UpdateInt("GcpMySQLSettings.Port",123)
loo_Json.UpdateString("GcpMySQLSettings.SecretsManagerAccessRoleArn","string")
loo_Json.UpdateString("GcpMySQLSettings.SecretsManagerSecretId","string")
loo_Json.UpdateString("GcpMySQLSettings.ServerName","string")
loo_Json.UpdateString("GcpMySQLSettings.ServerTimezone","string")
loo_Json.UpdateString("GcpMySQLSettings.TargetDbType","string")
loo_Json.UpdateString("GcpMySQLSettings.Username","string")
loo_Json.UpdateString("IBMDb2Settings.CurrentLsn","string")
loo_Json.UpdateString("IBMDb2Settings.DatabaseName","string")
loo_Json.UpdateInt("IBMDb2Settings.MaxKBytesPerRead",123)
loo_Json.UpdateString("IBMDb2Settings.Password","string")
loo_Json.UpdateInt("IBMDb2Settings.Port",123)
loo_Json.UpdateString("IBMDb2Settings.SecretsManagerAccessRoleArn","string")
loo_Json.UpdateString("IBMDb2Settings.SecretsManagerSecretId","string")
loo_Json.UpdateString("IBMDb2Settings.ServerName","string")
loo_Json.UpdateInt("IBMDb2Settings.SetDataCaptureChanges",123)
loo_Json.UpdateString("IBMDb2Settings.Username","string")
loo_Json.UpdateString("KafkaSettings.Broker","string")
loo_Json.UpdateInt("KafkaSettings.IncludeControlDetails",123)
loo_Json.UpdateInt("KafkaSettings.IncludeNullAndEmpty",123)
loo_Json.UpdateInt("KafkaSettings.IncludePartitionValue",123)
loo_Json.UpdateInt("KafkaSettings.IncludeTableAlterOperations",123)
loo_Json.UpdateInt("KafkaSettings.IncludeTransactionDetails",123)
loo_Json.UpdateString("KafkaSettings.MessageFormat","string")
loo_Json.UpdateInt("KafkaSettings.MessageMaxBytes",123)
loo_Json.UpdateInt("KafkaSettings.NoHexPrefix",123)
loo_Json.UpdateInt("KafkaSettings.PartitionIncludeSchemaTable",123)
loo_Json.UpdateString("KafkaSettings.SaslPassword","string")
loo_Json.UpdateString("KafkaSettings.SaslUsername","string")
loo_Json.UpdateString("KafkaSettings.SecurityProtocol","string")
loo_Json.UpdateString("KafkaSettings.SslCaCertificateArn","string")
loo_Json.UpdateString("KafkaSettings.SslClientCertificateArn","string")
loo_Json.UpdateString("KafkaSettings.SslClientKeyArn","string")
loo_Json.UpdateString("KafkaSettings.SslClientKeyPassword","string")
loo_Json.UpdateString("KafkaSettings.Topic","string")
loo_Json.UpdateInt("KinesisSettings.IncludeControlDetails",123)
loo_Json.UpdateInt("KinesisSettings.IncludeNullAndEmpty",123)
loo_Json.UpdateInt("KinesisSettings.IncludePartitionValue",123)
loo_Json.UpdateInt("KinesisSettings.IncludeTableAlterOperations",123)
loo_Json.UpdateInt("KinesisSettings.IncludeTransactionDetails",123)
loo_Json.UpdateString("KinesisSettings.MessageFormat","string")
loo_Json.UpdateInt("KinesisSettings.NoHexPrefix",123)
loo_Json.UpdateInt("KinesisSettings.PartitionIncludeSchemaTable",123)
loo_Json.UpdateString("KinesisSettings.ServiceAccessRoleArn","string")
loo_Json.UpdateString("KinesisSettings.StreamArn","string")
loo_Json.UpdateString("KmsKeyId","string")
loo_Json.UpdateInt("MicrosoftSQLServerSettings.BcpPacketSize",123)
loo_Json.UpdateString("MicrosoftSQLServerSettings.ControlTablesFileGroup","string")
loo_Json.UpdateString("MicrosoftSQLServerSettings.DatabaseName","string")
loo_Json.UpdateString("MicrosoftSQLServerSettings.Password","string")
loo_Json.UpdateInt("MicrosoftSQLServerSettings.Port",123)
loo_Json.UpdateInt("MicrosoftSQLServerSettings.QuerySingleAlwaysOnNode",123)
loo_Json.UpdateInt("MicrosoftSQLServerSettings.ReadBackupOnly",123)
loo_Json.UpdateString("MicrosoftSQLServerSettings.SafeguardPolicy","string")
loo_Json.UpdateString("MicrosoftSQLServerSettings.SecretsManagerAccessRoleArn","string")
loo_Json.UpdateString("MicrosoftSQLServerSettings.SecretsManagerSecretId","string")
loo_Json.UpdateString("MicrosoftSQLServerSettings.ServerName","string")
loo_Json.UpdateInt("MicrosoftSQLServerSettings.UseBcpFullLoad",123)
loo_Json.UpdateString("MicrosoftSQLServerSettings.Username","string")
loo_Json.UpdateInt("MicrosoftSQLServerSettings.UseThirdPartyBackupDevice",123)
loo_Json.UpdateString("MongoDbSettings.AuthMechanism","string")
loo_Json.UpdateString("MongoDbSettings.AuthSource","string")
loo_Json.UpdateString("MongoDbSettings.AuthType","string")
loo_Json.UpdateString("MongoDbSettings.DatabaseName","string")
loo_Json.UpdateString("MongoDbSettings.DocsToInvestigate","string")
loo_Json.UpdateString("MongoDbSettings.ExtractDocId","string")
loo_Json.UpdateString("MongoDbSettings.KmsKeyId","string")
loo_Json.UpdateString("MongoDbSettings.NestingLevel","string")
loo_Json.UpdateString("MongoDbSettings.Password","string")
loo_Json.UpdateInt("MongoDbSettings.Port",123)
loo_Json.UpdateString("MongoDbSettings.SecretsManagerAccessRoleArn","string")
loo_Json.UpdateString("MongoDbSettings.SecretsManagerSecretId","string")
loo_Json.UpdateString("MongoDbSettings.ServerName","string")
loo_Json.UpdateString("MongoDbSettings.Username","string")
loo_Json.UpdateString("MySQLSettings.AfterConnectScript","string")
loo_Json.UpdateInt("MySQLSettings.CleanSourceMetadataOnMismatch",123)
loo_Json.UpdateString("MySQLSettings.DatabaseName","string")
loo_Json.UpdateInt("MySQLSettings.EventsPollInterval",123)
loo_Json.UpdateInt("MySQLSettings.MaxFileSize",123)
loo_Json.UpdateInt("MySQLSettings.ParallelLoadThreads",123)
loo_Json.UpdateString("MySQLSettings.Password","string")
loo_Json.UpdateInt("MySQLSettings.Port",123)
loo_Json.UpdateString("MySQLSettings.SecretsManagerAccessRoleArn","string")
loo_Json.UpdateString("MySQLSettings.SecretsManagerSecretId","string")
loo_Json.UpdateString("MySQLSettings.ServerName","string")
loo_Json.UpdateString("MySQLSettings.ServerTimezone","string")
loo_Json.UpdateString("MySQLSettings.TargetDbType","string")
loo_Json.UpdateString("MySQLSettings.Username","string")
loo_Json.UpdateInt("NeptuneSettings.ErrorRetryDuration",123)
loo_Json.UpdateInt("NeptuneSettings.IamAuthEnabled",123)
loo_Json.UpdateInt("NeptuneSettings.MaxFileSize",123)
loo_Json.UpdateInt("NeptuneSettings.MaxRetryCount",123)
loo_Json.UpdateString("NeptuneSettings.S3BucketFolder","string")
loo_Json.UpdateString("NeptuneSettings.S3BucketName","string")
loo_Json.UpdateString("NeptuneSettings.ServiceAccessRoleArn","string")
loo_Json.UpdateInt("OracleSettings.AccessAlternateDirectly",123)
loo_Json.UpdateInt("OracleSettings.AdditionalArchivedLogDestId",123)
loo_Json.UpdateInt("OracleSettings.AddSupplementalLogging",123)
loo_Json.UpdateInt("OracleSettings.AllowSelectNestedTables",123)
loo_Json.UpdateInt("OracleSettings.ArchivedLogDestId",123)
loo_Json.UpdateInt("OracleSettings.ArchivedLogsOnly",123)
loo_Json.UpdateString("OracleSettings.AsmPassword","string")
loo_Json.UpdateString("OracleSettings.AsmServer","string")
loo_Json.UpdateString("OracleSettings.AsmUser","string")
loo_Json.UpdateString("OracleSettings.CharLengthSemantics","string")
loo_Json.UpdateString("OracleSettings.DatabaseName","string")
loo_Json.UpdateInt("OracleSettings.DirectPathNoLog",123)
loo_Json.UpdateInt("OracleSettings.DirectPathParallelLoad",123)
loo_Json.UpdateInt("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)
loo_Json.UpdateInt("OracleSettings.ExtraArchivedLogDestIds[0]",ERROR: Undefined variable(number)
)ERROR: Undefined variable(number)
loo_Json.UpdateInt("OracleSettings.FailTasksOnLobTruncation",123)
loo_Json.UpdateInt("OracleSettings.NumberDatatypeScale",123)
loo_Json.UpdateString("OracleSettings.OraclePathPrefix","string")
loo_Json.UpdateInt("OracleSettings.ParallelAsmReadThreads",123)
loo_Json.UpdateString("OracleSettings.Password","string")
loo_Json.UpdateInt("OracleSettings.Port",123)
loo_Json.UpdateInt("OracleSettings.ReadAheadBlocks",123)
loo_Json.UpdateInt("OracleSettings.ReadTableSpaceName",123)
loo_Json.UpdateInt("OracleSettings.ReplacePathPrefix",123)
loo_Json.UpdateInt("OracleSettings.RetryInterval",123)
loo_Json.UpdateString("OracleSettings.SecretsManagerAccessRoleArn","string")
loo_Json.UpdateString("OracleSettings.SecretsManagerOracleAsmAccessRoleArn","string")
loo_Json.UpdateString("OracleSettings.SecretsManagerOracleAsmSecretId","string")
loo_Json.UpdateString("OracleSettings.SecretsManagerSecretId","string")
loo_Json.UpdateString("OracleSettings.SecurityDbEncryption","string")
loo_Json.UpdateString("OracleSettings.SecurityDbEncryptionName","string")
loo_Json.UpdateString("OracleSettings.ServerName","string")
loo_Json.UpdateString("OracleSettings.SpatialDataOptionToGeoJsonFunctionName","string")
loo_Json.UpdateInt("OracleSettings.StandbyDelayTime",123)
loo_Json.UpdateInt("OracleSettings.UseAlternateFolderForOnline",123)
loo_Json.UpdateInt("OracleSettings.UseBFile",123)
loo_Json.UpdateInt("OracleSettings.UseDirectPathFullLoad",123)
loo_Json.UpdateInt("OracleSettings.UseLogminerReader",123)
loo_Json.UpdateString("OracleSettings.UsePathPrefix","string")
loo_Json.UpdateString("OracleSettings.Username","string")
loo_Json.UpdateString("Password","string")
loo_Json.UpdateInt("Port",123)
loo_Json.UpdateString("PostgreSQLSettings.AfterConnectScript","string")
loo_Json.UpdateInt("PostgreSQLSettings.CaptureDdls",123)
loo_Json.UpdateString("PostgreSQLSettings.DatabaseName","string")
loo_Json.UpdateString("PostgreSQLSettings.DdlArtifactsSchema","string")
loo_Json.UpdateInt("PostgreSQLSettings.ExecuteTimeout",123)
loo_Json.UpdateInt("PostgreSQLSettings.FailTasksOnLobTruncation",123)
loo_Json.UpdateInt("PostgreSQLSettings.HeartbeatEnable",123)
loo_Json.UpdateInt("PostgreSQLSettings.HeartbeatFrequency",123)
loo_Json.UpdateString("PostgreSQLSettings.HeartbeatSchema","string")
loo_Json.UpdateInt("PostgreSQLSettings.MaxFileSize",123)
loo_Json.UpdateString("PostgreSQLSettings.Password","string")
loo_Json.UpdateString("PostgreSQLSettings.PluginName","string")
loo_Json.UpdateInt("PostgreSQLSettings.Port",123)
loo_Json.UpdateString("PostgreSQLSettings.SecretsManagerAccessRoleArn","string")
loo_Json.UpdateString("PostgreSQLSettings.SecretsManagerSecretId","string")
loo_Json.UpdateString("PostgreSQLSettings.ServerName","string")
loo_Json.UpdateString("PostgreSQLSettings.SlotName","string")
loo_Json.UpdateString("PostgreSQLSettings.Username","string")
loo_Json.UpdateString("RedisSettings.AuthPassword","string")
loo_Json.UpdateString("RedisSettings.AuthType","string")
loo_Json.UpdateString("RedisSettings.AuthUserName","string")
loo_Json.UpdateInt("RedisSettings.Port",123)
loo_Json.UpdateString("RedisSettings.ServerName","string")
loo_Json.UpdateString("RedisSettings.SslCaCertificateArn","string")
loo_Json.UpdateString("RedisSettings.SslSecurityProtocol","string")
loo_Json.UpdateInt("RedshiftSettings.AcceptAnyDate",123)
loo_Json.UpdateString("RedshiftSettings.AfterConnectScript","string")
loo_Json.UpdateString("RedshiftSettings.BucketFolder","string")
loo_Json.UpdateString("RedshiftSettings.BucketName","string")
loo_Json.UpdateInt("RedshiftSettings.CaseSensitiveNames",123)
loo_Json.UpdateInt("RedshiftSettings.CompUpdate",123)
loo_Json.UpdateInt("RedshiftSettings.ConnectionTimeout",123)
loo_Json.UpdateString("RedshiftSettings.DatabaseName","string")
loo_Json.UpdateString("RedshiftSettings.DateFormat","string")
loo_Json.UpdateInt("RedshiftSettings.EmptyAsNull",123)
loo_Json.UpdateString("RedshiftSettings.EncryptionMode","string")
loo_Json.UpdateInt("RedshiftSettings.ExplicitIds",123)
loo_Json.UpdateInt("RedshiftSettings.FileTransferUploadStreams",123)
loo_Json.UpdateInt("RedshiftSettings.LoadTimeout",123)
loo_Json.UpdateInt("RedshiftSettings.MaxFileSize",123)
loo_Json.UpdateString("RedshiftSettings.Password","string")
loo_Json.UpdateInt("RedshiftSettings.Port",123)
loo_Json.UpdateInt("RedshiftSettings.RemoveQuotes",123)
loo_Json.UpdateString("RedshiftSettings.ReplaceChars","string")
loo_Json.UpdateString("RedshiftSettings.ReplaceInvalidChars","string")
loo_Json.UpdateString("RedshiftSettings.SecretsManagerAccessRoleArn","string")
loo_Json.UpdateString("RedshiftSettings.SecretsManagerSecretId","string")
loo_Json.UpdateString("RedshiftSettings.ServerName","string")
loo_Json.UpdateString("RedshiftSettings.ServerSideEncryptionKmsKeyId","string")
loo_Json.UpdateString("RedshiftSettings.ServiceAccessRoleArn","string")
loo_Json.UpdateString("RedshiftSettings.TimeFormat","string")
loo_Json.UpdateInt("RedshiftSettings.TrimBlanks",123)
loo_Json.UpdateInt("RedshiftSettings.TruncateColumns",123)
loo_Json.UpdateString("RedshiftSettings.Username","string")
loo_Json.UpdateInt("RedshiftSettings.WriteBufferSize",123)
loo_Json.UpdateString("ResourceIdentifier","string")
loo_Json.UpdateInt("S3Settings.AddColumnName",123)
loo_Json.UpdateString("S3Settings.BucketFolder","string")
loo_Json.UpdateString("S3Settings.BucketName","string")
loo_Json.UpdateString("S3Settings.CannedAclForObjects","string")
loo_Json.UpdateInt("S3Settings.CdcInsertsAndUpdates",123)
loo_Json.UpdateInt("S3Settings.CdcInsertsOnly",123)
loo_Json.UpdateInt("S3Settings.CdcMaxBatchInterval",123)
loo_Json.UpdateInt("S3Settings.CdcMinFileSize",123)
loo_Json.UpdateString("S3Settings.CdcPath","string")
loo_Json.UpdateString("S3Settings.CompressionType","string")
loo_Json.UpdateString("S3Settings.CsvDelimiter","string")
loo_Json.UpdateString("S3Settings.CsvNoSupValue","string")
loo_Json.UpdateString("S3Settings.CsvNullValue","string")
loo_Json.UpdateString("S3Settings.CsvRowDelimiter","string")
loo_Json.UpdateString("S3Settings.DataFormat","string")
loo_Json.UpdateInt("S3Settings.DataPageSize",123)
loo_Json.UpdateString("S3Settings.DatePartitionDelimiter","string")
loo_Json.UpdateInt("S3Settings.DatePartitionEnabled",123)
loo_Json.UpdateString("S3Settings.DatePartitionSequence","string")
loo_Json.UpdateString("S3Settings.DatePartitionTimezone","string")
loo_Json.UpdateInt("S3Settings.DictPageSizeLimit",123)
loo_Json.UpdateInt("S3Settings.EnableStatistics",123)
loo_Json.UpdateString("S3Settings.EncodingType","string")
loo_Json.UpdateString("S3Settings.EncryptionMode","string")
loo_Json.UpdateString("S3Settings.ExternalTableDefinition","string")
loo_Json.UpdateInt("S3Settings.IgnoreHeaderRows",123)
loo_Json.UpdateInt("S3Settings.IncludeOpForFullLoad",123)
loo_Json.UpdateInt("S3Settings.MaxFileSize",123)
loo_Json.UpdateInt("S3Settings.ParquetTimestampInMillisecond",123)
loo_Json.UpdateString("S3Settings.ParquetVersion","string")
loo_Json.UpdateInt("S3Settings.PreserveTransactions",123)
loo_Json.UpdateInt("S3Settings.Rfc4180",123)
loo_Json.UpdateInt("S3Settings.RowGroupLength",123)
loo_Json.UpdateString("S3Settings.ServerSideEncryptionKmsKeyId","string")
loo_Json.UpdateString("S3Settings.ServiceAccessRoleArn","string")
loo_Json.UpdateString("S3Settings.TimestampColumnName","string")
loo_Json.UpdateInt("S3Settings.UseCsvNoSupValue",123)
loo_Json.UpdateInt("S3Settings.UseTaskStartTimeForFullLoadTimestamp",123)
loo_Json.UpdateString("ServerName","string")
loo_Json.UpdateString("ServiceAccessRoleArn","string")
loo_Json.UpdateString("SslMode","string")
loo_Json.UpdateString("SybaseSettings.DatabaseName","string")
loo_Json.UpdateString("SybaseSettings.Password","string")
loo_Json.UpdateInt("SybaseSettings.Port",123)
loo_Json.UpdateString("SybaseSettings.SecretsManagerAccessRoleArn","string")
loo_Json.UpdateString("SybaseSettings.SecretsManagerSecretId","string")
loo_Json.UpdateString("SybaseSettings.ServerName","string")
loo_Json.UpdateString("SybaseSettings.Username","string")
loo_Json.UpdateString("Tags[0].Key","string")
loo_Json.UpdateString("Tags[0].ResourceArn","string")
loo_Json.UpdateString("Tags[0].Value","string")
loo_Json.UpdateString("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"
// },
// "EndpointIdentifier": "string",
// "EndpointType": "string",
// "EngineName": "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"
// },
// "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
// },
// "ResourceIdentifier": "string",
// "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"
// },
// "Tags": [
// {
// "Key": "string",
// "ResourceArn": "string",
// "Value": "string"
// }
// ],
// "Username": "string"
// }
loo_Rest.AddHeader("Content-Type","application/x-amz-json-1.1")
loo_Rest.AddHeader("X-Amz-Target","AmazonDMSv20160101.CreateEndpoint")
loo_SbRequestBody = create oleobject
li_rc = loo_SbRequestBody.ConnectToNewObject("Chilkat_9_5_0.StringBuilder")
loo_Json.EmitSb(loo_SbRequestBody)
loo_SbResponseBody = create oleobject
li_rc = loo_SbResponseBody.ConnectToNewObject("Chilkat_9_5_0.StringBuilder")
li_Success = loo_Rest.FullRequestSb("POST","/",loo_SbRequestBody,loo_SbResponseBody)
if li_Success <> 1 then
Write-Debug loo_Rest.LastErrorText
destroy loo_Rest
destroy loo_AuthAws
destroy loo_Json
destroy loo_SbRequestBody
destroy loo_SbResponseBody
return
end if
li_RespStatusCode = loo_Rest.ResponseStatusCode
Write-Debug "response status code = " + string(li_RespStatusCode)
if li_RespStatusCode <> 200 then
Write-Debug "Response Header:"
Write-Debug loo_Rest.ResponseHeader
Write-Debug "Response Body:"
Write-Debug loo_SbResponseBody.GetAsString()
destroy loo_Rest
destroy loo_AuthAws
destroy loo_Json
destroy loo_SbRequestBody
destroy loo_SbResponseBody
return
end if
loo_JResp = create oleobject
li_rc = loo_JResp.ConnectToNewObject("Chilkat_9_5_0.JsonObject")
loo_JResp.LoadSb(loo_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
ls_CertificateArn = loo_JResp.StringOf("Endpoint.CertificateArn")
ls_DatabaseName = loo_JResp.StringOf("Endpoint.DatabaseName")
ls_BucketName = loo_JResp.StringOf("Endpoint.DmsTransferSettings.BucketName")
ls_ServiceAccessRoleArn = loo_JResp.StringOf("Endpoint.DmsTransferSettings.ServiceAccessRoleArn")
ls_DocDbSettingsDatabaseName = loo_JResp.StringOf("Endpoint.DocDbSettings.DatabaseName")
li_DocsToInvestigate = loo_JResp.IntOf("Endpoint.DocDbSettings.DocsToInvestigate")
li_ExtractDocId = loo_JResp.IntOf("Endpoint.DocDbSettings.ExtractDocId")
ls_KmsKeyId = loo_JResp.StringOf("Endpoint.DocDbSettings.KmsKeyId")
ls_NestingLevel = loo_JResp.StringOf("Endpoint.DocDbSettings.NestingLevel")
ls_Password = loo_JResp.StringOf("Endpoint.DocDbSettings.Password")
li_Port = loo_JResp.IntOf("Endpoint.DocDbSettings.Port")
ls_SecretsManagerAccessRoleArn = loo_JResp.StringOf("Endpoint.DocDbSettings.SecretsManagerAccessRoleArn")
ls_SecretsManagerSecretId = loo_JResp.StringOf("Endpoint.DocDbSettings.SecretsManagerSecretId")
ls_ServerName = loo_JResp.StringOf("Endpoint.DocDbSettings.ServerName")
ls_Username = loo_JResp.StringOf("Endpoint.DocDbSettings.Username")
ls_DynamoDbSettingsServiceAccessRoleArn = loo_JResp.StringOf("Endpoint.DynamoDbSettings.ServiceAccessRoleArn")
ls_EndpointUri = loo_JResp.StringOf("Endpoint.ElasticsearchSettings.EndpointUri")
li_ErrorRetryDuration = loo_JResp.IntOf("Endpoint.ElasticsearchSettings.ErrorRetryDuration")
li_FullLoadErrorPercentage = loo_JResp.IntOf("Endpoint.ElasticsearchSettings.FullLoadErrorPercentage")
ls_ElasticsearchSettingsServiceAccessRoleArn = loo_JResp.StringOf("Endpoint.ElasticsearchSettings.ServiceAccessRoleArn")
ls_EndpointArn = loo_JResp.StringOf("Endpoint.EndpointArn")
ls_EndpointIdentifier = loo_JResp.StringOf("Endpoint.EndpointIdentifier")
ls_EndpointType = loo_JResp.StringOf("Endpoint.EndpointType")
ls_EngineDisplayName = loo_JResp.StringOf("Endpoint.EngineDisplayName")
ls_EngineName = loo_JResp.StringOf("Endpoint.EngineName")
ls_ExternalId = loo_JResp.StringOf("Endpoint.ExternalId")
ls_ExternalTableDefinition = loo_JResp.StringOf("Endpoint.ExternalTableDefinition")
ls_ExtraConnectionAttributes = loo_JResp.StringOf("Endpoint.ExtraConnectionAttributes")
ls_AfterConnectScript = loo_JResp.StringOf("Endpoint.GcpMySQLSettings.AfterConnectScript")
li_CleanSourceMetadataOnMismatch = loo_JResp.IntOf("Endpoint.GcpMySQLSettings.CleanSourceMetadataOnMismatch")
ls_GcpMySQLSettingsDatabaseName = loo_JResp.StringOf("Endpoint.GcpMySQLSettings.DatabaseName")
li_EventsPollInterval = loo_JResp.IntOf("Endpoint.GcpMySQLSettings.EventsPollInterval")
li_MaxFileSize = loo_JResp.IntOf("Endpoint.GcpMySQLSettings.MaxFileSize")
li_ParallelLoadThreads = loo_JResp.IntOf("Endpoint.GcpMySQLSettings.ParallelLoadThreads")
ls_GcpMySQLSettingsPassword = loo_JResp.StringOf("Endpoint.GcpMySQLSettings.Password")
li_GcpMySQLSettingsPort = loo_JResp.IntOf("Endpoint.GcpMySQLSettings.Port")
ls_GcpMySQLSettingsSecretsManagerAccessRoleArn = loo_JResp.StringOf("Endpoint.GcpMySQLSettings.SecretsManagerAccessRoleArn")
ls_GcpMySQLSettingsSecretsManagerSecretId = loo_JResp.StringOf("Endpoint.GcpMySQLSettings.SecretsManagerSecretId")
ls_GcpMySQLSettingsServerName = loo_JResp.StringOf("Endpoint.GcpMySQLSettings.ServerName")
ls_ServerTimezone = loo_JResp.StringOf("Endpoint.GcpMySQLSettings.ServerTimezone")
ls_TargetDbType = loo_JResp.StringOf("Endpoint.GcpMySQLSettings.TargetDbType")
ls_GcpMySQLSettingsUsername = loo_JResp.StringOf("Endpoint.GcpMySQLSettings.Username")
ls_CurrentLsn = loo_JResp.StringOf("Endpoint.IBMDb2Settings.CurrentLsn")
ls_IBMDb2SettingsDatabaseName = loo_JResp.StringOf("Endpoint.IBMDb2Settings.DatabaseName")
li_MaxKBytesPerRead = loo_JResp.IntOf("Endpoint.IBMDb2Settings.MaxKBytesPerRead")
ls_IBMDb2SettingsPassword = loo_JResp.StringOf("Endpoint.IBMDb2Settings.Password")
li_IBMDb2SettingsPort = loo_JResp.IntOf("Endpoint.IBMDb2Settings.Port")
ls_IBMDb2SettingsSecretsManagerAccessRoleArn = loo_JResp.StringOf("Endpoint.IBMDb2Settings.SecretsManagerAccessRoleArn")
ls_IBMDb2SettingsSecretsManagerSecretId = loo_JResp.StringOf("Endpoint.IBMDb2Settings.SecretsManagerSecretId")
ls_IBMDb2SettingsServerName = loo_JResp.StringOf("Endpoint.IBMDb2Settings.ServerName")
li_SetDataCaptureChanges = loo_JResp.IntOf("Endpoint.IBMDb2Settings.SetDataCaptureChanges")
ls_IBMDb2SettingsUsername = loo_JResp.StringOf("Endpoint.IBMDb2Settings.Username")
ls_Broker = loo_JResp.StringOf("Endpoint.KafkaSettings.Broker")
li_IncludeControlDetails = loo_JResp.IntOf("Endpoint.KafkaSettings.IncludeControlDetails")
li_IncludeNullAndEmpty = loo_JResp.IntOf("Endpoint.KafkaSettings.IncludeNullAndEmpty")
li_IncludePartitionValue = loo_JResp.IntOf("Endpoint.KafkaSettings.IncludePartitionValue")
li_IncludeTableAlterOperations = loo_JResp.IntOf("Endpoint.KafkaSettings.IncludeTableAlterOperations")
li_IncludeTransactionDetails = loo_JResp.IntOf("Endpoint.KafkaSettings.IncludeTransactionDetails")
ls_MessageFormat = loo_JResp.StringOf("Endpoint.KafkaSettings.MessageFormat")
li_MessageMaxBytes = loo_JResp.IntOf("Endpoint.KafkaSettings.MessageMaxBytes")
li_NoHexPrefix = loo_JResp.IntOf("Endpoint.KafkaSettings.NoHexPrefix")
li_PartitionIncludeSchemaTable = loo_JResp.IntOf("Endpoint.KafkaSettings.PartitionIncludeSchemaTable")
ls_SaslPassword = loo_JResp.StringOf("Endpoint.KafkaSettings.SaslPassword")
ls_SaslUsername = loo_JResp.StringOf("Endpoint.KafkaSettings.SaslUsername")
ls_SecurityProtocol = loo_JResp.StringOf("Endpoint.KafkaSettings.SecurityProtocol")
ls_SslCaCertificateArn = loo_JResp.StringOf("Endpoint.KafkaSettings.SslCaCertificateArn")
ls_SslClientCertificateArn = loo_JResp.StringOf("Endpoint.KafkaSettings.SslClientCertificateArn")
ls_SslClientKeyArn = loo_JResp.StringOf("Endpoint.KafkaSettings.SslClientKeyArn")
ls_SslClientKeyPassword = loo_JResp.StringOf("Endpoint.KafkaSettings.SslClientKeyPassword")
ls_Topic = loo_JResp.StringOf("Endpoint.KafkaSettings.Topic")
li_KinesisSettingsIncludeControlDetails = loo_JResp.IntOf("Endpoint.KinesisSettings.IncludeControlDetails")
li_KinesisSettingsIncludeNullAndEmpty = loo_JResp.IntOf("Endpoint.KinesisSettings.IncludeNullAndEmpty")
li_KinesisSettingsIncludePartitionValue = loo_JResp.IntOf("Endpoint.KinesisSettings.IncludePartitionValue")
li_KinesisSettingsIncludeTableAlterOperations = loo_JResp.IntOf("Endpoint.KinesisSettings.IncludeTableAlterOperations")
li_KinesisSettingsIncludeTransactionDetails = loo_JResp.IntOf("Endpoint.KinesisSettings.IncludeTransactionDetails")
ls_KinesisSettingsMessageFormat = loo_JResp.StringOf("Endpoint.KinesisSettings.MessageFormat")
li_KinesisSettingsNoHexPrefix = loo_JResp.IntOf("Endpoint.KinesisSettings.NoHexPrefix")
li_KinesisSettingsPartitionIncludeSchemaTable = loo_JResp.IntOf("Endpoint.KinesisSettings.PartitionIncludeSchemaTable")
ls_KinesisSettingsServiceAccessRoleArn = loo_JResp.StringOf("Endpoint.KinesisSettings.ServiceAccessRoleArn")
ls_StreamArn = loo_JResp.StringOf("Endpoint.KinesisSettings.StreamArn")
ls_EndpointKmsKeyId = loo_JResp.StringOf("Endpoint.KmsKeyId")
li_BcpPacketSize = loo_JResp.IntOf("Endpoint.MicrosoftSQLServerSettings.BcpPacketSize")
ls_ControlTablesFileGroup = loo_JResp.StringOf("Endpoint.MicrosoftSQLServerSettings.ControlTablesFileGroup")
ls_MicrosoftSQLServerSettingsDatabaseName = loo_JResp.StringOf("Endpoint.MicrosoftSQLServerSettings.DatabaseName")
ls_MicrosoftSQLServerSettingsPassword = loo_JResp.StringOf("Endpoint.MicrosoftSQLServerSettings.Password")
li_MicrosoftSQLServerSettingsPort = loo_JResp.IntOf("Endpoint.MicrosoftSQLServerSettings.Port")
li_QuerySingleAlwaysOnNode = loo_JResp.IntOf("Endpoint.MicrosoftSQLServerSettings.QuerySingleAlwaysOnNode")
li_ReadBackupOnly = loo_JResp.IntOf("Endpoint.MicrosoftSQLServerSettings.ReadBackupOnly")
ls_SafeguardPolicy = loo_JResp.StringOf("Endpoint.MicrosoftSQLServerSettings.SafeguardPolicy")
ls_MicrosoftSQLServerSettingsSecretsManagerAccessRoleArn = loo_JResp.StringOf("Endpoint.MicrosoftSQLServerSettings.SecretsManagerAccessRoleArn")
ls_MicrosoftSQLServerSettingsSecretsManagerSecretId = loo_JResp.StringOf("Endpoint.MicrosoftSQLServerSettings.SecretsManagerSecretId")
ls_MicrosoftSQLServerSettingsServerName = loo_JResp.StringOf("Endpoint.MicrosoftSQLServerSettings.ServerName")
li_UseBcpFullLoad = loo_JResp.IntOf("Endpoint.MicrosoftSQLServerSettings.UseBcpFullLoad")
ls_MicrosoftSQLServerSettingsUsername = loo_JResp.StringOf("Endpoint.MicrosoftSQLServerSettings.Username")
li_UseThirdPartyBackupDevice = loo_JResp.IntOf("Endpoint.MicrosoftSQLServerSettings.UseThirdPartyBackupDevice")
ls_AuthMechanism = loo_JResp.StringOf("Endpoint.MongoDbSettings.AuthMechanism")
ls_AuthSource = loo_JResp.StringOf("Endpoint.MongoDbSettings.AuthSource")
ls_AuthType = loo_JResp.StringOf("Endpoint.MongoDbSettings.AuthType")
ls_MongoDbSettingsDatabaseName = loo_JResp.StringOf("Endpoint.MongoDbSettings.DatabaseName")
ls_MongoDbSettingsDocsToInvestigate = loo_JResp.StringOf("Endpoint.MongoDbSettings.DocsToInvestigate")
ls_MongoDbSettingsExtractDocId = loo_JResp.StringOf("Endpoint.MongoDbSettings.ExtractDocId")
ls_MongoDbSettingsKmsKeyId = loo_JResp.StringOf("Endpoint.MongoDbSettings.KmsKeyId")
ls_MongoDbSettingsNestingLevel = loo_JResp.StringOf("Endpoint.MongoDbSettings.NestingLevel")
ls_MongoDbSettingsPassword = loo_JResp.StringOf("Endpoint.MongoDbSettings.Password")
li_MongoDbSettingsPort = loo_JResp.IntOf("Endpoint.MongoDbSettings.Port")
ls_MongoDbSettingsSecretsManagerAccessRoleArn = loo_JResp.StringOf("Endpoint.MongoDbSettings.SecretsManagerAccessRoleArn")
ls_MongoDbSettingsSecretsManagerSecretId = loo_JResp.StringOf("Endpoint.MongoDbSettings.SecretsManagerSecretId")
ls_MongoDbSettingsServerName = loo_JResp.StringOf("Endpoint.MongoDbSettings.ServerName")
ls_MongoDbSettingsUsername = loo_JResp.StringOf("Endpoint.MongoDbSettings.Username")
ls_MySQLSettingsAfterConnectScript = loo_JResp.StringOf("Endpoint.MySQLSettings.AfterConnectScript")
li_MySQLSettingsCleanSourceMetadataOnMismatch = loo_JResp.IntOf("Endpoint.MySQLSettings.CleanSourceMetadataOnMismatch")
ls_MySQLSettingsDatabaseName = loo_JResp.StringOf("Endpoint.MySQLSettings.DatabaseName")
li_MySQLSettingsEventsPollInterval = loo_JResp.IntOf("Endpoint.MySQLSettings.EventsPollInterval")
li_MySQLSettingsMaxFileSize = loo_JResp.IntOf("Endpoint.MySQLSettings.MaxFileSize")
li_MySQLSettingsParallelLoadThreads = loo_JResp.IntOf("Endpoint.MySQLSettings.ParallelLoadThreads")
ls_MySQLSettingsPassword = loo_JResp.StringOf("Endpoint.MySQLSettings.Password")
li_MySQLSettingsPort = loo_JResp.IntOf("Endpoint.MySQLSettings.Port")
ls_MySQLSettingsSecretsManagerAccessRoleArn = loo_JResp.StringOf("Endpoint.MySQLSettings.SecretsManagerAccessRoleArn")
ls_MySQLSettingsSecretsManagerSecretId = loo_JResp.StringOf("Endpoint.MySQLSettings.SecretsManagerSecretId")
ls_MySQLSettingsServerName = loo_JResp.StringOf("Endpoint.MySQLSettings.ServerName")
ls_MySQLSettingsServerTimezone = loo_JResp.StringOf("Endpoint.MySQLSettings.ServerTimezone")
ls_MySQLSettingsTargetDbType = loo_JResp.StringOf("Endpoint.MySQLSettings.TargetDbType")
ls_MySQLSettingsUsername = loo_JResp.StringOf("Endpoint.MySQLSettings.Username")
li_NeptuneSettingsErrorRetryDuration = loo_JResp.IntOf("Endpoint.NeptuneSettings.ErrorRetryDuration")
li_IamAuthEnabled = loo_JResp.IntOf("Endpoint.NeptuneSettings.IamAuthEnabled")
li_NeptuneSettingsMaxFileSize = loo_JResp.IntOf("Endpoint.NeptuneSettings.MaxFileSize")
li_MaxRetryCount = loo_JResp.IntOf("Endpoint.NeptuneSettings.MaxRetryCount")
ls_S3BucketFolder = loo_JResp.StringOf("Endpoint.NeptuneSettings.S3BucketFolder")
ls_S3BucketName = loo_JResp.StringOf("Endpoint.NeptuneSettings.S3BucketName")
ls_NeptuneSettingsServiceAccessRoleArn = loo_JResp.StringOf("Endpoint.NeptuneSettings.ServiceAccessRoleArn")
li_AccessAlternateDirectly = loo_JResp.IntOf("Endpoint.OracleSettings.AccessAlternateDirectly")
li_AdditionalArchivedLogDestId = loo_JResp.IntOf("Endpoint.OracleSettings.AdditionalArchivedLogDestId")
li_AddSupplementalLogging = loo_JResp.IntOf("Endpoint.OracleSettings.AddSupplementalLogging")
li_AllowSelectNestedTables = loo_JResp.IntOf("Endpoint.OracleSettings.AllowSelectNestedTables")
li_ArchivedLogDestId = loo_JResp.IntOf("Endpoint.OracleSettings.ArchivedLogDestId")
li_ArchivedLogsOnly = loo_JResp.IntOf("Endpoint.OracleSettings.ArchivedLogsOnly")
ls_AsmPassword = loo_JResp.StringOf("Endpoint.OracleSettings.AsmPassword")
ls_AsmServer = loo_JResp.StringOf("Endpoint.OracleSettings.AsmServer")
ls_AsmUser = loo_JResp.StringOf("Endpoint.OracleSettings.AsmUser")
ls_CharLengthSemantics = loo_JResp.StringOf("Endpoint.OracleSettings.CharLengthSemantics")
ls_OracleSettingsDatabaseName = loo_JResp.StringOf("Endpoint.OracleSettings.DatabaseName")
li_DirectPathNoLog = loo_JResp.IntOf("Endpoint.OracleSettings.DirectPathNoLog")
li_DirectPathParallelLoad = loo_JResp.IntOf("Endpoint.OracleSettings.DirectPathParallelLoad")
li_EnableHomogenousTablespace = loo_JResp.IntOf("Endpoint.OracleSettings.EnableHomogenousTablespace")
li_FailTasksOnLobTruncation = loo_JResp.IntOf("Endpoint.OracleSettings.FailTasksOnLobTruncation")
li_NumberDatatypeScale = loo_JResp.IntOf("Endpoint.OracleSettings.NumberDatatypeScale")
ls_OraclePathPrefix = loo_JResp.StringOf("Endpoint.OracleSettings.OraclePathPrefix")
li_ParallelAsmReadThreads = loo_JResp.IntOf("Endpoint.OracleSettings.ParallelAsmReadThreads")
ls_OracleSettingsPassword = loo_JResp.StringOf("Endpoint.OracleSettings.Password")
li_OracleSettingsPort = loo_JResp.IntOf("Endpoint.OracleSettings.Port")
li_ReadAheadBlocks = loo_JResp.IntOf("Endpoint.OracleSettings.ReadAheadBlocks")
li_ReadTableSpaceName = loo_JResp.IntOf("Endpoint.OracleSettings.ReadTableSpaceName")
li_ReplacePathPrefix = loo_JResp.IntOf("Endpoint.OracleSettings.ReplacePathPrefix")
li_RetryInterval = loo_JResp.IntOf("Endpoint.OracleSettings.RetryInterval")
ls_OracleSettingsSecretsManagerAccessRoleArn = loo_JResp.StringOf("Endpoint.OracleSettings.SecretsManagerAccessRoleArn")
ls_SecretsManagerOracleAsmAccessRoleArn = loo_JResp.StringOf("Endpoint.OracleSettings.SecretsManagerOracleAsmAccessRoleArn")
ls_SecretsManagerOracleAsmSecretId = loo_JResp.StringOf("Endpoint.OracleSettings.SecretsManagerOracleAsmSecretId")
ls_OracleSettingsSecretsManagerSecretId = loo_JResp.StringOf("Endpoint.OracleSettings.SecretsManagerSecretId")
ls_SecurityDbEncryption = loo_JResp.StringOf("Endpoint.OracleSettings.SecurityDbEncryption")
ls_SecurityDbEncryptionName = loo_JResp.StringOf("Endpoint.OracleSettings.SecurityDbEncryptionName")
ls_OracleSettingsServerName = loo_JResp.StringOf("Endpoint.OracleSettings.ServerName")
ls_SpatialDataOptionToGeoJsonFunctionName = loo_JResp.StringOf("Endpoint.OracleSettings.SpatialDataOptionToGeoJsonFunctionName")
li_StandbyDelayTime = loo_JResp.IntOf("Endpoint.OracleSettings.StandbyDelayTime")
li_UseAlternateFolderForOnline = loo_JResp.IntOf("Endpoint.OracleSettings.UseAlternateFolderForOnline")
li_UseBFile = loo_JResp.IntOf("Endpoint.OracleSettings.UseBFile")
li_UseDirectPathFullLoad = loo_JResp.IntOf("Endpoint.OracleSettings.UseDirectPathFullLoad")
li_UseLogminerReader = loo_JResp.IntOf("Endpoint.OracleSettings.UseLogminerReader")
ls_UsePathPrefix = loo_JResp.StringOf("Endpoint.OracleSettings.UsePathPrefix")
ls_OracleSettingsUsername = loo_JResp.StringOf("Endpoint.OracleSettings.Username")
li_EndpointPort = loo_JResp.IntOf("Endpoint.Port")
ls_PostgreSQLSettingsAfterConnectScript = loo_JResp.StringOf("Endpoint.PostgreSQLSettings.AfterConnectScript")
li_CaptureDdls = loo_JResp.IntOf("Endpoint.PostgreSQLSettings.CaptureDdls")
ls_PostgreSQLSettingsDatabaseName = loo_JResp.StringOf("Endpoint.PostgreSQLSettings.DatabaseName")
ls_DdlArtifactsSchema = loo_JResp.StringOf("Endpoint.PostgreSQLSettings.DdlArtifactsSchema")
li_ExecuteTimeout = loo_JResp.IntOf("Endpoint.PostgreSQLSettings.ExecuteTimeout")
li_PostgreSQLSettingsFailTasksOnLobTruncation = loo_JResp.IntOf("Endpoint.PostgreSQLSettings.FailTasksOnLobTruncation")
li_HeartbeatEnable = loo_JResp.IntOf("Endpoint.PostgreSQLSettings.HeartbeatEnable")
li_HeartbeatFrequency = loo_JResp.IntOf("Endpoint.PostgreSQLSettings.HeartbeatFrequency")
ls_HeartbeatSchema = loo_JResp.StringOf("Endpoint.PostgreSQLSettings.HeartbeatSchema")
li_PostgreSQLSettingsMaxFileSize = loo_JResp.IntOf("Endpoint.PostgreSQLSettings.MaxFileSize")
ls_PostgreSQLSettingsPassword = loo_JResp.StringOf("Endpoint.PostgreSQLSettings.Password")
ls_PluginName = loo_JResp.StringOf("Endpoint.PostgreSQLSettings.PluginName")
li_PostgreSQLSettingsPort = loo_JResp.IntOf("Endpoint.PostgreSQLSettings.Port")
ls_PostgreSQLSettingsSecretsManagerAccessRoleArn = loo_JResp.StringOf("Endpoint.PostgreSQLSettings.SecretsManagerAccessRoleArn")
ls_PostgreSQLSettingsSecretsManagerSecretId = loo_JResp.StringOf("Endpoint.PostgreSQLSettings.SecretsManagerSecretId")
ls_PostgreSQLSettingsServerName = loo_JResp.StringOf("Endpoint.PostgreSQLSettings.ServerName")
ls_SlotName = loo_JResp.StringOf("Endpoint.PostgreSQLSettings.SlotName")
ls_PostgreSQLSettingsUsername = loo_JResp.StringOf("Endpoint.PostgreSQLSettings.Username")
ls_AuthPassword = loo_JResp.StringOf("Endpoint.RedisSettings.AuthPassword")
ls_RedisSettingsAuthType = loo_JResp.StringOf("Endpoint.RedisSettings.AuthType")
ls_AuthUserName = loo_JResp.StringOf("Endpoint.RedisSettings.AuthUserName")
li_RedisSettingsPort = loo_JResp.IntOf("Endpoint.RedisSettings.Port")
ls_RedisSettingsServerName = loo_JResp.StringOf("Endpoint.RedisSettings.ServerName")
ls_RedisSettingsSslCaCertificateArn = loo_JResp.StringOf("Endpoint.RedisSettings.SslCaCertificateArn")
ls_SslSecurityProtocol = loo_JResp.StringOf("Endpoint.RedisSettings.SslSecurityProtocol")
li_AcceptAnyDate = loo_JResp.IntOf("Endpoint.RedshiftSettings.AcceptAnyDate")
ls_RedshiftSettingsAfterConnectScript = loo_JResp.StringOf("Endpoint.RedshiftSettings.AfterConnectScript")
ls_BucketFolder = loo_JResp.StringOf("Endpoint.RedshiftSettings.BucketFolder")
ls_RedshiftSettingsBucketName = loo_JResp.StringOf("Endpoint.RedshiftSettings.BucketName")
li_CaseSensitiveNames = loo_JResp.IntOf("Endpoint.RedshiftSettings.CaseSensitiveNames")
li_CompUpdate = loo_JResp.IntOf("Endpoint.RedshiftSettings.CompUpdate")
li_ConnectionTimeout = loo_JResp.IntOf("Endpoint.RedshiftSettings.ConnectionTimeout")
ls_RedshiftSettingsDatabaseName = loo_JResp.StringOf("Endpoint.RedshiftSettings.DatabaseName")
ls_DateFormat = loo_JResp.StringOf("Endpoint.RedshiftSettings.DateFormat")
li_EmptyAsNull = loo_JResp.IntOf("Endpoint.RedshiftSettings.EmptyAsNull")
ls_EncryptionMode = loo_JResp.StringOf("Endpoint.RedshiftSettings.EncryptionMode")
li_ExplicitIds = loo_JResp.IntOf("Endpoint.RedshiftSettings.ExplicitIds")
li_FileTransferUploadStreams = loo_JResp.IntOf("Endpoint.RedshiftSettings.FileTransferUploadStreams")
li_LoadTimeout = loo_JResp.IntOf("Endpoint.RedshiftSettings.LoadTimeout")
li_RedshiftSettingsMaxFileSize = loo_JResp.IntOf("Endpoint.RedshiftSettings.MaxFileSize")
ls_RedshiftSettingsPassword = loo_JResp.StringOf("Endpoint.RedshiftSettings.Password")
li_RedshiftSettingsPort = loo_JResp.IntOf("Endpoint.RedshiftSettings.Port")
li_RemoveQuotes = loo_JResp.IntOf("Endpoint.RedshiftSettings.RemoveQuotes")
ls_ReplaceChars = loo_JResp.StringOf("Endpoint.RedshiftSettings.ReplaceChars")
ls_ReplaceInvalidChars = loo_JResp.StringOf("Endpoint.RedshiftSettings.ReplaceInvalidChars")
ls_RedshiftSettingsSecretsManagerAccessRoleArn = loo_JResp.StringOf("Endpoint.RedshiftSettings.SecretsManagerAccessRoleArn")
ls_RedshiftSettingsSecretsManagerSecretId = loo_JResp.StringOf("Endpoint.RedshiftSettings.SecretsManagerSecretId")
ls_RedshiftSettingsServerName = loo_JResp.StringOf("Endpoint.RedshiftSettings.ServerName")
ls_ServerSideEncryptionKmsKeyId = loo_JResp.StringOf("Endpoint.RedshiftSettings.ServerSideEncryptionKmsKeyId")
ls_RedshiftSettingsServiceAccessRoleArn = loo_JResp.StringOf("Endpoint.RedshiftSettings.ServiceAccessRoleArn")
ls_TimeFormat = loo_JResp.StringOf("Endpoint.RedshiftSettings.TimeFormat")
li_TrimBlanks = loo_JResp.IntOf("Endpoint.RedshiftSettings.TrimBlanks")
li_TruncateColumns = loo_JResp.IntOf("Endpoint.RedshiftSettings.TruncateColumns")
ls_RedshiftSettingsUsername = loo_JResp.StringOf("Endpoint.RedshiftSettings.Username")
li_WriteBufferSize = loo_JResp.IntOf("Endpoint.RedshiftSettings.WriteBufferSize")
li_AddColumnName = loo_JResp.IntOf("Endpoint.S3Settings.AddColumnName")
ls_S3SettingsBucketFolder = loo_JResp.StringOf("Endpoint.S3Settings.BucketFolder")
ls_S3SettingsBucketName = loo_JResp.StringOf("Endpoint.S3Settings.BucketName")
ls_CannedAclForObjects = loo_JResp.StringOf("Endpoint.S3Settings.CannedAclForObjects")
li_CdcInsertsAndUpdates = loo_JResp.IntOf("Endpoint.S3Settings.CdcInsertsAndUpdates")
li_CdcInsertsOnly = loo_JResp.IntOf("Endpoint.S3Settings.CdcInsertsOnly")
li_CdcMaxBatchInterval = loo_JResp.IntOf("Endpoint.S3Settings.CdcMaxBatchInterval")
li_CdcMinFileSize = loo_JResp.IntOf("Endpoint.S3Settings.CdcMinFileSize")
ls_CdcPath = loo_JResp.StringOf("Endpoint.S3Settings.CdcPath")
ls_CompressionType = loo_JResp.StringOf("Endpoint.S3Settings.CompressionType")
ls_CsvDelimiter = loo_JResp.StringOf("Endpoint.S3Settings.CsvDelimiter")
ls_CsvNoSupValue = loo_JResp.StringOf("Endpoint.S3Settings.CsvNoSupValue")
ls_CsvNullValue = loo_JResp.StringOf("Endpoint.S3Settings.CsvNullValue")
ls_CsvRowDelimiter = loo_JResp.StringOf("Endpoint.S3Settings.CsvRowDelimiter")
ls_DataFormat = loo_JResp.StringOf("Endpoint.S3Settings.DataFormat")
li_DataPageSize = loo_JResp.IntOf("Endpoint.S3Settings.DataPageSize")
ls_DatePartitionDelimiter = loo_JResp.StringOf("Endpoint.S3Settings.DatePartitionDelimiter")
li_DatePartitionEnabled = loo_JResp.IntOf("Endpoint.S3Settings.DatePartitionEnabled")
ls_DatePartitionSequence = loo_JResp.StringOf("Endpoint.S3Settings.DatePartitionSequence")
ls_DatePartitionTimezone = loo_JResp.StringOf("Endpoint.S3Settings.DatePartitionTimezone")
li_DictPageSizeLimit = loo_JResp.IntOf("Endpoint.S3Settings.DictPageSizeLimit")
li_EnableStatistics = loo_JResp.IntOf("Endpoint.S3Settings.EnableStatistics")
ls_EncodingType = loo_JResp.StringOf("Endpoint.S3Settings.EncodingType")
ls_S3SettingsEncryptionMode = loo_JResp.StringOf("Endpoint.S3Settings.EncryptionMode")
ls_S3SettingsExternalTableDefinition = loo_JResp.StringOf("Endpoint.S3Settings.ExternalTableDefinition")
li_IgnoreHeaderRows = loo_JResp.IntOf("Endpoint.S3Settings.IgnoreHeaderRows")
li_IncludeOpForFullLoad = loo_JResp.IntOf("Endpoint.S3Settings.IncludeOpForFullLoad")
li_S3SettingsMaxFileSize = loo_JResp.IntOf("Endpoint.S3Settings.MaxFileSize")
li_ParquetTimestampInMillisecond = loo_JResp.IntOf("Endpoint.S3Settings.ParquetTimestampInMillisecond")
ls_ParquetVersion = loo_JResp.StringOf("Endpoint.S3Settings.ParquetVersion")
li_PreserveTransactions = loo_JResp.IntOf("Endpoint.S3Settings.PreserveTransactions")
li_Rfc4180 = loo_JResp.IntOf("Endpoint.S3Settings.Rfc4180")
li_RowGroupLength = loo_JResp.IntOf("Endpoint.S3Settings.RowGroupLength")
ls_S3SettingsServerSideEncryptionKmsKeyId = loo_JResp.StringOf("Endpoint.S3Settings.ServerSideEncryptionKmsKeyId")
ls_S3SettingsServiceAccessRoleArn = loo_JResp.StringOf("Endpoint.S3Settings.ServiceAccessRoleArn")
ls_TimestampColumnName = loo_JResp.StringOf("Endpoint.S3Settings.TimestampColumnName")
li_UseCsvNoSupValue = loo_JResp.IntOf("Endpoint.S3Settings.UseCsvNoSupValue")
li_UseTaskStartTimeForFullLoadTimestamp = loo_JResp.IntOf("Endpoint.S3Settings.UseTaskStartTimeForFullLoadTimestamp")
ls_EndpointServerName = loo_JResp.StringOf("Endpoint.ServerName")
ls_EndpointServiceAccessRoleArn = loo_JResp.StringOf("Endpoint.ServiceAccessRoleArn")
ls_SslMode = loo_JResp.StringOf("Endpoint.SslMode")
ls_Status = loo_JResp.StringOf("Endpoint.Status")
ls_SybaseSettingsDatabaseName = loo_JResp.StringOf("Endpoint.SybaseSettings.DatabaseName")
ls_SybaseSettingsPassword = loo_JResp.StringOf("Endpoint.SybaseSettings.Password")
li_SybaseSettingsPort = loo_JResp.IntOf("Endpoint.SybaseSettings.Port")
ls_SybaseSettingsSecretsManagerAccessRoleArn = loo_JResp.StringOf("Endpoint.SybaseSettings.SecretsManagerAccessRoleArn")
ls_SybaseSettingsSecretsManagerSecretId = loo_JResp.StringOf("Endpoint.SybaseSettings.SecretsManagerSecretId")
ls_SybaseSettingsServerName = loo_JResp.StringOf("Endpoint.SybaseSettings.ServerName")
ls_SybaseSettingsUsername = loo_JResp.StringOf("Endpoint.SybaseSettings.Username")
ls_EndpointUsername = loo_JResp.StringOf("Endpoint.Username")
i = 0
li_Count_i = loo_JResp.SizeOfArray("Endpoint.OracleSettings.ExtraArchivedLogDestIds")
do while i < li_Count_i
loo_JResp.I = i
li_IntVal = loo_JResp.IntOf("Endpoint.OracleSettings.ExtraArchivedLogDestIds[i]")
i = i + 1
loop
// 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"
// }
// }
destroy loo_Rest
destroy loo_AuthAws
destroy loo_Json
destroy loo_SbRequestBody
destroy loo_SbResponseBody
destroy loo_JResp
