ListCertificateAuthorities 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', 'acm-pca'
-- SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
EXEC sp_OAMethod @rest, 'SetAuthAws', @success OUT, @authAws
-- URL: https://acm-pca.us-west-2.amazonaws.com/
-- Use the same region as specified above.
EXEC sp_OAMethod @rest, 'Connect', @success OUT, 'acm-pca.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, 'UpdateInt', @success OUT, 'MaxResults', 123
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'NextToken', 'string'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'ResourceOwner', 'string'
-- The JSON request body created by the above code:
-- {
-- "MaxResults": number,
-- "NextToken": "string",
-- "ResourceOwner": "string"
-- }
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', 'ACMPrivateCA.ListCertificateAuthorities'
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 @Arn nvarchar(max)
DECLARE @CRLSign int
DECLARE @DataEncipherment int
DECLARE @DecipherOnly int
DECLARE @DigitalSignature int
DECLARE @EncipherOnly int
DECLARE @KeyAgreement int
DECLARE @KeyCertSign int
DECLARE @KeyEncipherment int
DECLARE @NonRepudiation int
DECLARE @KeyAlgorithm nvarchar(max)
DECLARE @SigningAlgorithm nvarchar(max)
DECLARE @CommonName nvarchar(max)
DECLARE @Country nvarchar(max)
DECLARE @DistinguishedNameQualifier nvarchar(max)
DECLARE @GenerationQualifier nvarchar(max)
DECLARE @GivenName nvarchar(max)
DECLARE @Initials nvarchar(max)
DECLARE @Locality nvarchar(max)
DECLARE @Organization nvarchar(max)
DECLARE @OrganizationalUnit nvarchar(max)
DECLARE @Pseudonym nvarchar(max)
DECLARE @SerialNumber nvarchar(max)
DECLARE @State nvarchar(max)
DECLARE @Surname nvarchar(max)
DECLARE @Title nvarchar(max)
DECLARE @CreatedAt int
DECLARE @FailureReason nvarchar(max)
DECLARE @KeyStorageSecurityStandard nvarchar(max)
DECLARE @LastStateChangeAt int
DECLARE @NotAfter int
DECLARE @NotBefore int
DECLARE @OwnerAccount nvarchar(max)
DECLARE @RestorableUntil int
DECLARE @CustomCname nvarchar(max)
DECLARE @Enabled int
DECLARE @ExpirationInDays int
DECLARE @S3BucketName nvarchar(max)
DECLARE @S3ObjectAcl nvarchar(max)
DECLARE @OcspConfigurationEnabled int
DECLARE @OcspCustomCname nvarchar(max)
DECLARE @Serial nvarchar(max)
DECLARE @Status nvarchar(max)
DECLARE @v_Type nvarchar(max)
DECLARE @j int
DECLARE @count_j int
DECLARE @DirectoryNameCommonName nvarchar(max)
DECLARE @DirectoryNameCountry nvarchar(max)
DECLARE @DirectoryNameDistinguishedNameQualifier nvarchar(max)
DECLARE @DirectoryNameGenerationQualifier nvarchar(max)
DECLARE @DirectoryNameGivenName nvarchar(max)
DECLARE @DirectoryNameInitials nvarchar(max)
DECLARE @DirectoryNameLocality nvarchar(max)
DECLARE @DirectoryNameOrganization nvarchar(max)
DECLARE @DirectoryNameOrganizationalUnit nvarchar(max)
DECLARE @DirectoryNamePseudonym nvarchar(max)
DECLARE @DirectoryNameSerialNumber nvarchar(max)
DECLARE @DirectoryNameState nvarchar(max)
DECLARE @DirectoryNameSurname nvarchar(max)
DECLARE @DirectoryNameTitle nvarchar(max)
DECLARE @DnsName nvarchar(max)
DECLARE @NameAssigner nvarchar(max)
DECLARE @PartyName nvarchar(max)
DECLARE @IpAddress nvarchar(max)
DECLARE @TypeId nvarchar(max)
DECLARE @Value nvarchar(max)
DECLARE @RegisteredId nvarchar(max)
DECLARE @Rfc822Name nvarchar(max)
DECLARE @UniformResourceIdentifier nvarchar(max)
DECLARE @AccessMethodType nvarchar(max)
DECLARE @CustomObjectIdentifier nvarchar(max)
DECLARE @NextToken nvarchar(max)
EXEC sp_OAMethod @jResp, 'StringOf', @NextToken OUT, 'NextToken'
DECLARE @i int
SELECT @i = 0
DECLARE @count_i int
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'CertificateAuthorities'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'StringOf', @Arn OUT, 'CertificateAuthorities[i].Arn'
EXEC sp_OAMethod @jResp, 'IntOf', @CRLSign OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.KeyUsage.CRLSign'
EXEC sp_OAMethod @jResp, 'IntOf', @DataEncipherment OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.KeyUsage.DataEncipherment'
EXEC sp_OAMethod @jResp, 'IntOf', @DecipherOnly OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.KeyUsage.DecipherOnly'
EXEC sp_OAMethod @jResp, 'IntOf', @DigitalSignature OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.KeyUsage.DigitalSignature'
EXEC sp_OAMethod @jResp, 'IntOf', @EncipherOnly OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.KeyUsage.EncipherOnly'
EXEC sp_OAMethod @jResp, 'IntOf', @KeyAgreement OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.KeyUsage.KeyAgreement'
EXEC sp_OAMethod @jResp, 'IntOf', @KeyCertSign OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.KeyUsage.KeyCertSign'
EXEC sp_OAMethod @jResp, 'IntOf', @KeyEncipherment OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.KeyUsage.KeyEncipherment'
EXEC sp_OAMethod @jResp, 'IntOf', @NonRepudiation OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.KeyUsage.NonRepudiation'
EXEC sp_OAMethod @jResp, 'StringOf', @KeyAlgorithm OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.KeyAlgorithm'
EXEC sp_OAMethod @jResp, 'StringOf', @SigningAlgorithm OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.SigningAlgorithm'
EXEC sp_OAMethod @jResp, 'StringOf', @CommonName OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.Subject.CommonName'
EXEC sp_OAMethod @jResp, 'StringOf', @Country OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.Subject.Country'
EXEC sp_OAMethod @jResp, 'StringOf', @DistinguishedNameQualifier OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.Subject.DistinguishedNameQualifier'
EXEC sp_OAMethod @jResp, 'StringOf', @GenerationQualifier OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.Subject.GenerationQualifier'
EXEC sp_OAMethod @jResp, 'StringOf', @GivenName OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.Subject.GivenName'
EXEC sp_OAMethod @jResp, 'StringOf', @Initials OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.Subject.Initials'
EXEC sp_OAMethod @jResp, 'StringOf', @Locality OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.Subject.Locality'
EXEC sp_OAMethod @jResp, 'StringOf', @Organization OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.Subject.Organization'
EXEC sp_OAMethod @jResp, 'StringOf', @OrganizationalUnit OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.Subject.OrganizationalUnit'
EXEC sp_OAMethod @jResp, 'StringOf', @Pseudonym OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.Subject.Pseudonym'
EXEC sp_OAMethod @jResp, 'StringOf', @SerialNumber OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.Subject.SerialNumber'
EXEC sp_OAMethod @jResp, 'StringOf', @State OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.Subject.State'
EXEC sp_OAMethod @jResp, 'StringOf', @Surname OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.Subject.Surname'
EXEC sp_OAMethod @jResp, 'StringOf', @Title OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.Subject.Title'
EXEC sp_OAMethod @jResp, 'IntOf', @CreatedAt OUT, 'CertificateAuthorities[i].CreatedAt'
EXEC sp_OAMethod @jResp, 'StringOf', @FailureReason OUT, 'CertificateAuthorities[i].FailureReason'
EXEC sp_OAMethod @jResp, 'StringOf', @KeyStorageSecurityStandard OUT, 'CertificateAuthorities[i].KeyStorageSecurityStandard'
EXEC sp_OAMethod @jResp, 'IntOf', @LastStateChangeAt OUT, 'CertificateAuthorities[i].LastStateChangeAt'
EXEC sp_OAMethod @jResp, 'IntOf', @NotAfter OUT, 'CertificateAuthorities[i].NotAfter'
EXEC sp_OAMethod @jResp, 'IntOf', @NotBefore OUT, 'CertificateAuthorities[i].NotBefore'
EXEC sp_OAMethod @jResp, 'StringOf', @OwnerAccount OUT, 'CertificateAuthorities[i].OwnerAccount'
EXEC sp_OAMethod @jResp, 'IntOf', @RestorableUntil OUT, 'CertificateAuthorities[i].RestorableUntil'
EXEC sp_OAMethod @jResp, 'StringOf', @CustomCname OUT, 'CertificateAuthorities[i].RevocationConfiguration.CrlConfiguration.CustomCname'
EXEC sp_OAMethod @jResp, 'IntOf', @Enabled OUT, 'CertificateAuthorities[i].RevocationConfiguration.CrlConfiguration.Enabled'
EXEC sp_OAMethod @jResp, 'IntOf', @ExpirationInDays OUT, 'CertificateAuthorities[i].RevocationConfiguration.CrlConfiguration.ExpirationInDays'
EXEC sp_OAMethod @jResp, 'StringOf', @S3BucketName OUT, 'CertificateAuthorities[i].RevocationConfiguration.CrlConfiguration.S3BucketName'
EXEC sp_OAMethod @jResp, 'StringOf', @S3ObjectAcl OUT, 'CertificateAuthorities[i].RevocationConfiguration.CrlConfiguration.S3ObjectAcl'
EXEC sp_OAMethod @jResp, 'IntOf', @OcspConfigurationEnabled OUT, 'CertificateAuthorities[i].RevocationConfiguration.OcspConfiguration.Enabled'
EXEC sp_OAMethod @jResp, 'StringOf', @OcspCustomCname OUT, 'CertificateAuthorities[i].RevocationConfiguration.OcspConfiguration.OcspCustomCname'
EXEC sp_OAMethod @jResp, 'StringOf', @Serial OUT, 'CertificateAuthorities[i].Serial'
EXEC sp_OAMethod @jResp, 'StringOf', @Status OUT, 'CertificateAuthorities[i].Status'
EXEC sp_OAMethod @jResp, 'StringOf', @v_Type OUT, 'CertificateAuthorities[i].Type'
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.SubjectInformationAccess'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @DirectoryNameCommonName OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.SubjectInformationAccess[j].AccessLocation.DirectoryName.CommonName'
EXEC sp_OAMethod @jResp, 'StringOf', @DirectoryNameCountry OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.SubjectInformationAccess[j].AccessLocation.DirectoryName.Country'
EXEC sp_OAMethod @jResp, 'StringOf', @DirectoryNameDistinguishedNameQualifier OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.SubjectInformationAccess[j].AccessLocation.DirectoryName.DistinguishedNameQualifier'
EXEC sp_OAMethod @jResp, 'StringOf', @DirectoryNameGenerationQualifier OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.SubjectInformationAccess[j].AccessLocation.DirectoryName.GenerationQualifier'
EXEC sp_OAMethod @jResp, 'StringOf', @DirectoryNameGivenName OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.SubjectInformationAccess[j].AccessLocation.DirectoryName.GivenName'
EXEC sp_OAMethod @jResp, 'StringOf', @DirectoryNameInitials OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.SubjectInformationAccess[j].AccessLocation.DirectoryName.Initials'
EXEC sp_OAMethod @jResp, 'StringOf', @DirectoryNameLocality OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.SubjectInformationAccess[j].AccessLocation.DirectoryName.Locality'
EXEC sp_OAMethod @jResp, 'StringOf', @DirectoryNameOrganization OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.SubjectInformationAccess[j].AccessLocation.DirectoryName.Organization'
EXEC sp_OAMethod @jResp, 'StringOf', @DirectoryNameOrganizationalUnit OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.SubjectInformationAccess[j].AccessLocation.DirectoryName.OrganizationalUnit'
EXEC sp_OAMethod @jResp, 'StringOf', @DirectoryNamePseudonym OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.SubjectInformationAccess[j].AccessLocation.DirectoryName.Pseudonym'
EXEC sp_OAMethod @jResp, 'StringOf', @DirectoryNameSerialNumber OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.SubjectInformationAccess[j].AccessLocation.DirectoryName.SerialNumber'
EXEC sp_OAMethod @jResp, 'StringOf', @DirectoryNameState OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.SubjectInformationAccess[j].AccessLocation.DirectoryName.State'
EXEC sp_OAMethod @jResp, 'StringOf', @DirectoryNameSurname OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.SubjectInformationAccess[j].AccessLocation.DirectoryName.Surname'
EXEC sp_OAMethod @jResp, 'StringOf', @DirectoryNameTitle OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.SubjectInformationAccess[j].AccessLocation.DirectoryName.Title'
EXEC sp_OAMethod @jResp, 'StringOf', @DnsName OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.SubjectInformationAccess[j].AccessLocation.DnsName'
EXEC sp_OAMethod @jResp, 'StringOf', @NameAssigner OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.SubjectInformationAccess[j].AccessLocation.EdiPartyName.NameAssigner'
EXEC sp_OAMethod @jResp, 'StringOf', @PartyName OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.SubjectInformationAccess[j].AccessLocation.EdiPartyName.PartyName'
EXEC sp_OAMethod @jResp, 'StringOf', @IpAddress OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.SubjectInformationAccess[j].AccessLocation.IpAddress'
EXEC sp_OAMethod @jResp, 'StringOf', @TypeId OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.SubjectInformationAccess[j].AccessLocation.OtherName.TypeId'
EXEC sp_OAMethod @jResp, 'StringOf', @Value OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.SubjectInformationAccess[j].AccessLocation.OtherName.Value'
EXEC sp_OAMethod @jResp, 'StringOf', @RegisteredId OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.SubjectInformationAccess[j].AccessLocation.RegisteredId'
EXEC sp_OAMethod @jResp, 'StringOf', @Rfc822Name OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.SubjectInformationAccess[j].AccessLocation.Rfc822Name'
EXEC sp_OAMethod @jResp, 'StringOf', @UniformResourceIdentifier OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.SubjectInformationAccess[j].AccessLocation.UniformResourceIdentifier'
EXEC sp_OAMethod @jResp, 'StringOf', @AccessMethodType OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.SubjectInformationAccess[j].AccessMethod.AccessMethodType'
EXEC sp_OAMethod @jResp, 'StringOf', @CustomObjectIdentifier OUT, 'CertificateAuthorities[i].CertificateAuthorityConfiguration.CsrExtensions.SubjectInformationAccess[j].AccessMethod.CustomObjectIdentifier'
SELECT @j = @j + 1
END
SELECT @i = @i + 1
END
-- A sample JSON response body parsed by the above code:
-- {
-- "CertificateAuthorities": [
-- {
-- "Arn": "string",
-- "CertificateAuthorityConfiguration": {
-- "CsrExtensions": {
-- "KeyUsage": {
-- "CRLSign": boolean,
-- "DataEncipherment": boolean,
-- "DecipherOnly": boolean,
-- "DigitalSignature": boolean,
-- "EncipherOnly": boolean,
-- "KeyAgreement": boolean,
-- "KeyCertSign": boolean,
-- "KeyEncipherment": boolean,
-- "NonRepudiation": boolean
-- },
-- "SubjectInformationAccess": [
-- {
-- "AccessLocation": {
-- "DirectoryName": {
-- "CommonName": "string",
-- "Country": "string",
-- "DistinguishedNameQualifier": "string",
-- "GenerationQualifier": "string",
-- "GivenName": "string",
-- "Initials": "string",
-- "Locality": "string",
-- "Organization": "string",
-- "OrganizationalUnit": "string",
-- "Pseudonym": "string",
-- "SerialNumber": "string",
-- "State": "string",
-- "Surname": "string",
-- "Title": "string"
-- },
-- "DnsName": "string",
-- "EdiPartyName": {
-- "NameAssigner": "string",
-- "PartyName": "string"
-- },
-- "IpAddress": "string",
-- "OtherName": {
-- "TypeId": "string",
-- "Value": "string"
-- },
-- "RegisteredId": "string",
-- "Rfc822Name": "string",
-- "UniformResourceIdentifier": "string"
-- },
-- "AccessMethod": {
-- "AccessMethodType": "string",
-- "CustomObjectIdentifier": "string"
-- }
-- }
-- ]
-- },
-- "KeyAlgorithm": "string",
-- "SigningAlgorithm": "string",
-- "Subject": {
-- "CommonName": "string",
-- "Country": "string",
-- "DistinguishedNameQualifier": "string",
-- "GenerationQualifier": "string",
-- "GivenName": "string",
-- "Initials": "string",
-- "Locality": "string",
-- "Organization": "string",
-- "OrganizationalUnit": "string",
-- "Pseudonym": "string",
-- "SerialNumber": "string",
-- "State": "string",
-- "Surname": "string",
-- "Title": "string"
-- }
-- },
-- "CreatedAt": number,
-- "FailureReason": "string",
-- "KeyStorageSecurityStandard": "string",
-- "LastStateChangeAt": number,
-- "NotAfter": number,
-- "NotBefore": number,
-- "OwnerAccount": "string",
-- "RestorableUntil": number,
-- "RevocationConfiguration": {
-- "CrlConfiguration": {
-- "CustomCname": "string",
-- "Enabled": boolean,
-- "ExpirationInDays": number,
-- "S3BucketName": "string",
-- "S3ObjectAcl": "string"
-- },
-- "OcspConfiguration": {
-- "Enabled": boolean,
-- "OcspCustomCname": "string"
-- }
-- },
-- "Serial": "string",
-- "Status": "string",
-- "Type": "string"
-- }
-- ],
-- "NextToken": "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
