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