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