DescribeEndpoints DataFlex Example
Use ChilkatAx-9.5.0-win32.pkg
Procedure Test
Handle hoRest
Boolean iSuccess
Variant vAuthAws
Handle hoAuthAws
Handle hoJson
Variant vSbRequestBody
Handle hoSbRequestBody
Variant vSbResponseBody
Handle hoSbResponseBody
Integer iRespStatusCode
Handle hoJResp
String sCertificateArn
String sDatabaseName
String sBucketName
String sServiceAccessRoleArn
String sDocDbSettingsDatabaseName
Integer iDocsToInvestigate
Integer iExtractDocId
String sKmsKeyId
String sNestingLevel
String sPassword
Integer iPort
String sSecretsManagerAccessRoleArn
String sSecretsManagerSecretId
String sServerName
String sUsername
String sDynamoDbSettingsServiceAccessRoleArn
String sEndpointUri
Integer iErrorRetryDuration
Integer iFullLoadErrorPercentage
String sElasticsearchSettingsServiceAccessRoleArn
String sEndpointArn
String sEndpointIdentifier
String sEndpointType
String sEngineDisplayName
String sEngineName
String sExternalId
String sExternalTableDefinition
String sExtraConnectionAttributes
String sAfterConnectScript
Integer iCleanSourceMetadataOnMismatch
String sGcpMySQLSettingsDatabaseName
Integer iEventsPollInterval
Integer iMaxFileSize
Integer iParallelLoadThreads
String sGcpMySQLSettingsPassword
Integer iGcpMySQLSettingsPort
String sGcpMySQLSettingsSecretsManagerAccessRoleArn
String sGcpMySQLSettingsSecretsManagerSecretId
String sGcpMySQLSettingsServerName
String sServerTimezone
String sTargetDbType
String sGcpMySQLSettingsUsername
String sCurrentLsn
String sIBMDb2SettingsDatabaseName
Integer iMaxKBytesPerRead
String sIBMDb2SettingsPassword
Integer iIBMDb2SettingsPort
String sIBMDb2SettingsSecretsManagerAccessRoleArn
String sIBMDb2SettingsSecretsManagerSecretId
String sIBMDb2SettingsServerName
Integer iSetDataCaptureChanges
String sIBMDb2SettingsUsername
String sBroker
Integer iIncludeControlDetails
Integer iIncludeNullAndEmpty
Integer iIncludePartitionValue
Integer iIncludeTableAlterOperations
Integer iIncludeTransactionDetails
String sMessageFormat
Integer iMessageMaxBytes
Integer iNoHexPrefix
Integer iPartitionIncludeSchemaTable
String sSaslPassword
String sSaslUsername
String sSecurityProtocol
String sSslCaCertificateArn
String sSslClientCertificateArn
String sSslClientKeyArn
String sSslClientKeyPassword
String sTopic
Integer iKinesisSettingsIncludeControlDetails
Integer iKinesisSettingsIncludeNullAndEmpty
Integer iKinesisSettingsIncludePartitionValue
Integer iKinesisSettingsIncludeTableAlterOperations
Integer iKinesisSettingsIncludeTransactionDetails
String sKinesisSettingsMessageFormat
Integer iKinesisSettingsNoHexPrefix
Integer iKinesisSettingsPartitionIncludeSchemaTable
String sKinesisSettingsServiceAccessRoleArn
String sStreamArn
Integer iBcpPacketSize
String sControlTablesFileGroup
String sMicrosoftSQLServerSettingsDatabaseName
String sMicrosoftSQLServerSettingsPassword
Integer iMicrosoftSQLServerSettingsPort
Integer iQuerySingleAlwaysOnNode
Integer iReadBackupOnly
String sSafeguardPolicy
String sMicrosoftSQLServerSettingsSecretsManagerAccessRoleArn
String sMicrosoftSQLServerSettingsSecretsManagerSecretId
String sMicrosoftSQLServerSettingsServerName
Integer iUseBcpFullLoad
String sMicrosoftSQLServerSettingsUsername
Integer iUseThirdPartyBackupDevice
String sAuthMechanism
String sAuthSource
String sAuthType
String sMongoDbSettingsDatabaseName
String sMongoDbSettingsDocsToInvestigate
String sMongoDbSettingsExtractDocId
String sMongoDbSettingsKmsKeyId
String sMongoDbSettingsNestingLevel
String sMongoDbSettingsPassword
Integer iMongoDbSettingsPort
String sMongoDbSettingsSecretsManagerAccessRoleArn
String sMongoDbSettingsSecretsManagerSecretId
String sMongoDbSettingsServerName
String sMongoDbSettingsUsername
String sMySQLSettingsAfterConnectScript
Integer iMySQLSettingsCleanSourceMetadataOnMismatch
String sMySQLSettingsDatabaseName
Integer iMySQLSettingsEventsPollInterval
Integer iMySQLSettingsMaxFileSize
Integer iMySQLSettingsParallelLoadThreads
String sMySQLSettingsPassword
Integer iMySQLSettingsPort
String sMySQLSettingsSecretsManagerAccessRoleArn
String sMySQLSettingsSecretsManagerSecretId
String sMySQLSettingsServerName
String sMySQLSettingsServerTimezone
String sMySQLSettingsTargetDbType
String sMySQLSettingsUsername
Integer iNeptuneSettingsErrorRetryDuration
Integer iIamAuthEnabled
Integer iNeptuneSettingsMaxFileSize
Integer iMaxRetryCount
String sS3BucketFolder
String sS3BucketName
String sNeptuneSettingsServiceAccessRoleArn
Integer iAccessAlternateDirectly
Integer iAdditionalArchivedLogDestId
Integer iAddSupplementalLogging
Integer iAllowSelectNestedTables
Integer iArchivedLogDestId
Integer iArchivedLogsOnly
String sAsmPassword
String sAsmServer
String sAsmUser
String sCharLengthSemantics
String sOracleSettingsDatabaseName
Integer iDirectPathNoLog
Integer iDirectPathParallelLoad
Integer iEnableHomogenousTablespace
Integer iFailTasksOnLobTruncation
Integer iNumberDatatypeScale
String sOraclePathPrefix
Integer iParallelAsmReadThreads
String sOracleSettingsPassword
Integer iOracleSettingsPort
Integer iReadAheadBlocks
Integer iReadTableSpaceName
Integer iReplacePathPrefix
Integer iRetryInterval
String sOracleSettingsSecretsManagerAccessRoleArn
String sSecretsManagerOracleAsmAccessRoleArn
String sSecretsManagerOracleAsmSecretId
String sOracleSettingsSecretsManagerSecretId
String sSecurityDbEncryption
String sSecurityDbEncryptionName
String sOracleSettingsServerName
String sSpatialDataOptionToGeoJsonFunctionName
Integer iStandbyDelayTime
Integer iUseAlternateFolderForOnline
Integer iUseBFile
Integer iUseDirectPathFullLoad
Integer iUseLogminerReader
String sUsePathPrefix
String sOracleSettingsUsername
String sPostgreSQLSettingsAfterConnectScript
Integer iCaptureDdls
String sPostgreSQLSettingsDatabaseName
String sDdlArtifactsSchema
Integer iExecuteTimeout
Integer iPostgreSQLSettingsFailTasksOnLobTruncation
Integer iHeartbeatEnable
Integer iHeartbeatFrequency
String sHeartbeatSchema
Integer iPostgreSQLSettingsMaxFileSize
String sPostgreSQLSettingsPassword
String sPluginName
Integer iPostgreSQLSettingsPort
String sPostgreSQLSettingsSecretsManagerAccessRoleArn
String sPostgreSQLSettingsSecretsManagerSecretId
String sPostgreSQLSettingsServerName
String sSlotName
String sPostgreSQLSettingsUsername
String sAuthPassword
String sRedisSettingsAuthType
String sAuthUserName
Integer iRedisSettingsPort
String sRedisSettingsServerName
String sRedisSettingsSslCaCertificateArn
String sSslSecurityProtocol
Integer iAcceptAnyDate
String sRedshiftSettingsAfterConnectScript
String sBucketFolder
String sRedshiftSettingsBucketName
Integer iCaseSensitiveNames
Integer iCompUpdate
Integer iConnectionTimeout
String sRedshiftSettingsDatabaseName
String sDateFormat
Integer iEmptyAsNull
String sEncryptionMode
Integer iExplicitIds
Integer iFileTransferUploadStreams
Integer iLoadTimeout
Integer iRedshiftSettingsMaxFileSize
String sRedshiftSettingsPassword
Integer iRedshiftSettingsPort
Integer iRemoveQuotes
String sReplaceChars
String sReplaceInvalidChars
String sRedshiftSettingsSecretsManagerAccessRoleArn
String sRedshiftSettingsSecretsManagerSecretId
String sRedshiftSettingsServerName
String sServerSideEncryptionKmsKeyId
String sRedshiftSettingsServiceAccessRoleArn
String sTimeFormat
Integer iTrimBlanks
Integer iTruncateColumns
String sRedshiftSettingsUsername
Integer iWriteBufferSize
Integer iAddColumnName
String sS3SettingsBucketFolder
String sS3SettingsBucketName
String sCannedAclForObjects
Integer iCdcInsertsAndUpdates
Integer iCdcInsertsOnly
Integer iCdcMaxBatchInterval
Integer iCdcMinFileSize
String sCdcPath
String sCompressionType
String sCsvDelimiter
String sCsvNoSupValue
String sCsvNullValue
String sCsvRowDelimiter
String sDataFormat
Integer iDataPageSize
String sDatePartitionDelimiter
Integer iDatePartitionEnabled
String sDatePartitionSequence
String sDatePartitionTimezone
Integer iDictPageSizeLimit
Integer iEnableStatistics
String sEncodingType
String sS3SettingsEncryptionMode
String sS3SettingsExternalTableDefinition
Integer iIgnoreHeaderRows
Integer iIncludeOpForFullLoad
Integer iS3SettingsMaxFileSize
Integer iParquetTimestampInMillisecond
String sParquetVersion
Integer iPreserveTransactions
Integer iRfc4180
Integer iRowGroupLength
String sS3SettingsServerSideEncryptionKmsKeyId
String sS3SettingsServiceAccessRoleArn
String sTimestampColumnName
Integer iUseCsvNoSupValue
Integer iUseTaskStartTimeForFullLoadTimestamp
String sSslMode
String sStatus
String sSybaseSettingsDatabaseName
String sSybaseSettingsPassword
Integer iSybaseSettingsPort
String sSybaseSettingsSecretsManagerAccessRoleArn
String sSybaseSettingsSecretsManagerSecretId
String sSybaseSettingsServerName
String sSybaseSettingsUsername
Integer j
Integer iCount_j
Integer iIntVal
String sMarker
Integer i
Integer iCount_i
String sTemp1
Integer iTemp1
// This example requires the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
Get Create (RefClass(cComChilkatRest)) To hoRest
If (Not(IsComObjectCreated(hoRest))) Begin
Send CreateComObject of hoRest
End
Get Create (RefClass(cComChilkatAuthAws)) To hoAuthAws
If (Not(IsComObjectCreated(hoAuthAws))) Begin
Send CreateComObject of hoAuthAws
End
Set ComAccessKey Of hoAuthAws To "AWS_ACCESS_KEY"
Set ComSecretKey Of hoAuthAws To "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.)
Set ComRegion Of hoAuthAws To "us-west-2"
Set ComServiceName Of hoAuthAws To "dms"
// SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
Get pvComObject of hoAuthAws to vAuthAws
Get ComSetAuthAws Of hoRest vAuthAws To iSuccess
// URL: https://dms.us-west-2.amazonaws.com/
// Use the same region as specified above.
Get ComConnect Of hoRest "dms.us-west-2.amazonaws.com" 443 True True To iSuccess
If (iSuccess <> True) Begin
Get ComConnectFailReason Of hoRest To iTemp1
Showln "ConnectFailReason: " iTemp1
Get ComLastErrorText Of hoRest To sTemp1
Showln sTemp1
Procedure_Return
End
// 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
Get Create (RefClass(cComChilkatJsonObject)) To hoJson
If (Not(IsComObjectCreated(hoJson))) Begin
Send CreateComObject of hoJson
End
Get ComUpdateString Of hoJson "Filters[0].Name" "string" To iSuccess
Get ComUpdateString Of hoJson "Filters[0].Values[0]" "string" To iSuccess
Get ComUpdateString Of hoJson "Marker" "string" To iSuccess
Get ComUpdateInt Of hoJson "MaxRecords" 123 To iSuccess
// The JSON request body created by the above code:
// {
// "Filters": [
// {
// "Name": "string",
// "Values": [
// "string"
// ]
// }
// ],
// "Marker": "string",
// "MaxRecords": number
// }
Get ComAddHeader Of hoRest "Content-Type" "application/x-amz-json-1.1" To iSuccess
Get ComAddHeader Of hoRest "X-Amz-Target" "AmazonDMSv20160101.DescribeEndpoints" To iSuccess
Get Create (RefClass(cComChilkatStringBuilder)) To hoSbRequestBody
If (Not(IsComObjectCreated(hoSbRequestBody))) Begin
Send CreateComObject of hoSbRequestBody
End
Get pvComObject of hoSbRequestBody to vSbRequestBody
Get ComEmitSb Of hoJson vSbRequestBody To iSuccess
Get Create (RefClass(cComChilkatStringBuilder)) To hoSbResponseBody
If (Not(IsComObjectCreated(hoSbResponseBody))) Begin
Send CreateComObject of hoSbResponseBody
End
Get pvComObject of hoSbRequestBody to vSbRequestBody
Get pvComObject of hoSbResponseBody to vSbResponseBody
Get ComFullRequestSb Of hoRest "POST" "/" vSbRequestBody vSbResponseBody To iSuccess
If (iSuccess <> True) Begin
Get ComLastErrorText Of hoRest To sTemp1
Showln sTemp1
Procedure_Return
End
Get ComResponseStatusCode Of hoRest To iRespStatusCode
Showln "response status code = " iRespStatusCode
If (iRespStatusCode <> 200) Begin
Showln "Response Header:"
Get ComResponseHeader Of hoRest To sTemp1
Showln sTemp1
Showln "Response Body:"
Get ComGetAsString Of hoSbResponseBody To sTemp1
Showln sTemp1
Procedure_Return
End
Get Create (RefClass(cComChilkatJsonObject)) To hoJResp
If (Not(IsComObjectCreated(hoJResp))) Begin
Send CreateComObject of hoJResp
End
Get pvComObject of hoSbResponseBody to vSbResponseBody
Get ComLoadSb Of hoJResp vSbResponseBody To iSuccess
// 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
Get ComStringOf Of hoJResp "Marker" To sMarker
Move 0 To i
Get ComSizeOfArray Of hoJResp "Endpoints" To iCount_i
While (i < iCount_i)
Set ComI Of hoJResp To i
Get ComStringOf Of hoJResp "Endpoints[i].CertificateArn" To sCertificateArn
Get ComStringOf Of hoJResp "Endpoints[i].DatabaseName" To sDatabaseName
Get ComStringOf Of hoJResp "Endpoints[i].DmsTransferSettings.BucketName" To sBucketName
Get ComStringOf Of hoJResp "Endpoints[i].DmsTransferSettings.ServiceAccessRoleArn" To sServiceAccessRoleArn
Get ComStringOf Of hoJResp "Endpoints[i].DocDbSettings.DatabaseName" To sDocDbSettingsDatabaseName
Get ComIntOf Of hoJResp "Endpoints[i].DocDbSettings.DocsToInvestigate" To iDocsToInvestigate
Get ComIntOf Of hoJResp "Endpoints[i].DocDbSettings.ExtractDocId" To iExtractDocId
Get ComStringOf Of hoJResp "Endpoints[i].DocDbSettings.KmsKeyId" To sKmsKeyId
Get ComStringOf Of hoJResp "Endpoints[i].DocDbSettings.NestingLevel" To sNestingLevel
Get ComStringOf Of hoJResp "Endpoints[i].DocDbSettings.Password" To sPassword
Get ComIntOf Of hoJResp "Endpoints[i].DocDbSettings.Port" To iPort
Get ComStringOf Of hoJResp "Endpoints[i].DocDbSettings.SecretsManagerAccessRoleArn" To sSecretsManagerAccessRoleArn
Get ComStringOf Of hoJResp "Endpoints[i].DocDbSettings.SecretsManagerSecretId" To sSecretsManagerSecretId
Get ComStringOf Of hoJResp "Endpoints[i].DocDbSettings.ServerName" To sServerName
Get ComStringOf Of hoJResp "Endpoints[i].DocDbSettings.Username" To sUsername
Get ComStringOf Of hoJResp "Endpoints[i].DynamoDbSettings.ServiceAccessRoleArn" To sDynamoDbSettingsServiceAccessRoleArn
Get ComStringOf Of hoJResp "Endpoints[i].ElasticsearchSettings.EndpointUri" To sEndpointUri
Get ComIntOf Of hoJResp "Endpoints[i].ElasticsearchSettings.ErrorRetryDuration" To iErrorRetryDuration
Get ComIntOf Of hoJResp "Endpoints[i].ElasticsearchSettings.FullLoadErrorPercentage" To iFullLoadErrorPercentage
Get ComStringOf Of hoJResp "Endpoints[i].ElasticsearchSettings.ServiceAccessRoleArn" To sElasticsearchSettingsServiceAccessRoleArn
Get ComStringOf Of hoJResp "Endpoints[i].EndpointArn" To sEndpointArn
Get ComStringOf Of hoJResp "Endpoints[i].EndpointIdentifier" To sEndpointIdentifier
Get ComStringOf Of hoJResp "Endpoints[i].EndpointType" To sEndpointType
Get ComStringOf Of hoJResp "Endpoints[i].EngineDisplayName" To sEngineDisplayName
Get ComStringOf Of hoJResp "Endpoints[i].EngineName" To sEngineName
Get ComStringOf Of hoJResp "Endpoints[i].ExternalId" To sExternalId
Get ComStringOf Of hoJResp "Endpoints[i].ExternalTableDefinition" To sExternalTableDefinition
Get ComStringOf Of hoJResp "Endpoints[i].ExtraConnectionAttributes" To sExtraConnectionAttributes
Get ComStringOf Of hoJResp "Endpoints[i].GcpMySQLSettings.AfterConnectScript" To sAfterConnectScript
Get ComIntOf Of hoJResp "Endpoints[i].GcpMySQLSettings.CleanSourceMetadataOnMismatch" To iCleanSourceMetadataOnMismatch
Get ComStringOf Of hoJResp "Endpoints[i].GcpMySQLSettings.DatabaseName" To sGcpMySQLSettingsDatabaseName
Get ComIntOf Of hoJResp "Endpoints[i].GcpMySQLSettings.EventsPollInterval" To iEventsPollInterval
Get ComIntOf Of hoJResp "Endpoints[i].GcpMySQLSettings.MaxFileSize" To iMaxFileSize
Get ComIntOf Of hoJResp "Endpoints[i].GcpMySQLSettings.ParallelLoadThreads" To iParallelLoadThreads
Get ComStringOf Of hoJResp "Endpoints[i].GcpMySQLSettings.Password" To sGcpMySQLSettingsPassword
Get ComIntOf Of hoJResp "Endpoints[i].GcpMySQLSettings.Port" To iGcpMySQLSettingsPort
Get ComStringOf Of hoJResp "Endpoints[i].GcpMySQLSettings.SecretsManagerAccessRoleArn" To sGcpMySQLSettingsSecretsManagerAccessRoleArn
Get ComStringOf Of hoJResp "Endpoints[i].GcpMySQLSettings.SecretsManagerSecretId" To sGcpMySQLSettingsSecretsManagerSecretId
Get ComStringOf Of hoJResp "Endpoints[i].GcpMySQLSettings.ServerName" To sGcpMySQLSettingsServerName
Get ComStringOf Of hoJResp "Endpoints[i].GcpMySQLSettings.ServerTimezone" To sServerTimezone
Get ComStringOf Of hoJResp "Endpoints[i].GcpMySQLSettings.TargetDbType" To sTargetDbType
Get ComStringOf Of hoJResp "Endpoints[i].GcpMySQLSettings.Username" To sGcpMySQLSettingsUsername
Get ComStringOf Of hoJResp "Endpoints[i].IBMDb2Settings.CurrentLsn" To sCurrentLsn
Get ComStringOf Of hoJResp "Endpoints[i].IBMDb2Settings.DatabaseName" To sIBMDb2SettingsDatabaseName
Get ComIntOf Of hoJResp "Endpoints[i].IBMDb2Settings.MaxKBytesPerRead" To iMaxKBytesPerRead
Get ComStringOf Of hoJResp "Endpoints[i].IBMDb2Settings.Password" To sIBMDb2SettingsPassword
Get ComIntOf Of hoJResp "Endpoints[i].IBMDb2Settings.Port" To iIBMDb2SettingsPort
Get ComStringOf Of hoJResp "Endpoints[i].IBMDb2Settings.SecretsManagerAccessRoleArn" To sIBMDb2SettingsSecretsManagerAccessRoleArn
Get ComStringOf Of hoJResp "Endpoints[i].IBMDb2Settings.SecretsManagerSecretId" To sIBMDb2SettingsSecretsManagerSecretId
Get ComStringOf Of hoJResp "Endpoints[i].IBMDb2Settings.ServerName" To sIBMDb2SettingsServerName
Get ComIntOf Of hoJResp "Endpoints[i].IBMDb2Settings.SetDataCaptureChanges" To iSetDataCaptureChanges
Get ComStringOf Of hoJResp "Endpoints[i].IBMDb2Settings.Username" To sIBMDb2SettingsUsername
Get ComStringOf Of hoJResp "Endpoints[i].KafkaSettings.Broker" To sBroker
Get ComIntOf Of hoJResp "Endpoints[i].KafkaSettings.IncludeControlDetails" To iIncludeControlDetails
Get ComIntOf Of hoJResp "Endpoints[i].KafkaSettings.IncludeNullAndEmpty" To iIncludeNullAndEmpty
Get ComIntOf Of hoJResp "Endpoints[i].KafkaSettings.IncludePartitionValue" To iIncludePartitionValue
Get ComIntOf Of hoJResp "Endpoints[i].KafkaSettings.IncludeTableAlterOperations" To iIncludeTableAlterOperations
Get ComIntOf Of hoJResp "Endpoints[i].KafkaSettings.IncludeTransactionDetails" To iIncludeTransactionDetails
Get ComStringOf Of hoJResp "Endpoints[i].KafkaSettings.MessageFormat" To sMessageFormat
Get ComIntOf Of hoJResp "Endpoints[i].KafkaSettings.MessageMaxBytes" To iMessageMaxBytes
Get ComIntOf Of hoJResp "Endpoints[i].KafkaSettings.NoHexPrefix" To iNoHexPrefix
Get ComIntOf Of hoJResp "Endpoints[i].KafkaSettings.PartitionIncludeSchemaTable" To iPartitionIncludeSchemaTable
Get ComStringOf Of hoJResp "Endpoints[i].KafkaSettings.SaslPassword" To sSaslPassword
Get ComStringOf Of hoJResp "Endpoints[i].KafkaSettings.SaslUsername" To sSaslUsername
Get ComStringOf Of hoJResp "Endpoints[i].KafkaSettings.SecurityProtocol" To sSecurityProtocol
Get ComStringOf Of hoJResp "Endpoints[i].KafkaSettings.SslCaCertificateArn" To sSslCaCertificateArn
Get ComStringOf Of hoJResp "Endpoints[i].KafkaSettings.SslClientCertificateArn" To sSslClientCertificateArn
Get ComStringOf Of hoJResp "Endpoints[i].KafkaSettings.SslClientKeyArn" To sSslClientKeyArn
Get ComStringOf Of hoJResp "Endpoints[i].KafkaSettings.SslClientKeyPassword" To sSslClientKeyPassword
Get ComStringOf Of hoJResp "Endpoints[i].KafkaSettings.Topic" To sTopic
Get ComIntOf Of hoJResp "Endpoints[i].KinesisSettings.IncludeControlDetails" To iKinesisSettingsIncludeControlDetails
Get ComIntOf Of hoJResp "Endpoints[i].KinesisSettings.IncludeNullAndEmpty" To iKinesisSettingsIncludeNullAndEmpty
Get ComIntOf Of hoJResp "Endpoints[i].KinesisSettings.IncludePartitionValue" To iKinesisSettingsIncludePartitionValue
Get ComIntOf Of hoJResp "Endpoints[i].KinesisSettings.IncludeTableAlterOperations" To iKinesisSettingsIncludeTableAlterOperations
Get ComIntOf Of hoJResp "Endpoints[i].KinesisSettings.IncludeTransactionDetails" To iKinesisSettingsIncludeTransactionDetails
Get ComStringOf Of hoJResp "Endpoints[i].KinesisSettings.MessageFormat" To sKinesisSettingsMessageFormat
Get ComIntOf Of hoJResp "Endpoints[i].KinesisSettings.NoHexPrefix" To iKinesisSettingsNoHexPrefix
Get ComIntOf Of hoJResp "Endpoints[i].KinesisSettings.PartitionIncludeSchemaTable" To iKinesisSettingsPartitionIncludeSchemaTable
Get ComStringOf Of hoJResp "Endpoints[i].KinesisSettings.ServiceAccessRoleArn" To sKinesisSettingsServiceAccessRoleArn
Get ComStringOf Of hoJResp "Endpoints[i].KinesisSettings.StreamArn" To sStreamArn
Get ComStringOf Of hoJResp "Endpoints[i].KmsKeyId" To sKmsKeyId
Get ComIntOf Of hoJResp "Endpoints[i].MicrosoftSQLServerSettings.BcpPacketSize" To iBcpPacketSize
Get ComStringOf Of hoJResp "Endpoints[i].MicrosoftSQLServerSettings.ControlTablesFileGroup" To sControlTablesFileGroup
Get ComStringOf Of hoJResp "Endpoints[i].MicrosoftSQLServerSettings.DatabaseName" To sMicrosoftSQLServerSettingsDatabaseName
Get ComStringOf Of hoJResp "Endpoints[i].MicrosoftSQLServerSettings.Password" To sMicrosoftSQLServerSettingsPassword
Get ComIntOf Of hoJResp "Endpoints[i].MicrosoftSQLServerSettings.Port" To iMicrosoftSQLServerSettingsPort
Get ComIntOf Of hoJResp "Endpoints[i].MicrosoftSQLServerSettings.QuerySingleAlwaysOnNode" To iQuerySingleAlwaysOnNode
Get ComIntOf Of hoJResp "Endpoints[i].MicrosoftSQLServerSettings.ReadBackupOnly" To iReadBackupOnly
Get ComStringOf Of hoJResp "Endpoints[i].MicrosoftSQLServerSettings.SafeguardPolicy" To sSafeguardPolicy
Get ComStringOf Of hoJResp "Endpoints[i].MicrosoftSQLServerSettings.SecretsManagerAccessRoleArn" To sMicrosoftSQLServerSettingsSecretsManagerAccessRoleArn
Get ComStringOf Of hoJResp "Endpoints[i].MicrosoftSQLServerSettings.SecretsManagerSecretId" To sMicrosoftSQLServerSettingsSecretsManagerSecretId
Get ComStringOf Of hoJResp "Endpoints[i].MicrosoftSQLServerSettings.ServerName" To sMicrosoftSQLServerSettingsServerName
Get ComIntOf Of hoJResp "Endpoints[i].MicrosoftSQLServerSettings.UseBcpFullLoad" To iUseBcpFullLoad
Get ComStringOf Of hoJResp "Endpoints[i].MicrosoftSQLServerSettings.Username" To sMicrosoftSQLServerSettingsUsername
Get ComIntOf Of hoJResp "Endpoints[i].MicrosoftSQLServerSettings.UseThirdPartyBackupDevice" To iUseThirdPartyBackupDevice
Get ComStringOf Of hoJResp "Endpoints[i].MongoDbSettings.AuthMechanism" To sAuthMechanism
Get ComStringOf Of hoJResp "Endpoints[i].MongoDbSettings.AuthSource" To sAuthSource
Get ComStringOf Of hoJResp "Endpoints[i].MongoDbSettings.AuthType" To sAuthType
Get ComStringOf Of hoJResp "Endpoints[i].MongoDbSettings.DatabaseName" To sMongoDbSettingsDatabaseName
Get ComStringOf Of hoJResp "Endpoints[i].MongoDbSettings.DocsToInvestigate" To sMongoDbSettingsDocsToInvestigate
Get ComStringOf Of hoJResp "Endpoints[i].MongoDbSettings.ExtractDocId" To sMongoDbSettingsExtractDocId
Get ComStringOf Of hoJResp "Endpoints[i].MongoDbSettings.KmsKeyId" To sMongoDbSettingsKmsKeyId
Get ComStringOf Of hoJResp "Endpoints[i].MongoDbSettings.NestingLevel" To sMongoDbSettingsNestingLevel
Get ComStringOf Of hoJResp "Endpoints[i].MongoDbSettings.Password" To sMongoDbSettingsPassword
Get ComIntOf Of hoJResp "Endpoints[i].MongoDbSettings.Port" To iMongoDbSettingsPort
Get ComStringOf Of hoJResp "Endpoints[i].MongoDbSettings.SecretsManagerAccessRoleArn" To sMongoDbSettingsSecretsManagerAccessRoleArn
Get ComStringOf Of hoJResp "Endpoints[i].MongoDbSettings.SecretsManagerSecretId" To sMongoDbSettingsSecretsManagerSecretId
Get ComStringOf Of hoJResp "Endpoints[i].MongoDbSettings.ServerName" To sMongoDbSettingsServerName
Get ComStringOf Of hoJResp "Endpoints[i].MongoDbSettings.Username" To sMongoDbSettingsUsername
Get ComStringOf Of hoJResp "Endpoints[i].MySQLSettings.AfterConnectScript" To sMySQLSettingsAfterConnectScript
Get ComIntOf Of hoJResp "Endpoints[i].MySQLSettings.CleanSourceMetadataOnMismatch" To iMySQLSettingsCleanSourceMetadataOnMismatch
Get ComStringOf Of hoJResp "Endpoints[i].MySQLSettings.DatabaseName" To sMySQLSettingsDatabaseName
Get ComIntOf Of hoJResp "Endpoints[i].MySQLSettings.EventsPollInterval" To iMySQLSettingsEventsPollInterval
Get ComIntOf Of hoJResp "Endpoints[i].MySQLSettings.MaxFileSize" To iMySQLSettingsMaxFileSize
Get ComIntOf Of hoJResp "Endpoints[i].MySQLSettings.ParallelLoadThreads" To iMySQLSettingsParallelLoadThreads
Get ComStringOf Of hoJResp "Endpoints[i].MySQLSettings.Password" To sMySQLSettingsPassword
Get ComIntOf Of hoJResp "Endpoints[i].MySQLSettings.Port" To iMySQLSettingsPort
Get ComStringOf Of hoJResp "Endpoints[i].MySQLSettings.SecretsManagerAccessRoleArn" To sMySQLSettingsSecretsManagerAccessRoleArn
Get ComStringOf Of hoJResp "Endpoints[i].MySQLSettings.SecretsManagerSecretId" To sMySQLSettingsSecretsManagerSecretId
Get ComStringOf Of hoJResp "Endpoints[i].MySQLSettings.ServerName" To sMySQLSettingsServerName
Get ComStringOf Of hoJResp "Endpoints[i].MySQLSettings.ServerTimezone" To sMySQLSettingsServerTimezone
Get ComStringOf Of hoJResp "Endpoints[i].MySQLSettings.TargetDbType" To sMySQLSettingsTargetDbType
Get ComStringOf Of hoJResp "Endpoints[i].MySQLSettings.Username" To sMySQLSettingsUsername
Get ComIntOf Of hoJResp "Endpoints[i].NeptuneSettings.ErrorRetryDuration" To iNeptuneSettingsErrorRetryDuration
Get ComIntOf Of hoJResp "Endpoints[i].NeptuneSettings.IamAuthEnabled" To iIamAuthEnabled
Get ComIntOf Of hoJResp "Endpoints[i].NeptuneSettings.MaxFileSize" To iNeptuneSettingsMaxFileSize
Get ComIntOf Of hoJResp "Endpoints[i].NeptuneSettings.MaxRetryCount" To iMaxRetryCount
Get ComStringOf Of hoJResp "Endpoints[i].NeptuneSettings.S3BucketFolder" To sS3BucketFolder
Get ComStringOf Of hoJResp "Endpoints[i].NeptuneSettings.S3BucketName" To sS3BucketName
Get ComStringOf Of hoJResp "Endpoints[i].NeptuneSettings.ServiceAccessRoleArn" To sNeptuneSettingsServiceAccessRoleArn
Get ComIntOf Of hoJResp "Endpoints[i].OracleSettings.AccessAlternateDirectly" To iAccessAlternateDirectly
Get ComIntOf Of hoJResp "Endpoints[i].OracleSettings.AdditionalArchivedLogDestId" To iAdditionalArchivedLogDestId
Get ComIntOf Of hoJResp "Endpoints[i].OracleSettings.AddSupplementalLogging" To iAddSupplementalLogging
Get ComIntOf Of hoJResp "Endpoints[i].OracleSettings.AllowSelectNestedTables" To iAllowSelectNestedTables
Get ComIntOf Of hoJResp "Endpoints[i].OracleSettings.ArchivedLogDestId" To iArchivedLogDestId
Get ComIntOf Of hoJResp "Endpoints[i].OracleSettings.ArchivedLogsOnly" To iArchivedLogsOnly
Get ComStringOf Of hoJResp "Endpoints[i].OracleSettings.AsmPassword" To sAsmPassword
Get ComStringOf Of hoJResp "Endpoints[i].OracleSettings.AsmServer" To sAsmServer
Get ComStringOf Of hoJResp "Endpoints[i].OracleSettings.AsmUser" To sAsmUser
Get ComStringOf Of hoJResp "Endpoints[i].OracleSettings.CharLengthSemantics" To sCharLengthSemantics
Get ComStringOf Of hoJResp "Endpoints[i].OracleSettings.DatabaseName" To sOracleSettingsDatabaseName
Get ComIntOf Of hoJResp "Endpoints[i].OracleSettings.DirectPathNoLog" To iDirectPathNoLog
Get ComIntOf Of hoJResp "Endpoints[i].OracleSettings.DirectPathParallelLoad" To iDirectPathParallelLoad
Get ComIntOf Of hoJResp "Endpoints[i].OracleSettings.EnableHomogenousTablespace" To iEnableHomogenousTablespace
Get ComIntOf Of hoJResp "Endpoints[i].OracleSettings.FailTasksOnLobTruncation" To iFailTasksOnLobTruncation
Get ComIntOf Of hoJResp "Endpoints[i].OracleSettings.NumberDatatypeScale" To iNumberDatatypeScale
Get ComStringOf Of hoJResp "Endpoints[i].OracleSettings.OraclePathPrefix" To sOraclePathPrefix
Get ComIntOf Of hoJResp "Endpoints[i].OracleSettings.ParallelAsmReadThreads" To iParallelAsmReadThreads
Get ComStringOf Of hoJResp "Endpoints[i].OracleSettings.Password" To sOracleSettingsPassword
Get ComIntOf Of hoJResp "Endpoints[i].OracleSettings.Port" To iOracleSettingsPort
Get ComIntOf Of hoJResp "Endpoints[i].OracleSettings.ReadAheadBlocks" To iReadAheadBlocks
Get ComIntOf Of hoJResp "Endpoints[i].OracleSettings.ReadTableSpaceName" To iReadTableSpaceName
Get ComIntOf Of hoJResp "Endpoints[i].OracleSettings.ReplacePathPrefix" To iReplacePathPrefix
Get ComIntOf Of hoJResp "Endpoints[i].OracleSettings.RetryInterval" To iRetryInterval
Get ComStringOf Of hoJResp "Endpoints[i].OracleSettings.SecretsManagerAccessRoleArn" To sOracleSettingsSecretsManagerAccessRoleArn
Get ComStringOf Of hoJResp "Endpoints[i].OracleSettings.SecretsManagerOracleAsmAccessRoleArn" To sSecretsManagerOracleAsmAccessRoleArn
Get ComStringOf Of hoJResp "Endpoints[i].OracleSettings.SecretsManagerOracleAsmSecretId" To sSecretsManagerOracleAsmSecretId
Get ComStringOf Of hoJResp "Endpoints[i].OracleSettings.SecretsManagerSecretId" To sOracleSettingsSecretsManagerSecretId
Get ComStringOf Of hoJResp "Endpoints[i].OracleSettings.SecurityDbEncryption" To sSecurityDbEncryption
Get ComStringOf Of hoJResp "Endpoints[i].OracleSettings.SecurityDbEncryptionName" To sSecurityDbEncryptionName
Get ComStringOf Of hoJResp "Endpoints[i].OracleSettings.ServerName" To sOracleSettingsServerName
Get ComStringOf Of hoJResp "Endpoints[i].OracleSettings.SpatialDataOptionToGeoJsonFunctionName" To sSpatialDataOptionToGeoJsonFunctionName
Get ComIntOf Of hoJResp "Endpoints[i].OracleSettings.StandbyDelayTime" To iStandbyDelayTime
Get ComIntOf Of hoJResp "Endpoints[i].OracleSettings.UseAlternateFolderForOnline" To iUseAlternateFolderForOnline
Get ComIntOf Of hoJResp "Endpoints[i].OracleSettings.UseBFile" To iUseBFile
Get ComIntOf Of hoJResp "Endpoints[i].OracleSettings.UseDirectPathFullLoad" To iUseDirectPathFullLoad
Get ComIntOf Of hoJResp "Endpoints[i].OracleSettings.UseLogminerReader" To iUseLogminerReader
Get ComStringOf Of hoJResp "Endpoints[i].OracleSettings.UsePathPrefix" To sUsePathPrefix
Get ComStringOf Of hoJResp "Endpoints[i].OracleSettings.Username" To sOracleSettingsUsername
Get ComIntOf Of hoJResp "Endpoints[i].Port" To iPort
Get ComStringOf Of hoJResp "Endpoints[i].PostgreSQLSettings.AfterConnectScript" To sPostgreSQLSettingsAfterConnectScript
Get ComIntOf Of hoJResp "Endpoints[i].PostgreSQLSettings.CaptureDdls" To iCaptureDdls
Get ComStringOf Of hoJResp "Endpoints[i].PostgreSQLSettings.DatabaseName" To sPostgreSQLSettingsDatabaseName
Get ComStringOf Of hoJResp "Endpoints[i].PostgreSQLSettings.DdlArtifactsSchema" To sDdlArtifactsSchema
Get ComIntOf Of hoJResp "Endpoints[i].PostgreSQLSettings.ExecuteTimeout" To iExecuteTimeout
Get ComIntOf Of hoJResp "Endpoints[i].PostgreSQLSettings.FailTasksOnLobTruncation" To iPostgreSQLSettingsFailTasksOnLobTruncation
Get ComIntOf Of hoJResp "Endpoints[i].PostgreSQLSettings.HeartbeatEnable" To iHeartbeatEnable
Get ComIntOf Of hoJResp "Endpoints[i].PostgreSQLSettings.HeartbeatFrequency" To iHeartbeatFrequency
Get ComStringOf Of hoJResp "Endpoints[i].PostgreSQLSettings.HeartbeatSchema" To sHeartbeatSchema
Get ComIntOf Of hoJResp "Endpoints[i].PostgreSQLSettings.MaxFileSize" To iPostgreSQLSettingsMaxFileSize
Get ComStringOf Of hoJResp "Endpoints[i].PostgreSQLSettings.Password" To sPostgreSQLSettingsPassword
Get ComStringOf Of hoJResp "Endpoints[i].PostgreSQLSettings.PluginName" To sPluginName
Get ComIntOf Of hoJResp "Endpoints[i].PostgreSQLSettings.Port" To iPostgreSQLSettingsPort
Get ComStringOf Of hoJResp "Endpoints[i].PostgreSQLSettings.SecretsManagerAccessRoleArn" To sPostgreSQLSettingsSecretsManagerAccessRoleArn
Get ComStringOf Of hoJResp "Endpoints[i].PostgreSQLSettings.SecretsManagerSecretId" To sPostgreSQLSettingsSecretsManagerSecretId
Get ComStringOf Of hoJResp "Endpoints[i].PostgreSQLSettings.ServerName" To sPostgreSQLSettingsServerName
Get ComStringOf Of hoJResp "Endpoints[i].PostgreSQLSettings.SlotName" To sSlotName
Get ComStringOf Of hoJResp "Endpoints[i].PostgreSQLSettings.Username" To sPostgreSQLSettingsUsername
Get ComStringOf Of hoJResp "Endpoints[i].RedisSettings.AuthPassword" To sAuthPassword
Get ComStringOf Of hoJResp "Endpoints[i].RedisSettings.AuthType" To sRedisSettingsAuthType
Get ComStringOf Of hoJResp "Endpoints[i].RedisSettings.AuthUserName" To sAuthUserName
Get ComIntOf Of hoJResp "Endpoints[i].RedisSettings.Port" To iRedisSettingsPort
Get ComStringOf Of hoJResp "Endpoints[i].RedisSettings.ServerName" To sRedisSettingsServerName
Get ComStringOf Of hoJResp "Endpoints[i].RedisSettings.SslCaCertificateArn" To sRedisSettingsSslCaCertificateArn
Get ComStringOf Of hoJResp "Endpoints[i].RedisSettings.SslSecurityProtocol" To sSslSecurityProtocol
Get ComIntOf Of hoJResp "Endpoints[i].RedshiftSettings.AcceptAnyDate" To iAcceptAnyDate
Get ComStringOf Of hoJResp "Endpoints[i].RedshiftSettings.AfterConnectScript" To sRedshiftSettingsAfterConnectScript
Get ComStringOf Of hoJResp "Endpoints[i].RedshiftSettings.BucketFolder" To sBucketFolder
Get ComStringOf Of hoJResp "Endpoints[i].RedshiftSettings.BucketName" To sRedshiftSettingsBucketName
Get ComIntOf Of hoJResp "Endpoints[i].RedshiftSettings.CaseSensitiveNames" To iCaseSensitiveNames
Get ComIntOf Of hoJResp "Endpoints[i].RedshiftSettings.CompUpdate" To iCompUpdate
Get ComIntOf Of hoJResp "Endpoints[i].RedshiftSettings.ConnectionTimeout" To iConnectionTimeout
Get ComStringOf Of hoJResp "Endpoints[i].RedshiftSettings.DatabaseName" To sRedshiftSettingsDatabaseName
Get ComStringOf Of hoJResp "Endpoints[i].RedshiftSettings.DateFormat" To sDateFormat
Get ComIntOf Of hoJResp "Endpoints[i].RedshiftSettings.EmptyAsNull" To iEmptyAsNull
Get ComStringOf Of hoJResp "Endpoints[i].RedshiftSettings.EncryptionMode" To sEncryptionMode
Get ComIntOf Of hoJResp "Endpoints[i].RedshiftSettings.ExplicitIds" To iExplicitIds
Get ComIntOf Of hoJResp "Endpoints[i].RedshiftSettings.FileTransferUploadStreams" To iFileTransferUploadStreams
Get ComIntOf Of hoJResp "Endpoints[i].RedshiftSettings.LoadTimeout" To iLoadTimeout
Get ComIntOf Of hoJResp "Endpoints[i].RedshiftSettings.MaxFileSize" To iRedshiftSettingsMaxFileSize
Get ComStringOf Of hoJResp "Endpoints[i].RedshiftSettings.Password" To sRedshiftSettingsPassword
Get ComIntOf Of hoJResp "Endpoints[i].RedshiftSettings.Port" To iRedshiftSettingsPort
Get ComIntOf Of hoJResp "Endpoints[i].RedshiftSettings.RemoveQuotes" To iRemoveQuotes
Get ComStringOf Of hoJResp "Endpoints[i].RedshiftSettings.ReplaceChars" To sReplaceChars
Get ComStringOf Of hoJResp "Endpoints[i].RedshiftSettings.ReplaceInvalidChars" To sReplaceInvalidChars
Get ComStringOf Of hoJResp "Endpoints[i].RedshiftSettings.SecretsManagerAccessRoleArn" To sRedshiftSettingsSecretsManagerAccessRoleArn
Get ComStringOf Of hoJResp "Endpoints[i].RedshiftSettings.SecretsManagerSecretId" To sRedshiftSettingsSecretsManagerSecretId
Get ComStringOf Of hoJResp "Endpoints[i].RedshiftSettings.ServerName" To sRedshiftSettingsServerName
Get ComStringOf Of hoJResp "Endpoints[i].RedshiftSettings.ServerSideEncryptionKmsKeyId" To sServerSideEncryptionKmsKeyId
Get ComStringOf Of hoJResp "Endpoints[i].RedshiftSettings.ServiceAccessRoleArn" To sRedshiftSettingsServiceAccessRoleArn
Get ComStringOf Of hoJResp "Endpoints[i].RedshiftSettings.TimeFormat" To sTimeFormat
Get ComIntOf Of hoJResp "Endpoints[i].RedshiftSettings.TrimBlanks" To iTrimBlanks
Get ComIntOf Of hoJResp "Endpoints[i].RedshiftSettings.TruncateColumns" To iTruncateColumns
Get ComStringOf Of hoJResp "Endpoints[i].RedshiftSettings.Username" To sRedshiftSettingsUsername
Get ComIntOf Of hoJResp "Endpoints[i].RedshiftSettings.WriteBufferSize" To iWriteBufferSize
Get ComIntOf Of hoJResp "Endpoints[i].S3Settings.AddColumnName" To iAddColumnName
Get ComStringOf Of hoJResp "Endpoints[i].S3Settings.BucketFolder" To sS3SettingsBucketFolder
Get ComStringOf Of hoJResp "Endpoints[i].S3Settings.BucketName" To sS3SettingsBucketName
Get ComStringOf Of hoJResp "Endpoints[i].S3Settings.CannedAclForObjects" To sCannedAclForObjects
Get ComIntOf Of hoJResp "Endpoints[i].S3Settings.CdcInsertsAndUpdates" To iCdcInsertsAndUpdates
Get ComIntOf Of hoJResp "Endpoints[i].S3Settings.CdcInsertsOnly" To iCdcInsertsOnly
Get ComIntOf Of hoJResp "Endpoints[i].S3Settings.CdcMaxBatchInterval" To iCdcMaxBatchInterval
Get ComIntOf Of hoJResp "Endpoints[i].S3Settings.CdcMinFileSize" To iCdcMinFileSize
Get ComStringOf Of hoJResp "Endpoints[i].S3Settings.CdcPath" To sCdcPath
Get ComStringOf Of hoJResp "Endpoints[i].S3Settings.CompressionType" To sCompressionType
Get ComStringOf Of hoJResp "Endpoints[i].S3Settings.CsvDelimiter" To sCsvDelimiter
Get ComStringOf Of hoJResp "Endpoints[i].S3Settings.CsvNoSupValue" To sCsvNoSupValue
Get ComStringOf Of hoJResp "Endpoints[i].S3Settings.CsvNullValue" To sCsvNullValue
Get ComStringOf Of hoJResp "Endpoints[i].S3Settings.CsvRowDelimiter" To sCsvRowDelimiter
Get ComStringOf Of hoJResp "Endpoints[i].S3Settings.DataFormat" To sDataFormat
Get ComIntOf Of hoJResp "Endpoints[i].S3Settings.DataPageSize" To iDataPageSize
Get ComStringOf Of hoJResp "Endpoints[i].S3Settings.DatePartitionDelimiter" To sDatePartitionDelimiter
Get ComIntOf Of hoJResp "Endpoints[i].S3Settings.DatePartitionEnabled" To iDatePartitionEnabled
Get ComStringOf Of hoJResp "Endpoints[i].S3Settings.DatePartitionSequence" To sDatePartitionSequence
Get ComStringOf Of hoJResp "Endpoints[i].S3Settings.DatePartitionTimezone" To sDatePartitionTimezone
Get ComIntOf Of hoJResp "Endpoints[i].S3Settings.DictPageSizeLimit" To iDictPageSizeLimit
Get ComIntOf Of hoJResp "Endpoints[i].S3Settings.EnableStatistics" To iEnableStatistics
Get ComStringOf Of hoJResp "Endpoints[i].S3Settings.EncodingType" To sEncodingType
Get ComStringOf Of hoJResp "Endpoints[i].S3Settings.EncryptionMode" To sS3SettingsEncryptionMode
Get ComStringOf Of hoJResp "Endpoints[i].S3Settings.ExternalTableDefinition" To sS3SettingsExternalTableDefinition
Get ComIntOf Of hoJResp "Endpoints[i].S3Settings.IgnoreHeaderRows" To iIgnoreHeaderRows
Get ComIntOf Of hoJResp "Endpoints[i].S3Settings.IncludeOpForFullLoad" To iIncludeOpForFullLoad
Get ComIntOf Of hoJResp "Endpoints[i].S3Settings.MaxFileSize" To iS3SettingsMaxFileSize
Get ComIntOf Of hoJResp "Endpoints[i].S3Settings.ParquetTimestampInMillisecond" To iParquetTimestampInMillisecond
Get ComStringOf Of hoJResp "Endpoints[i].S3Settings.ParquetVersion" To sParquetVersion
Get ComIntOf Of hoJResp "Endpoints[i].S3Settings.PreserveTransactions" To iPreserveTransactions
Get ComIntOf Of hoJResp "Endpoints[i].S3Settings.Rfc4180" To iRfc4180
Get ComIntOf Of hoJResp "Endpoints[i].S3Settings.RowGroupLength" To iRowGroupLength
Get ComStringOf Of hoJResp "Endpoints[i].S3Settings.ServerSideEncryptionKmsKeyId" To sS3SettingsServerSideEncryptionKmsKeyId
Get ComStringOf Of hoJResp "Endpoints[i].S3Settings.ServiceAccessRoleArn" To sS3SettingsServiceAccessRoleArn
Get ComStringOf Of hoJResp "Endpoints[i].S3Settings.TimestampColumnName" To sTimestampColumnName
Get ComIntOf Of hoJResp "Endpoints[i].S3Settings.UseCsvNoSupValue" To iUseCsvNoSupValue
Get ComIntOf Of hoJResp "Endpoints[i].S3Settings.UseTaskStartTimeForFullLoadTimestamp" To iUseTaskStartTimeForFullLoadTimestamp
Get ComStringOf Of hoJResp "Endpoints[i].ServerName" To sServerName
Get ComStringOf Of hoJResp "Endpoints[i].ServiceAccessRoleArn" To sServiceAccessRoleArn
Get ComStringOf Of hoJResp "Endpoints[i].SslMode" To sSslMode
Get ComStringOf Of hoJResp "Endpoints[i].Status" To sStatus
Get ComStringOf Of hoJResp "Endpoints[i].SybaseSettings.DatabaseName" To sSybaseSettingsDatabaseName
Get ComStringOf Of hoJResp "Endpoints[i].SybaseSettings.Password" To sSybaseSettingsPassword
Get ComIntOf Of hoJResp "Endpoints[i].SybaseSettings.Port" To iSybaseSettingsPort
Get ComStringOf Of hoJResp "Endpoints[i].SybaseSettings.SecretsManagerAccessRoleArn" To sSybaseSettingsSecretsManagerAccessRoleArn
Get ComStringOf Of hoJResp "Endpoints[i].SybaseSettings.SecretsManagerSecretId" To sSybaseSettingsSecretsManagerSecretId
Get ComStringOf Of hoJResp "Endpoints[i].SybaseSettings.ServerName" To sSybaseSettingsServerName
Get ComStringOf Of hoJResp "Endpoints[i].SybaseSettings.Username" To sSybaseSettingsUsername
Get ComStringOf Of hoJResp "Endpoints[i].Username" To sUsername
Move 0 To j
Get ComSizeOfArray Of hoJResp "Endpoints[i].OracleSettings.ExtraArchivedLogDestIds" To iCount_j
While (j < iCount_j)
Set ComJ Of hoJResp To j
Get ComIntOf Of hoJResp "Endpoints[i].OracleSettings.ExtraArchivedLogDestIds[j]" To iIntVal
Move (j + 1) To j
Loop
Move (i + 1) To i
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"
// }
End_Procedure
