DescribeDeliveryStream 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', 'firehose'
-- SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
EXEC sp_OAMethod @rest, 'SetAuthAws', @success OUT, @authAws
-- URL: https://firehose.us-west-2.amazonaws.com/
-- Use the same region as specified above.
EXEC sp_OAMethod @rest, 'Connect', @success OUT, 'firehose.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, 'DeliveryStreamName', 'string'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'ExclusiveStartDestinationId', 'string'
EXEC sp_OAMethod @json, 'UpdateInt', @success OUT, 'Limit', 123
-- The JSON request body created by the above code:
-- {
-- "DeliveryStreamName": "string",
-- "ExclusiveStartDestinationId": "string",
-- "Limit": 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', 'Firehose_20150804.DescribeDeliveryStream'
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 @IntervalInSeconds int
DECLARE @SizeInMBs int
DECLARE @Enabled int
DECLARE @LogGroupName nvarchar(max)
DECLARE @LogStreamName nvarchar(max)
DECLARE @ClusterEndpoint nvarchar(max)
DECLARE @DomainARN nvarchar(max)
DECLARE @IndexName nvarchar(max)
DECLARE @IndexRotationPeriod nvarchar(max)
DECLARE @ProcessingConfigurationEnabled int
DECLARE @DurationInSeconds int
DECLARE @AmazonopensearchserviceDestinationDescriptionRoleARN nvarchar(max)
DECLARE @S3BackupMode nvarchar(max)
DECLARE @BucketARN nvarchar(max)
DECLARE @BufferingHintsIntervalInSeconds int
DECLARE @BufferingHintsSizeInMBs int
DECLARE @CloudWatchLoggingOptionsEnabled int
DECLARE @CloudWatchLoggingOptionsLogGroupName nvarchar(max)
DECLARE @CloudWatchLoggingOptionsLogStreamName nvarchar(max)
DECLARE @CompressionFormat nvarchar(max)
DECLARE @AWSKMSKeyARN nvarchar(max)
DECLARE @NoEncryptionConfig nvarchar(max)
DECLARE @ErrorOutputPrefix nvarchar(max)
DECLARE @Prefix nvarchar(max)
DECLARE @S3DestinationDescriptionRoleARN nvarchar(max)
DECLARE @TypeName nvarchar(max)
DECLARE @VpcConfigurationDescriptionRoleARN nvarchar(max)
DECLARE @VpcId nvarchar(max)
DECLARE @DestinationId nvarchar(max)
DECLARE @ElasticsearchDestinationDescriptionClusterEndpoint nvarchar(max)
DECLARE @ElasticsearchDestinationDescriptionDomainARN nvarchar(max)
DECLARE @ElasticsearchDestinationDescriptionIndexName nvarchar(max)
DECLARE @ElasticsearchDestinationDescriptionIndexRotationPeriod nvarchar(max)
DECLARE @RetryOptionsDurationInSeconds int
DECLARE @ElasticsearchDestinationDescriptionRoleARN nvarchar(max)
DECLARE @ElasticsearchDestinationDescriptionS3BackupMode nvarchar(max)
DECLARE @S3DestinationDescriptionBucketARN nvarchar(max)
DECLARE @S3DestinationDescriptionCompressionFormat nvarchar(max)
DECLARE @KMSEncryptionConfigAWSKMSKeyARN nvarchar(max)
DECLARE @EncryptionConfigurationNoEncryptionConfig nvarchar(max)
DECLARE @S3DestinationDescriptionErrorOutputPrefix nvarchar(max)
DECLARE @S3DestinationDescriptionPrefix nvarchar(max)
DECLARE @ElasticsearchDestinationDescriptionTypeName nvarchar(max)
DECLARE @VpcConfigurationDescriptionVpcId nvarchar(max)
DECLARE @ExtendedS3DestinationDescriptionBucketARN nvarchar(max)
DECLARE @ExtendedS3DestinationDescriptionCompressionFormat nvarchar(max)
DECLARE @DataFormatConversionConfigurationEnabled int
DECLARE @CaseInsensitive int
DECLARE @v_String nvarchar(max)
DECLARE @ConvertDotsInJsonKeysToUnderscores int
DECLARE @BlockSizeBytes int
DECLARE @BloomFilterFalsePositiveProbability int
DECLARE @v_Compression nvarchar(max)
DECLARE @DictionaryKeyThreshold int
DECLARE @EnablePadding int
DECLARE @FormatVersion nvarchar(max)
DECLARE @PaddingTolerance int
DECLARE @RowIndexStride int
DECLARE @StripeSizeBytes int
DECLARE @ParquetSerDeBlockSizeBytes int
DECLARE @ParquetSerDeCompression nvarchar(max)
DECLARE @EnableDictionaryCompression int
DECLARE @MaxPaddingBytes int
DECLARE @PageSizeBytes int
DECLARE @WriterVersion nvarchar(max)
DECLARE @CatalogId nvarchar(max)
DECLARE @DatabaseName nvarchar(max)
DECLARE @Region nvarchar(max)
DECLARE @SchemaConfigurationRoleARN nvarchar(max)
DECLARE @TableName nvarchar(max)
DECLARE @SchemaConfigurationVersionId nvarchar(max)
DECLARE @DynamicPartitioningConfigurationEnabled int
DECLARE @ExtendedS3DestinationDescriptionErrorOutputPrefix nvarchar(max)
DECLARE @ExtendedS3DestinationDescriptionPrefix nvarchar(max)
DECLARE @ExtendedS3DestinationDescriptionRoleARN nvarchar(max)
DECLARE @S3BackupDescriptionBucketARN nvarchar(max)
DECLARE @S3BackupDescriptionCompressionFormat nvarchar(max)
DECLARE @S3BackupDescriptionErrorOutputPrefix nvarchar(max)
DECLARE @S3BackupDescriptionPrefix nvarchar(max)
DECLARE @S3BackupDescriptionRoleARN nvarchar(max)
DECLARE @ExtendedS3DestinationDescriptionS3BackupMode nvarchar(max)
DECLARE @Name nvarchar(max)
DECLARE @v_Url nvarchar(max)
DECLARE @ContentEncoding nvarchar(max)
DECLARE @HttpEndpointDestinationDescriptionRoleARN nvarchar(max)
DECLARE @HttpEndpointDestinationDescriptionS3BackupMode nvarchar(max)
DECLARE @ClusterJDBCURL nvarchar(max)
DECLARE @CopyOptions nvarchar(max)
DECLARE @DataTableColumns nvarchar(max)
DECLARE @DataTableName nvarchar(max)
DECLARE @RedshiftDestinationDescriptionRoleARN nvarchar(max)
DECLARE @RedshiftDestinationDescriptionS3BackupMode nvarchar(max)
DECLARE @Username nvarchar(max)
DECLARE @HECAcknowledgmentTimeoutInSeconds int
DECLARE @HECEndpoint nvarchar(max)
DECLARE @HECEndpointType nvarchar(max)
DECLARE @HECToken nvarchar(max)
DECLARE @SplunkDestinationDescriptionS3BackupMode nvarchar(max)
DECLARE @j int
DECLARE @count_j int
DECLARE @k int
DECLARE @count_k int
DECLARE @ParameterName nvarchar(max)
DECLARE @ParameterValue nvarchar(max)
DECLARE @strVal nvarchar(max)
DECLARE @AttributeName nvarchar(max)
DECLARE @AttributeValue nvarchar(max)
DECLARE @CreateTimestamp int
EXEC sp_OAMethod @jResp, 'IntOf', @CreateTimestamp OUT, 'DeliveryStreamDescription.CreateTimestamp'
DECLARE @DeliveryStreamARN nvarchar(max)
EXEC sp_OAMethod @jResp, 'StringOf', @DeliveryStreamARN OUT, 'DeliveryStreamDescription.DeliveryStreamARN'
DECLARE @Details nvarchar(max)
EXEC sp_OAMethod @jResp, 'StringOf', @Details OUT, 'DeliveryStreamDescription.DeliveryStreamEncryptionConfiguration.FailureDescription.Details'
DECLARE @v_Type nvarchar(max)
EXEC sp_OAMethod @jResp, 'StringOf', @v_Type OUT, 'DeliveryStreamDescription.DeliveryStreamEncryptionConfiguration.FailureDescription.Type'
DECLARE @KeyARN nvarchar(max)
EXEC sp_OAMethod @jResp, 'StringOf', @KeyARN OUT, 'DeliveryStreamDescription.DeliveryStreamEncryptionConfiguration.KeyARN'
DECLARE @KeyType nvarchar(max)
EXEC sp_OAMethod @jResp, 'StringOf', @KeyType OUT, 'DeliveryStreamDescription.DeliveryStreamEncryptionConfiguration.KeyType'
DECLARE @Status nvarchar(max)
EXEC sp_OAMethod @jResp, 'StringOf', @Status OUT, 'DeliveryStreamDescription.DeliveryStreamEncryptionConfiguration.Status'
DECLARE @DeliveryStreamName nvarchar(max)
EXEC sp_OAMethod @jResp, 'StringOf', @DeliveryStreamName OUT, 'DeliveryStreamDescription.DeliveryStreamName'
DECLARE @DeliveryStreamStatus nvarchar(max)
EXEC sp_OAMethod @jResp, 'StringOf', @DeliveryStreamStatus OUT, 'DeliveryStreamDescription.DeliveryStreamStatus'
DECLARE @DeliveryStreamType nvarchar(max)
EXEC sp_OAMethod @jResp, 'StringOf', @DeliveryStreamType OUT, 'DeliveryStreamDescription.DeliveryStreamType'
DECLARE @FailureDescriptionDetails nvarchar(max)
EXEC sp_OAMethod @jResp, 'StringOf', @FailureDescriptionDetails OUT, 'DeliveryStreamDescription.FailureDescription.Details'
DECLARE @FailureDescriptionType nvarchar(max)
EXEC sp_OAMethod @jResp, 'StringOf', @FailureDescriptionType OUT, 'DeliveryStreamDescription.FailureDescription.Type'
DECLARE @HasMoreDestinations int
EXEC sp_OAMethod @jResp, 'IntOf', @HasMoreDestinations OUT, 'DeliveryStreamDescription.HasMoreDestinations'
DECLARE @LastUpdateTimestamp int
EXEC sp_OAMethod @jResp, 'IntOf', @LastUpdateTimestamp OUT, 'DeliveryStreamDescription.LastUpdateTimestamp'
DECLARE @DeliveryStartTimestamp int
EXEC sp_OAMethod @jResp, 'IntOf', @DeliveryStartTimestamp OUT, 'DeliveryStreamDescription.Source.KinesisStreamSourceDescription.DeliveryStartTimestamp'
DECLARE @KinesisStreamARN nvarchar(max)
EXEC sp_OAMethod @jResp, 'StringOf', @KinesisStreamARN OUT, 'DeliveryStreamDescription.Source.KinesisStreamSourceDescription.KinesisStreamARN'
DECLARE @RoleARN nvarchar(max)
EXEC sp_OAMethod @jResp, 'StringOf', @RoleARN OUT, 'DeliveryStreamDescription.Source.KinesisStreamSourceDescription.RoleARN'
DECLARE @VersionId nvarchar(max)
EXEC sp_OAMethod @jResp, 'StringOf', @VersionId OUT, 'DeliveryStreamDescription.VersionId'
DECLARE @i int
SELECT @i = 0
DECLARE @count_i int
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'DeliveryStreamDescription.Destinations'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'IntOf', @IntervalInSeconds OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.BufferingHints.IntervalInSeconds'
EXEC sp_OAMethod @jResp, 'IntOf', @SizeInMBs OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.BufferingHints.SizeInMBs'
EXEC sp_OAMethod @jResp, 'IntOf', @Enabled OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.CloudWatchLoggingOptions.Enabled'
EXEC sp_OAMethod @jResp, 'StringOf', @LogGroupName OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.CloudWatchLoggingOptions.LogGroupName'
EXEC sp_OAMethod @jResp, 'StringOf', @LogStreamName OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.CloudWatchLoggingOptions.LogStreamName'
EXEC sp_OAMethod @jResp, 'StringOf', @ClusterEndpoint OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.ClusterEndpoint'
EXEC sp_OAMethod @jResp, 'StringOf', @DomainARN OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.DomainARN'
EXEC sp_OAMethod @jResp, 'StringOf', @IndexName OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.IndexName'
EXEC sp_OAMethod @jResp, 'StringOf', @IndexRotationPeriod OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.IndexRotationPeriod'
EXEC sp_OAMethod @jResp, 'IntOf', @ProcessingConfigurationEnabled OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.ProcessingConfiguration.Enabled'
EXEC sp_OAMethod @jResp, 'IntOf', @DurationInSeconds OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.RetryOptions.DurationInSeconds'
EXEC sp_OAMethod @jResp, 'StringOf', @AmazonopensearchserviceDestinationDescriptionRoleARN OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.RoleARN'
EXEC sp_OAMethod @jResp, 'StringOf', @S3BackupMode OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.S3BackupMode'
EXEC sp_OAMethod @jResp, 'StringOf', @BucketARN OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.S3DestinationDescription.BucketARN'
EXEC sp_OAMethod @jResp, 'IntOf', @BufferingHintsIntervalInSeconds OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.S3DestinationDescription.BufferingHints.IntervalInSeconds'
EXEC sp_OAMethod @jResp, 'IntOf', @BufferingHintsSizeInMBs OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.S3DestinationDescription.BufferingHints.SizeInMBs'
EXEC sp_OAMethod @jResp, 'IntOf', @CloudWatchLoggingOptionsEnabled OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.S3DestinationDescription.CloudWatchLoggingOptions.Enabled'
EXEC sp_OAMethod @jResp, 'StringOf', @CloudWatchLoggingOptionsLogGroupName OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.S3DestinationDescription.CloudWatchLoggingOptions.LogGroupName'
EXEC sp_OAMethod @jResp, 'StringOf', @CloudWatchLoggingOptionsLogStreamName OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.S3DestinationDescription.CloudWatchLoggingOptions.LogStreamName'
EXEC sp_OAMethod @jResp, 'StringOf', @CompressionFormat OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.S3DestinationDescription.CompressionFormat'
EXEC sp_OAMethod @jResp, 'StringOf', @AWSKMSKeyARN OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.S3DestinationDescription.EncryptionConfiguration.KMSEncryptionConfig.AWSKMSKeyARN'
EXEC sp_OAMethod @jResp, 'StringOf', @NoEncryptionConfig OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.S3DestinationDescription.EncryptionConfiguration.NoEncryptionConfig'
EXEC sp_OAMethod @jResp, 'StringOf', @ErrorOutputPrefix OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.S3DestinationDescription.ErrorOutputPrefix'
EXEC sp_OAMethod @jResp, 'StringOf', @Prefix OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.S3DestinationDescription.Prefix'
EXEC sp_OAMethod @jResp, 'StringOf', @S3DestinationDescriptionRoleARN OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.S3DestinationDescription.RoleARN'
EXEC sp_OAMethod @jResp, 'StringOf', @TypeName OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.TypeName'
EXEC sp_OAMethod @jResp, 'StringOf', @VpcConfigurationDescriptionRoleARN OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.VpcConfigurationDescription.RoleARN'
EXEC sp_OAMethod @jResp, 'StringOf', @VpcId OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.VpcConfigurationDescription.VpcId'
EXEC sp_OAMethod @jResp, 'StringOf', @DestinationId OUT, 'DeliveryStreamDescription.Destinations[i].DestinationId'
EXEC sp_OAMethod @jResp, 'IntOf', @BufferingHintsIntervalInSeconds OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.BufferingHints.IntervalInSeconds'
EXEC sp_OAMethod @jResp, 'IntOf', @BufferingHintsSizeInMBs OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.BufferingHints.SizeInMBs'
EXEC sp_OAMethod @jResp, 'IntOf', @CloudWatchLoggingOptionsEnabled OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.CloudWatchLoggingOptions.Enabled'
EXEC sp_OAMethod @jResp, 'StringOf', @CloudWatchLoggingOptionsLogGroupName OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.CloudWatchLoggingOptions.LogGroupName'
EXEC sp_OAMethod @jResp, 'StringOf', @CloudWatchLoggingOptionsLogStreamName OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.CloudWatchLoggingOptions.LogStreamName'
EXEC sp_OAMethod @jResp, 'StringOf', @ElasticsearchDestinationDescriptionClusterEndpoint OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.ClusterEndpoint'
EXEC sp_OAMethod @jResp, 'StringOf', @ElasticsearchDestinationDescriptionDomainARN OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.DomainARN'
EXEC sp_OAMethod @jResp, 'StringOf', @ElasticsearchDestinationDescriptionIndexName OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.IndexName'
EXEC sp_OAMethod @jResp, 'StringOf', @ElasticsearchDestinationDescriptionIndexRotationPeriod OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.IndexRotationPeriod'
EXEC sp_OAMethod @jResp, 'IntOf', @ProcessingConfigurationEnabled OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.ProcessingConfiguration.Enabled'
EXEC sp_OAMethod @jResp, 'IntOf', @RetryOptionsDurationInSeconds OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.RetryOptions.DurationInSeconds'
EXEC sp_OAMethod @jResp, 'StringOf', @ElasticsearchDestinationDescriptionRoleARN OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.RoleARN'
EXEC sp_OAMethod @jResp, 'StringOf', @ElasticsearchDestinationDescriptionS3BackupMode OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.S3BackupMode'
EXEC sp_OAMethod @jResp, 'StringOf', @S3DestinationDescriptionBucketARN OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.S3DestinationDescription.BucketARN'
EXEC sp_OAMethod @jResp, 'IntOf', @BufferingHintsIntervalInSeconds OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.S3DestinationDescription.BufferingHints.IntervalInSeconds'
EXEC sp_OAMethod @jResp, 'IntOf', @BufferingHintsSizeInMBs OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.S3DestinationDescription.BufferingHints.SizeInMBs'
EXEC sp_OAMethod @jResp, 'IntOf', @CloudWatchLoggingOptionsEnabled OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.S3DestinationDescription.CloudWatchLoggingOptions.Enabled'
EXEC sp_OAMethod @jResp, 'StringOf', @CloudWatchLoggingOptionsLogGroupName OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.S3DestinationDescription.CloudWatchLoggingOptions.LogGroupName'
EXEC sp_OAMethod @jResp, 'StringOf', @CloudWatchLoggingOptionsLogStreamName OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.S3DestinationDescription.CloudWatchLoggingOptions.LogStreamName'
EXEC sp_OAMethod @jResp, 'StringOf', @S3DestinationDescriptionCompressionFormat OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.S3DestinationDescription.CompressionFormat'
EXEC sp_OAMethod @jResp, 'StringOf', @KMSEncryptionConfigAWSKMSKeyARN OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.S3DestinationDescription.EncryptionConfiguration.KMSEncryptionConfig.AWSKMSKeyARN'
EXEC sp_OAMethod @jResp, 'StringOf', @EncryptionConfigurationNoEncryptionConfig OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.S3DestinationDescription.EncryptionConfiguration.NoEncryptionConfig'
EXEC sp_OAMethod @jResp, 'StringOf', @S3DestinationDescriptionErrorOutputPrefix OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.S3DestinationDescription.ErrorOutputPrefix'
EXEC sp_OAMethod @jResp, 'StringOf', @S3DestinationDescriptionPrefix OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.S3DestinationDescription.Prefix'
EXEC sp_OAMethod @jResp, 'StringOf', @S3DestinationDescriptionRoleARN OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.S3DestinationDescription.RoleARN'
EXEC sp_OAMethod @jResp, 'StringOf', @ElasticsearchDestinationDescriptionTypeName OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.TypeName'
EXEC sp_OAMethod @jResp, 'StringOf', @VpcConfigurationDescriptionRoleARN OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.VpcConfigurationDescription.RoleARN'
EXEC sp_OAMethod @jResp, 'StringOf', @VpcConfigurationDescriptionVpcId OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.VpcConfigurationDescription.VpcId'
EXEC sp_OAMethod @jResp, 'StringOf', @ExtendedS3DestinationDescriptionBucketARN OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.BucketARN'
EXEC sp_OAMethod @jResp, 'IntOf', @BufferingHintsIntervalInSeconds OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.BufferingHints.IntervalInSeconds'
EXEC sp_OAMethod @jResp, 'IntOf', @BufferingHintsSizeInMBs OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.BufferingHints.SizeInMBs'
EXEC sp_OAMethod @jResp, 'IntOf', @CloudWatchLoggingOptionsEnabled OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.CloudWatchLoggingOptions.Enabled'
EXEC sp_OAMethod @jResp, 'StringOf', @CloudWatchLoggingOptionsLogGroupName OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.CloudWatchLoggingOptions.LogGroupName'
EXEC sp_OAMethod @jResp, 'StringOf', @CloudWatchLoggingOptionsLogStreamName OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.CloudWatchLoggingOptions.LogStreamName'
EXEC sp_OAMethod @jResp, 'StringOf', @ExtendedS3DestinationDescriptionCompressionFormat OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.CompressionFormat'
EXEC sp_OAMethod @jResp, 'IntOf', @DataFormatConversionConfigurationEnabled OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.Enabled'
EXEC sp_OAMethod @jResp, 'IntOf', @CaseInsensitive OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.InputFormatConfiguration.Deserializer.OpenXJsonSerDe.CaseInsensitive'
EXEC sp_OAMethod @jResp, 'StringOf', @v_String OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.InputFormatConfiguration.Deserializer.OpenXJsonSerDe.ColumnToJsonKeyMappings.string'
EXEC sp_OAMethod @jResp, 'IntOf', @ConvertDotsInJsonKeysToUnderscores OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.InputFormatConfiguration.Deserializer.OpenXJsonSerDe.ConvertDotsInJsonKeysToUnderscores'
EXEC sp_OAMethod @jResp, 'IntOf', @BlockSizeBytes OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.OutputFormatConfiguration.Serializer.OrcSerDe.BlockSizeBytes'
EXEC sp_OAMethod @jResp, 'IntOf', @BloomFilterFalsePositiveProbability OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.OutputFormatConfiguration.Serializer.OrcSerDe.BloomFilterFalsePositiveProbability'
EXEC sp_OAMethod @jResp, 'StringOf', @v_Compression OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.OutputFormatConfiguration.Serializer.OrcSerDe.Compression'
EXEC sp_OAMethod @jResp, 'IntOf', @DictionaryKeyThreshold OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.OutputFormatConfiguration.Serializer.OrcSerDe.DictionaryKeyThreshold'
EXEC sp_OAMethod @jResp, 'IntOf', @EnablePadding OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.OutputFormatConfiguration.Serializer.OrcSerDe.EnablePadding'
EXEC sp_OAMethod @jResp, 'StringOf', @FormatVersion OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.OutputFormatConfiguration.Serializer.OrcSerDe.FormatVersion'
EXEC sp_OAMethod @jResp, 'IntOf', @PaddingTolerance OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.OutputFormatConfiguration.Serializer.OrcSerDe.PaddingTolerance'
EXEC sp_OAMethod @jResp, 'IntOf', @RowIndexStride OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.OutputFormatConfiguration.Serializer.OrcSerDe.RowIndexStride'
EXEC sp_OAMethod @jResp, 'IntOf', @StripeSizeBytes OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.OutputFormatConfiguration.Serializer.OrcSerDe.StripeSizeBytes'
EXEC sp_OAMethod @jResp, 'IntOf', @ParquetSerDeBlockSizeBytes OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.OutputFormatConfiguration.Serializer.ParquetSerDe.BlockSizeBytes'
EXEC sp_OAMethod @jResp, 'StringOf', @ParquetSerDeCompression OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.OutputFormatConfiguration.Serializer.ParquetSerDe.Compression'
EXEC sp_OAMethod @jResp, 'IntOf', @EnableDictionaryCompression OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.OutputFormatConfiguration.Serializer.ParquetSerDe.EnableDictionaryCompression'
EXEC sp_OAMethod @jResp, 'IntOf', @MaxPaddingBytes OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.OutputFormatConfiguration.Serializer.ParquetSerDe.MaxPaddingBytes'
EXEC sp_OAMethod @jResp, 'IntOf', @PageSizeBytes OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.OutputFormatConfiguration.Serializer.ParquetSerDe.PageSizeBytes'
EXEC sp_OAMethod @jResp, 'StringOf', @WriterVersion OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.OutputFormatConfiguration.Serializer.ParquetSerDe.WriterVersion'
EXEC sp_OAMethod @jResp, 'StringOf', @CatalogId OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.SchemaConfiguration.CatalogId'
EXEC sp_OAMethod @jResp, 'StringOf', @DatabaseName OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.SchemaConfiguration.DatabaseName'
EXEC sp_OAMethod @jResp, 'StringOf', @Region OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.SchemaConfiguration.Region'
EXEC sp_OAMethod @jResp, 'StringOf', @SchemaConfigurationRoleARN OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.SchemaConfiguration.RoleARN'
EXEC sp_OAMethod @jResp, 'StringOf', @TableName OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.SchemaConfiguration.TableName'
EXEC sp_OAMethod @jResp, 'StringOf', @SchemaConfigurationVersionId OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.SchemaConfiguration.VersionId'
EXEC sp_OAMethod @jResp, 'IntOf', @DynamicPartitioningConfigurationEnabled OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DynamicPartitioningConfiguration.Enabled'
EXEC sp_OAMethod @jResp, 'IntOf', @RetryOptionsDurationInSeconds OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DynamicPartitioningConfiguration.RetryOptions.DurationInSeconds'
EXEC sp_OAMethod @jResp, 'StringOf', @KMSEncryptionConfigAWSKMSKeyARN OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.EncryptionConfiguration.KMSEncryptionConfig.AWSKMSKeyARN'
EXEC sp_OAMethod @jResp, 'StringOf', @EncryptionConfigurationNoEncryptionConfig OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.EncryptionConfiguration.NoEncryptionConfig'
EXEC sp_OAMethod @jResp, 'StringOf', @ExtendedS3DestinationDescriptionErrorOutputPrefix OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.ErrorOutputPrefix'
EXEC sp_OAMethod @jResp, 'StringOf', @ExtendedS3DestinationDescriptionPrefix OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.Prefix'
EXEC sp_OAMethod @jResp, 'IntOf', @ProcessingConfigurationEnabled OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.ProcessingConfiguration.Enabled'
EXEC sp_OAMethod @jResp, 'StringOf', @ExtendedS3DestinationDescriptionRoleARN OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.RoleARN'
EXEC sp_OAMethod @jResp, 'StringOf', @S3BackupDescriptionBucketARN OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.S3BackupDescription.BucketARN'
EXEC sp_OAMethod @jResp, 'IntOf', @BufferingHintsIntervalInSeconds OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.S3BackupDescription.BufferingHints.IntervalInSeconds'
EXEC sp_OAMethod @jResp, 'IntOf', @BufferingHintsSizeInMBs OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.S3BackupDescription.BufferingHints.SizeInMBs'
EXEC sp_OAMethod @jResp, 'IntOf', @CloudWatchLoggingOptionsEnabled OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.S3BackupDescription.CloudWatchLoggingOptions.Enabled'
EXEC sp_OAMethod @jResp, 'StringOf', @CloudWatchLoggingOptionsLogGroupName OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.S3BackupDescription.CloudWatchLoggingOptions.LogGroupName'
EXEC sp_OAMethod @jResp, 'StringOf', @CloudWatchLoggingOptionsLogStreamName OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.S3BackupDescription.CloudWatchLoggingOptions.LogStreamName'
EXEC sp_OAMethod @jResp, 'StringOf', @S3BackupDescriptionCompressionFormat OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.S3BackupDescription.CompressionFormat'
EXEC sp_OAMethod @jResp, 'StringOf', @KMSEncryptionConfigAWSKMSKeyARN OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.S3BackupDescription.EncryptionConfiguration.KMSEncryptionConfig.AWSKMSKeyARN'
EXEC sp_OAMethod @jResp, 'StringOf', @EncryptionConfigurationNoEncryptionConfig OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.S3BackupDescription.EncryptionConfiguration.NoEncryptionConfig'
EXEC sp_OAMethod @jResp, 'StringOf', @S3BackupDescriptionErrorOutputPrefix OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.S3BackupDescription.ErrorOutputPrefix'
EXEC sp_OAMethod @jResp, 'StringOf', @S3BackupDescriptionPrefix OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.S3BackupDescription.Prefix'
EXEC sp_OAMethod @jResp, 'StringOf', @S3BackupDescriptionRoleARN OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.S3BackupDescription.RoleARN'
EXEC sp_OAMethod @jResp, 'StringOf', @ExtendedS3DestinationDescriptionS3BackupMode OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.S3BackupMode'
EXEC sp_OAMethod @jResp, 'IntOf', @BufferingHintsIntervalInSeconds OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.BufferingHints.IntervalInSeconds'
EXEC sp_OAMethod @jResp, 'IntOf', @BufferingHintsSizeInMBs OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.BufferingHints.SizeInMBs'
EXEC sp_OAMethod @jResp, 'IntOf', @CloudWatchLoggingOptionsEnabled OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.CloudWatchLoggingOptions.Enabled'
EXEC sp_OAMethod @jResp, 'StringOf', @CloudWatchLoggingOptionsLogGroupName OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.CloudWatchLoggingOptions.LogGroupName'
EXEC sp_OAMethod @jResp, 'StringOf', @CloudWatchLoggingOptionsLogStreamName OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.CloudWatchLoggingOptions.LogStreamName'
EXEC sp_OAMethod @jResp, 'StringOf', @Name OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.EndpointConfiguration.Name'
EXEC sp_OAMethod @jResp, 'StringOf', @v_Url OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.EndpointConfiguration.Url'
EXEC sp_OAMethod @jResp, 'IntOf', @ProcessingConfigurationEnabled OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.ProcessingConfiguration.Enabled'
EXEC sp_OAMethod @jResp, 'StringOf', @ContentEncoding OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.RequestConfiguration.ContentEncoding'
EXEC sp_OAMethod @jResp, 'IntOf', @RetryOptionsDurationInSeconds OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.RetryOptions.DurationInSeconds'
EXEC sp_OAMethod @jResp, 'StringOf', @HttpEndpointDestinationDescriptionRoleARN OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.RoleARN'
EXEC sp_OAMethod @jResp, 'StringOf', @HttpEndpointDestinationDescriptionS3BackupMode OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.S3BackupMode'
EXEC sp_OAMethod @jResp, 'StringOf', @S3DestinationDescriptionBucketARN OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.S3DestinationDescription.BucketARN'
EXEC sp_OAMethod @jResp, 'IntOf', @BufferingHintsIntervalInSeconds OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.S3DestinationDescription.BufferingHints.IntervalInSeconds'
EXEC sp_OAMethod @jResp, 'IntOf', @BufferingHintsSizeInMBs OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.S3DestinationDescription.BufferingHints.SizeInMBs'
EXEC sp_OAMethod @jResp, 'IntOf', @CloudWatchLoggingOptionsEnabled OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.S3DestinationDescription.CloudWatchLoggingOptions.Enabled'
EXEC sp_OAMethod @jResp, 'StringOf', @CloudWatchLoggingOptionsLogGroupName OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.S3DestinationDescription.CloudWatchLoggingOptions.LogGroupName'
EXEC sp_OAMethod @jResp, 'StringOf', @CloudWatchLoggingOptionsLogStreamName OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.S3DestinationDescription.CloudWatchLoggingOptions.LogStreamName'
EXEC sp_OAMethod @jResp, 'StringOf', @S3DestinationDescriptionCompressionFormat OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.S3DestinationDescription.CompressionFormat'
EXEC sp_OAMethod @jResp, 'StringOf', @KMSEncryptionConfigAWSKMSKeyARN OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.S3DestinationDescription.EncryptionConfiguration.KMSEncryptionConfig.AWSKMSKeyARN'
EXEC sp_OAMethod @jResp, 'StringOf', @EncryptionConfigurationNoEncryptionConfig OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.S3DestinationDescription.EncryptionConfiguration.NoEncryptionConfig'
EXEC sp_OAMethod @jResp, 'StringOf', @S3DestinationDescriptionErrorOutputPrefix OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.S3DestinationDescription.ErrorOutputPrefix'
EXEC sp_OAMethod @jResp, 'StringOf', @S3DestinationDescriptionPrefix OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.S3DestinationDescription.Prefix'
EXEC sp_OAMethod @jResp, 'StringOf', @S3DestinationDescriptionRoleARN OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.S3DestinationDescription.RoleARN'
EXEC sp_OAMethod @jResp, 'IntOf', @CloudWatchLoggingOptionsEnabled OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.CloudWatchLoggingOptions.Enabled'
EXEC sp_OAMethod @jResp, 'StringOf', @CloudWatchLoggingOptionsLogGroupName OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.CloudWatchLoggingOptions.LogGroupName'
EXEC sp_OAMethod @jResp, 'StringOf', @CloudWatchLoggingOptionsLogStreamName OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.CloudWatchLoggingOptions.LogStreamName'
EXEC sp_OAMethod @jResp, 'StringOf', @ClusterJDBCURL OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.ClusterJDBCURL'
EXEC sp_OAMethod @jResp, 'StringOf', @CopyOptions OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.CopyCommand.CopyOptions'
EXEC sp_OAMethod @jResp, 'StringOf', @DataTableColumns OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.CopyCommand.DataTableColumns'
EXEC sp_OAMethod @jResp, 'StringOf', @DataTableName OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.CopyCommand.DataTableName'
EXEC sp_OAMethod @jResp, 'IntOf', @ProcessingConfigurationEnabled OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.ProcessingConfiguration.Enabled'
EXEC sp_OAMethod @jResp, 'IntOf', @RetryOptionsDurationInSeconds OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.RetryOptions.DurationInSeconds'
EXEC sp_OAMethod @jResp, 'StringOf', @RedshiftDestinationDescriptionRoleARN OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.RoleARN'
EXEC sp_OAMethod @jResp, 'StringOf', @S3BackupDescriptionBucketARN OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.S3BackupDescription.BucketARN'
EXEC sp_OAMethod @jResp, 'IntOf', @BufferingHintsIntervalInSeconds OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.S3BackupDescription.BufferingHints.IntervalInSeconds'
EXEC sp_OAMethod @jResp, 'IntOf', @BufferingHintsSizeInMBs OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.S3BackupDescription.BufferingHints.SizeInMBs'
EXEC sp_OAMethod @jResp, 'IntOf', @CloudWatchLoggingOptionsEnabled OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.S3BackupDescription.CloudWatchLoggingOptions.Enabled'
EXEC sp_OAMethod @jResp, 'StringOf', @CloudWatchLoggingOptionsLogGroupName OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.S3BackupDescription.CloudWatchLoggingOptions.LogGroupName'
EXEC sp_OAMethod @jResp, 'StringOf', @CloudWatchLoggingOptionsLogStreamName OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.S3BackupDescription.CloudWatchLoggingOptions.LogStreamName'
EXEC sp_OAMethod @jResp, 'StringOf', @S3BackupDescriptionCompressionFormat OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.S3BackupDescription.CompressionFormat'
EXEC sp_OAMethod @jResp, 'StringOf', @KMSEncryptionConfigAWSKMSKeyARN OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.S3BackupDescription.EncryptionConfiguration.KMSEncryptionConfig.AWSKMSKeyARN'
EXEC sp_OAMethod @jResp, 'StringOf', @EncryptionConfigurationNoEncryptionConfig OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.S3BackupDescription.EncryptionConfiguration.NoEncryptionConfig'
EXEC sp_OAMethod @jResp, 'StringOf', @S3BackupDescriptionErrorOutputPrefix OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.S3BackupDescription.ErrorOutputPrefix'
EXEC sp_OAMethod @jResp, 'StringOf', @S3BackupDescriptionPrefix OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.S3BackupDescription.Prefix'
EXEC sp_OAMethod @jResp, 'StringOf', @S3BackupDescriptionRoleARN OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.S3BackupDescription.RoleARN'
EXEC sp_OAMethod @jResp, 'StringOf', @RedshiftDestinationDescriptionS3BackupMode OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.S3BackupMode'
EXEC sp_OAMethod @jResp, 'StringOf', @S3DestinationDescriptionBucketARN OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.S3DestinationDescription.BucketARN'
EXEC sp_OAMethod @jResp, 'IntOf', @BufferingHintsIntervalInSeconds OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.S3DestinationDescription.BufferingHints.IntervalInSeconds'
EXEC sp_OAMethod @jResp, 'IntOf', @BufferingHintsSizeInMBs OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.S3DestinationDescription.BufferingHints.SizeInMBs'
EXEC sp_OAMethod @jResp, 'IntOf', @CloudWatchLoggingOptionsEnabled OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.S3DestinationDescription.CloudWatchLoggingOptions.Enabled'
EXEC sp_OAMethod @jResp, 'StringOf', @CloudWatchLoggingOptionsLogGroupName OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.S3DestinationDescription.CloudWatchLoggingOptions.LogGroupName'
EXEC sp_OAMethod @jResp, 'StringOf', @CloudWatchLoggingOptionsLogStreamName OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.S3DestinationDescription.CloudWatchLoggingOptions.LogStreamName'
EXEC sp_OAMethod @jResp, 'StringOf', @S3DestinationDescriptionCompressionFormat OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.S3DestinationDescription.CompressionFormat'
EXEC sp_OAMethod @jResp, 'StringOf', @KMSEncryptionConfigAWSKMSKeyARN OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.S3DestinationDescription.EncryptionConfiguration.KMSEncryptionConfig.AWSKMSKeyARN'
EXEC sp_OAMethod @jResp, 'StringOf', @EncryptionConfigurationNoEncryptionConfig OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.S3DestinationDescription.EncryptionConfiguration.NoEncryptionConfig'
EXEC sp_OAMethod @jResp, 'StringOf', @S3DestinationDescriptionErrorOutputPrefix OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.S3DestinationDescription.ErrorOutputPrefix'
EXEC sp_OAMethod @jResp, 'StringOf', @S3DestinationDescriptionPrefix OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.S3DestinationDescription.Prefix'
EXEC sp_OAMethod @jResp, 'StringOf', @S3DestinationDescriptionRoleARN OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.S3DestinationDescription.RoleARN'
EXEC sp_OAMethod @jResp, 'StringOf', @Username OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.Username'
EXEC sp_OAMethod @jResp, 'StringOf', @S3DestinationDescriptionBucketARN OUT, 'DeliveryStreamDescription.Destinations[i].S3DestinationDescription.BucketARN'
EXEC sp_OAMethod @jResp, 'IntOf', @BufferingHintsIntervalInSeconds OUT, 'DeliveryStreamDescription.Destinations[i].S3DestinationDescription.BufferingHints.IntervalInSeconds'
EXEC sp_OAMethod @jResp, 'IntOf', @BufferingHintsSizeInMBs OUT, 'DeliveryStreamDescription.Destinations[i].S3DestinationDescription.BufferingHints.SizeInMBs'
EXEC sp_OAMethod @jResp, 'IntOf', @CloudWatchLoggingOptionsEnabled OUT, 'DeliveryStreamDescription.Destinations[i].S3DestinationDescription.CloudWatchLoggingOptions.Enabled'
EXEC sp_OAMethod @jResp, 'StringOf', @CloudWatchLoggingOptionsLogGroupName OUT, 'DeliveryStreamDescription.Destinations[i].S3DestinationDescription.CloudWatchLoggingOptions.LogGroupName'
EXEC sp_OAMethod @jResp, 'StringOf', @CloudWatchLoggingOptionsLogStreamName OUT, 'DeliveryStreamDescription.Destinations[i].S3DestinationDescription.CloudWatchLoggingOptions.LogStreamName'
EXEC sp_OAMethod @jResp, 'StringOf', @S3DestinationDescriptionCompressionFormat OUT, 'DeliveryStreamDescription.Destinations[i].S3DestinationDescription.CompressionFormat'
EXEC sp_OAMethod @jResp, 'StringOf', @KMSEncryptionConfigAWSKMSKeyARN OUT, 'DeliveryStreamDescription.Destinations[i].S3DestinationDescription.EncryptionConfiguration.KMSEncryptionConfig.AWSKMSKeyARN'
EXEC sp_OAMethod @jResp, 'StringOf', @EncryptionConfigurationNoEncryptionConfig OUT, 'DeliveryStreamDescription.Destinations[i].S3DestinationDescription.EncryptionConfiguration.NoEncryptionConfig'
EXEC sp_OAMethod @jResp, 'StringOf', @S3DestinationDescriptionErrorOutputPrefix OUT, 'DeliveryStreamDescription.Destinations[i].S3DestinationDescription.ErrorOutputPrefix'
EXEC sp_OAMethod @jResp, 'StringOf', @S3DestinationDescriptionPrefix OUT, 'DeliveryStreamDescription.Destinations[i].S3DestinationDescription.Prefix'
EXEC sp_OAMethod @jResp, 'StringOf', @S3DestinationDescriptionRoleARN OUT, 'DeliveryStreamDescription.Destinations[i].S3DestinationDescription.RoleARN'
EXEC sp_OAMethod @jResp, 'IntOf', @CloudWatchLoggingOptionsEnabled OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.CloudWatchLoggingOptions.Enabled'
EXEC sp_OAMethod @jResp, 'StringOf', @CloudWatchLoggingOptionsLogGroupName OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.CloudWatchLoggingOptions.LogGroupName'
EXEC sp_OAMethod @jResp, 'StringOf', @CloudWatchLoggingOptionsLogStreamName OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.CloudWatchLoggingOptions.LogStreamName'
EXEC sp_OAMethod @jResp, 'IntOf', @HECAcknowledgmentTimeoutInSeconds OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.HECAcknowledgmentTimeoutInSeconds'
EXEC sp_OAMethod @jResp, 'StringOf', @HECEndpoint OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.HECEndpoint'
EXEC sp_OAMethod @jResp, 'StringOf', @HECEndpointType OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.HECEndpointType'
EXEC sp_OAMethod @jResp, 'StringOf', @HECToken OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.HECToken'
EXEC sp_OAMethod @jResp, 'IntOf', @ProcessingConfigurationEnabled OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.ProcessingConfiguration.Enabled'
EXEC sp_OAMethod @jResp, 'IntOf', @RetryOptionsDurationInSeconds OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.RetryOptions.DurationInSeconds'
EXEC sp_OAMethod @jResp, 'StringOf', @SplunkDestinationDescriptionS3BackupMode OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.S3BackupMode'
EXEC sp_OAMethod @jResp, 'StringOf', @S3DestinationDescriptionBucketARN OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.S3DestinationDescription.BucketARN'
EXEC sp_OAMethod @jResp, 'IntOf', @BufferingHintsIntervalInSeconds OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.S3DestinationDescription.BufferingHints.IntervalInSeconds'
EXEC sp_OAMethod @jResp, 'IntOf', @BufferingHintsSizeInMBs OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.S3DestinationDescription.BufferingHints.SizeInMBs'
EXEC sp_OAMethod @jResp, 'IntOf', @CloudWatchLoggingOptionsEnabled OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.S3DestinationDescription.CloudWatchLoggingOptions.Enabled'
EXEC sp_OAMethod @jResp, 'StringOf', @CloudWatchLoggingOptionsLogGroupName OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.S3DestinationDescription.CloudWatchLoggingOptions.LogGroupName'
EXEC sp_OAMethod @jResp, 'StringOf', @CloudWatchLoggingOptionsLogStreamName OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.S3DestinationDescription.CloudWatchLoggingOptions.LogStreamName'
EXEC sp_OAMethod @jResp, 'StringOf', @S3DestinationDescriptionCompressionFormat OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.S3DestinationDescription.CompressionFormat'
EXEC sp_OAMethod @jResp, 'StringOf', @KMSEncryptionConfigAWSKMSKeyARN OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.S3DestinationDescription.EncryptionConfiguration.KMSEncryptionConfig.AWSKMSKeyARN'
EXEC sp_OAMethod @jResp, 'StringOf', @EncryptionConfigurationNoEncryptionConfig OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.S3DestinationDescription.EncryptionConfiguration.NoEncryptionConfig'
EXEC sp_OAMethod @jResp, 'StringOf', @S3DestinationDescriptionErrorOutputPrefix OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.S3DestinationDescription.ErrorOutputPrefix'
EXEC sp_OAMethod @jResp, 'StringOf', @S3DestinationDescriptionPrefix OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.S3DestinationDescription.Prefix'
EXEC sp_OAMethod @jResp, 'StringOf', @S3DestinationDescriptionRoleARN OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.S3DestinationDescription.RoleARN'
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.ProcessingConfiguration.Processors'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @v_Type OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.ProcessingConfiguration.Processors[j].Type'
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.ProcessingConfiguration.Processors[j].Parameters'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @ParameterName OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.ProcessingConfiguration.Processors[j].Parameters[k].ParameterName'
EXEC sp_OAMethod @jResp, 'StringOf', @ParameterValue OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.ProcessingConfiguration.Processors[j].Parameters[k].ParameterValue'
SELECT @k = @k + 1
END
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.VpcConfigurationDescription.SecurityGroupIds'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.VpcConfigurationDescription.SecurityGroupIds[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.VpcConfigurationDescription.SubnetIds'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'DeliveryStreamDescription.Destinations[i].AmazonopensearchserviceDestinationDescription.VpcConfigurationDescription.SubnetIds[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.ProcessingConfiguration.Processors'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @v_Type OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.ProcessingConfiguration.Processors[j].Type'
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.ProcessingConfiguration.Processors[j].Parameters'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @ParameterName OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.ProcessingConfiguration.Processors[j].Parameters[k].ParameterName'
EXEC sp_OAMethod @jResp, 'StringOf', @ParameterValue OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.ProcessingConfiguration.Processors[j].Parameters[k].ParameterValue'
SELECT @k = @k + 1
END
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.VpcConfigurationDescription.SecurityGroupIds'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.VpcConfigurationDescription.SecurityGroupIds[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.VpcConfigurationDescription.SubnetIds'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'DeliveryStreamDescription.Destinations[i].ElasticsearchDestinationDescription.VpcConfigurationDescription.SubnetIds[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.InputFormatConfiguration.Deserializer.HiveJsonSerDe.TimestampFormats'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.InputFormatConfiguration.Deserializer.HiveJsonSerDe.TimestampFormats[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.OutputFormatConfiguration.Serializer.OrcSerDe.BloomFilterColumns'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.DataFormatConversionConfiguration.OutputFormatConfiguration.Serializer.OrcSerDe.BloomFilterColumns[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.ProcessingConfiguration.Processors'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @v_Type OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.ProcessingConfiguration.Processors[j].Type'
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.ProcessingConfiguration.Processors[j].Parameters'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @ParameterName OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.ProcessingConfiguration.Processors[j].Parameters[k].ParameterName'
EXEC sp_OAMethod @jResp, 'StringOf', @ParameterValue OUT, 'DeliveryStreamDescription.Destinations[i].ExtendedS3DestinationDescription.ProcessingConfiguration.Processors[j].Parameters[k].ParameterValue'
SELECT @k = @k + 1
END
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.ProcessingConfiguration.Processors'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @v_Type OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.ProcessingConfiguration.Processors[j].Type'
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.ProcessingConfiguration.Processors[j].Parameters'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @ParameterName OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.ProcessingConfiguration.Processors[j].Parameters[k].ParameterName'
EXEC sp_OAMethod @jResp, 'StringOf', @ParameterValue OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.ProcessingConfiguration.Processors[j].Parameters[k].ParameterValue'
SELECT @k = @k + 1
END
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.RequestConfiguration.CommonAttributes'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @AttributeName OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.RequestConfiguration.CommonAttributes[j].AttributeName'
EXEC sp_OAMethod @jResp, 'StringOf', @AttributeValue OUT, 'DeliveryStreamDescription.Destinations[i].HttpEndpointDestinationDescription.RequestConfiguration.CommonAttributes[j].AttributeValue'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.ProcessingConfiguration.Processors'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @v_Type OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.ProcessingConfiguration.Processors[j].Type'
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.ProcessingConfiguration.Processors[j].Parameters'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @ParameterName OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.ProcessingConfiguration.Processors[j].Parameters[k].ParameterName'
EXEC sp_OAMethod @jResp, 'StringOf', @ParameterValue OUT, 'DeliveryStreamDescription.Destinations[i].RedshiftDestinationDescription.ProcessingConfiguration.Processors[j].Parameters[k].ParameterValue'
SELECT @k = @k + 1
END
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.ProcessingConfiguration.Processors'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @v_Type OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.ProcessingConfiguration.Processors[j].Type'
SELECT @k = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_k OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.ProcessingConfiguration.Processors[j].Parameters'
WHILE @k < @count_k
BEGIN
EXEC sp_OASetProperty @jResp, 'K', @k
EXEC sp_OAMethod @jResp, 'StringOf', @ParameterName OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.ProcessingConfiguration.Processors[j].Parameters[k].ParameterName'
EXEC sp_OAMethod @jResp, 'StringOf', @ParameterValue OUT, 'DeliveryStreamDescription.Destinations[i].SplunkDestinationDescription.ProcessingConfiguration.Processors[j].Parameters[k].ParameterValue'
SELECT @k = @k + 1
END
SELECT @j = @j + 1
END
SELECT @i = @i + 1
END
-- A sample JSON response body parsed by the above code:
-- {
-- "DeliveryStreamDescription": {
-- "CreateTimestamp": number,
-- "DeliveryStreamARN": "string",
-- "DeliveryStreamEncryptionConfiguration": {
-- "FailureDescription": {
-- "Details": "string",
-- "Type": "string"
-- },
-- "KeyARN": "string",
-- "KeyType": "string",
-- "Status": "string"
-- },
-- "DeliveryStreamName": "string",
-- "DeliveryStreamStatus": "string",
-- "DeliveryStreamType": "string",
-- "Destinations": [
-- {
-- "AmazonopensearchserviceDestinationDescription": {
-- "BufferingHints": {
-- "IntervalInSeconds": number,
-- "SizeInMBs": number
-- },
-- "CloudWatchLoggingOptions": {
-- "Enabled": boolean,
-- "LogGroupName": "string",
-- "LogStreamName": "string"
-- },
-- "ClusterEndpoint": "string",
-- "DomainARN": "string",
-- "IndexName": "string",
-- "IndexRotationPeriod": "string",
-- "ProcessingConfiguration": {
-- "Enabled": boolean,
-- "Processors": [
-- {
-- "Parameters": [
-- {
-- "ParameterName": "string",
-- "ParameterValue": "string"
-- }
-- ],
-- "Type": "string"
-- }
-- ]
-- },
-- "RetryOptions": {
-- "DurationInSeconds": number
-- },
-- "RoleARN": "string",
-- "S3BackupMode": "string",
-- "S3DestinationDescription": {
-- "BucketARN": "string",
-- "BufferingHints": {
-- "IntervalInSeconds": number,
-- "SizeInMBs": number
-- },
-- "CloudWatchLoggingOptions": {
-- "Enabled": boolean,
-- "LogGroupName": "string",
-- "LogStreamName": "string"
-- },
-- "CompressionFormat": "string",
-- "EncryptionConfiguration": {
-- "KMSEncryptionConfig": {
-- "AWSKMSKeyARN": "string"
-- },
-- "NoEncryptionConfig": "string"
-- },
-- "ErrorOutputPrefix": "string",
-- "Prefix": "string",
-- "RoleARN": "string"
-- },
-- "TypeName": "string",
-- "VpcConfigurationDescription": {
-- "RoleARN": "string",
-- "SecurityGroupIds": [
-- "string"
-- ],
-- "SubnetIds": [
-- "string"
-- ],
-- "VpcId": "string"
-- }
-- },
-- "DestinationId": "string",
-- "ElasticsearchDestinationDescription": {
-- "BufferingHints": {
-- "IntervalInSeconds": number,
-- "SizeInMBs": number
-- },
-- "CloudWatchLoggingOptions": {
-- "Enabled": boolean,
-- "LogGroupName": "string",
-- "LogStreamName": "string"
-- },
-- "ClusterEndpoint": "string",
-- "DomainARN": "string",
-- "IndexName": "string",
-- "IndexRotationPeriod": "string",
-- "ProcessingConfiguration": {
-- "Enabled": boolean,
-- "Processors": [
-- {
-- "Parameters": [
-- {
-- "ParameterName": "string",
-- "ParameterValue": "string"
-- }
-- ],
-- "Type": "string"
-- }
-- ]
-- },
-- "RetryOptions": {
-- "DurationInSeconds": number
-- },
-- "RoleARN": "string",
-- "S3BackupMode": "string",
-- "S3DestinationDescription": {
-- "BucketARN": "string",
-- "BufferingHints": {
-- "IntervalInSeconds": number,
-- "SizeInMBs": number
-- },
-- "CloudWatchLoggingOptions": {
-- "Enabled": boolean,
-- "LogGroupName": "string",
-- "LogStreamName": "string"
-- },
-- "CompressionFormat": "string",
-- "EncryptionConfiguration": {
-- "KMSEncryptionConfig": {
-- "AWSKMSKeyARN": "string"
-- },
-- "NoEncryptionConfig": "string"
-- },
-- "ErrorOutputPrefix": "string",
-- "Prefix": "string",
-- "RoleARN": "string"
-- },
-- "TypeName": "string",
-- "VpcConfigurationDescription": {
-- "RoleARN": "string",
-- "SecurityGroupIds": [
-- "string"
-- ],
-- "SubnetIds": [
-- "string"
-- ],
-- "VpcId": "string"
-- }
-- },
-- "ExtendedS3DestinationDescription": {
-- "BucketARN": "string",
-- "BufferingHints": {
-- "IntervalInSeconds": number,
-- "SizeInMBs": number
-- },
-- "CloudWatchLoggingOptions": {
-- "Enabled": boolean,
-- "LogGroupName": "string",
-- "LogStreamName": "string"
-- },
-- "CompressionFormat": "string",
-- "DataFormatConversionConfiguration": {
-- "Enabled": boolean,
-- "InputFormatConfiguration": {
-- "Deserializer": {
-- "HiveJsonSerDe": {
-- "TimestampFormats": [
-- "string"
-- ]
-- },
-- "OpenXJsonSerDe": {
-- "CaseInsensitive": boolean,
-- "ColumnToJsonKeyMappings": {
-- "string": "string"
-- },
-- "ConvertDotsInJsonKeysToUnderscores": boolean
-- }
-- }
-- },
-- "OutputFormatConfiguration": {
-- "Serializer": {
-- "OrcSerDe": {
-- "BlockSizeBytes": number,
-- "BloomFilterColumns": [
-- "string"
-- ],
-- "BloomFilterFalsePositiveProbability": number,
-- "Compression": "string",
-- "DictionaryKeyThreshold": number,
-- "EnablePadding": boolean,
-- "FormatVersion": "string",
-- "PaddingTolerance": number,
-- "RowIndexStride": number,
-- "StripeSizeBytes": number
-- },
-- "ParquetSerDe": {
-- "BlockSizeBytes": number,
-- "Compression": "string",
-- "EnableDictionaryCompression": boolean,
-- "MaxPaddingBytes": number,
-- "PageSizeBytes": number,
-- "WriterVersion": "string"
-- }
-- }
-- },
-- "SchemaConfiguration": {
-- "CatalogId": "string",
-- "DatabaseName": "string",
-- "Region": "string",
-- "RoleARN": "string",
-- "TableName": "string",
-- "VersionId": "string"
-- }
-- },
-- "DynamicPartitioningConfiguration": {
-- "Enabled": boolean,
-- "RetryOptions": {
-- "DurationInSeconds": number
-- }
-- },
-- "EncryptionConfiguration": {
-- "KMSEncryptionConfig": {
-- "AWSKMSKeyARN": "string"
-- },
-- "NoEncryptionConfig": "string"
-- },
-- "ErrorOutputPrefix": "string",
-- "Prefix": "string",
-- "ProcessingConfiguration": {
-- "Enabled": boolean,
-- "Processors": [
-- {
-- "Parameters": [
-- {
-- "ParameterName": "string",
-- "ParameterValue": "string"
-- }
-- ],
-- "Type": "string"
-- }
-- ]
-- },
-- "RoleARN": "string",
-- "S3BackupDescription": {
-- "BucketARN": "string",
-- "BufferingHints": {
-- "IntervalInSeconds": number,
-- "SizeInMBs": number
-- },
-- "CloudWatchLoggingOptions": {
-- "Enabled": boolean,
-- "LogGroupName": "string",
-- "LogStreamName": "string"
-- },
-- "CompressionFormat": "string",
-- "EncryptionConfiguration": {
-- "KMSEncryptionConfig": {
-- "AWSKMSKeyARN": "string"
-- },
-- "NoEncryptionConfig": "string"
-- },
-- "ErrorOutputPrefix": "string",
-- "Prefix": "string",
-- "RoleARN": "string"
-- },
-- "S3BackupMode": "string"
-- },
-- "HttpEndpointDestinationDescription": {
-- "BufferingHints": {
-- "IntervalInSeconds": number,
-- "SizeInMBs": number
-- },
-- "CloudWatchLoggingOptions": {
-- "Enabled": boolean,
-- "LogGroupName": "string",
-- "LogStreamName": "string"
-- },
-- "EndpointConfiguration": {
-- "Name": "string",
-- "Url": "string"
-- },
-- "ProcessingConfiguration": {
-- "Enabled": boolean,
-- "Processors": [
-- {
-- "Parameters": [
-- {
-- "ParameterName": "string",
-- "ParameterValue": "string"
-- }
-- ],
-- "Type": "string"
-- }
-- ]
-- },
-- "RequestConfiguration": {
-- "CommonAttributes": [
-- {
-- "AttributeName": "string",
-- "AttributeValue": "string"
-- }
-- ],
-- "ContentEncoding": "string"
-- },
-- "RetryOptions": {
-- "DurationInSeconds": number
-- },
-- "RoleARN": "string",
-- "S3BackupMode": "string",
-- "S3DestinationDescription": {
-- "BucketARN": "string",
-- "BufferingHints": {
-- "IntervalInSeconds": number,
-- "SizeInMBs": number
-- },
-- "CloudWatchLoggingOptions": {
-- "Enabled": boolean,
-- "LogGroupName": "string",
-- "LogStreamName": "string"
-- },
-- "CompressionFormat": "string",
-- "EncryptionConfiguration": {
-- "KMSEncryptionConfig": {
-- "AWSKMSKeyARN": "string"
-- },
-- "NoEncryptionConfig": "string"
-- },
-- "ErrorOutputPrefix": "string",
-- "Prefix": "string",
-- "RoleARN": "string"
-- }
-- },
-- "RedshiftDestinationDescription": {
-- "CloudWatchLoggingOptions": {
-- "Enabled": boolean,
-- "LogGroupName": "string",
-- "LogStreamName": "string"
-- },
-- "ClusterJDBCURL": "string",
-- "CopyCommand": {
-- "CopyOptions": "string",
-- "DataTableColumns": "string",
-- "DataTableName": "string"
-- },
-- "ProcessingConfiguration": {
-- "Enabled": boolean,
-- "Processors": [
-- {
-- "Parameters": [
-- {
-- "ParameterName": "string",
-- "ParameterValue": "string"
-- }
-- ],
-- "Type": "string"
-- }
-- ]
-- },
-- "RetryOptions": {
-- "DurationInSeconds": number
-- },
-- "RoleARN": "string",
-- "S3BackupDescription": {
-- "BucketARN": "string",
-- "BufferingHints": {
-- "IntervalInSeconds": number,
-- "SizeInMBs": number
-- },
-- "CloudWatchLoggingOptions": {
-- "Enabled": boolean,
-- "LogGroupName": "string",
-- "LogStreamName": "string"
-- },
-- "CompressionFormat": "string",
-- "EncryptionConfiguration": {
-- "KMSEncryptionConfig": {
-- "AWSKMSKeyARN": "string"
-- },
-- "NoEncryptionConfig": "string"
-- },
-- "ErrorOutputPrefix": "string",
-- "Prefix": "string",
-- "RoleARN": "string"
-- },
-- "S3BackupMode": "string",
-- "S3DestinationDescription": {
-- "BucketARN": "string",
-- "BufferingHints": {
-- "IntervalInSeconds": number,
-- "SizeInMBs": number
-- },
-- "CloudWatchLoggingOptions": {
-- "Enabled": boolean,
-- "LogGroupName": "string",
-- "LogStreamName": "string"
-- },
-- "CompressionFormat": "string",
-- "EncryptionConfiguration": {
-- "KMSEncryptionConfig": {
-- "AWSKMSKeyARN": "string"
-- },
-- "NoEncryptionConfig": "string"
-- },
-- "ErrorOutputPrefix": "string",
-- "Prefix": "string",
-- "RoleARN": "string"
-- },
-- "Username": "string"
-- },
-- "S3DestinationDescription": {
-- "BucketARN": "string",
-- "BufferingHints": {
-- "IntervalInSeconds": number,
-- "SizeInMBs": number
-- },
-- "CloudWatchLoggingOptions": {
-- "Enabled": boolean,
-- "LogGroupName": "string",
-- "LogStreamName": "string"
-- },
-- "CompressionFormat": "string",
-- "EncryptionConfiguration": {
-- "KMSEncryptionConfig": {
-- "AWSKMSKeyARN": "string"
-- },
-- "NoEncryptionConfig": "string"
-- },
-- "ErrorOutputPrefix": "string",
-- "Prefix": "string",
-- "RoleARN": "string"
-- },
-- "SplunkDestinationDescription": {
-- "CloudWatchLoggingOptions": {
-- "Enabled": boolean,
-- "LogGroupName": "string",
-- "LogStreamName": "string"
-- },
-- "HECAcknowledgmentTimeoutInSeconds": number,
-- "HECEndpoint": "string",
-- "HECEndpointType": "string",
-- "HECToken": "string",
-- "ProcessingConfiguration": {
-- "Enabled": boolean,
-- "Processors": [
-- {
-- "Parameters": [
-- {
-- "ParameterName": "string",
-- "ParameterValue": "string"
-- }
-- ],
-- "Type": "string"
-- }
-- ]
-- },
-- "RetryOptions": {
-- "DurationInSeconds": number
-- },
-- "S3BackupMode": "string",
-- "S3DestinationDescription": {
-- "BucketARN": "string",
-- "BufferingHints": {
-- "IntervalInSeconds": number,
-- "SizeInMBs": number
-- },
-- "CloudWatchLoggingOptions": {
-- "Enabled": boolean,
-- "LogGroupName": "string",
-- "LogStreamName": "string"
-- },
-- "CompressionFormat": "string",
-- "EncryptionConfiguration": {
-- "KMSEncryptionConfig": {
-- "AWSKMSKeyARN": "string"
-- },
-- "NoEncryptionConfig": "string"
-- },
-- "ErrorOutputPrefix": "string",
-- "Prefix": "string",
-- "RoleARN": "string"
-- }
-- }
-- }
-- ],
-- "FailureDescription": {
-- "Details": "string",
-- "Type": "string"
-- },
-- "HasMoreDestinations": boolean,
-- "LastUpdateTimestamp": number,
-- "Source": {
-- "KinesisStreamSourceDescription": {
-- "DeliveryStartTimestamp": number,
-- "KinesisStreamARN": "string",
-- "RoleARN": "string"
-- }
-- },
-- "VersionId": "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
