SQL Server
SQL Server
S3 List Parts
See more Amazon S3 (new) Examples
This operation lists the parts that have been uploaded for a specific multipart upload.This operation must include the upload ID, which you obtain by sending the initiate multipart upload request. This request returns a maximum of 1000 uploaded parts. The default number of parts returned is 1000 parts. You can restrict the number of parts returned by specifying the max-parts request parameter. If your multipart upload consists of more than 1000 parts, the response returns an IsTruncated field with the value of true, and a NextPartNumberMarker element. In subsequent List Parts requests you can include the part-number-marker query string parameter and set its value to the NextPartNumberMarker field value from the previous response.
This example sends GET request that looks like this:
GET /example-object?uploadId=XXBsb2FkIElEIGZvciBlbHZpbmcncyVcdS1tb3ZpZS5tMnRzEEEwbG9hZA&max-parts=100&part-number-marker=1 HTTP/1.1 Host: example-bucket.s3.amazonaws.com Date: Mon, 1 Nov 2010 20:34:56 GMT Authorization: authorization string
The following is a sample response:
HTTP/1.1 200 OK
x-amz-id-2: Uuag1LuByRx9e6j5Onimru9pO4ZVKnJ2Qz7/C1NPcfTWAtRPfTaOFg==
x-amz-request-id: 656c76696e6727732072657175657374
Date: Mon, 1 Nov 2010 20:34:56 GMT
Content-Length: 985
Connection: keep-alive
Server: AmazonS3
<?xml version="1.0" encoding="UTF-8"?>
<ListPartsResult xmlns="http://s3.amazonaws.com/doc/2006-03-01/">
<Bucket>example-bucket</Bucket>
<Key>example-object</Key>
<UploadId>XXBsb2FkIElEIGZvciBlbHZpbmcncyVcdS1tb3ZpZS5tMnRzEEEwbG9hZA</UploadId>
<Initiator>
<ID>arn:aws:iam::111122223333:user/some-user-11116a31-17b5-4fb7-9df5-b288870f11xx</ID>
<DisplayName>umat-user-11116a31-17b5-4fb7-9df5-b288870f11xx</DisplayName>
</Initiator>
<Owner>
<ID>75aa57f09aa0c8caeab4f8c24e99d10f8e7faeebf76c078efc7c6caea54ba06a</ID>
<DisplayName>someName</DisplayName>
</Owner>
<StorageClass>STANDARD</StorageClass>
<PartNumberMarker>1</PartNumberMarker>
<NextPartNumberMarker>3</NextPartNumberMarker>
<MaxParts>2</MaxParts>
<IsTruncated>true</IsTruncated>
<Part>
<PartNumber>2</PartNumber>
<LastModified>2010-11-10T20:48:34.000Z</LastModified>
<ETag>"7778aef83f66abc1fa1e8477f296d394"</ETag>
<Size>10485760</Size>
</Part>
<Part>
<PartNumber>3</PartNumber>
<LastModified>2010-11-10T20:48:33.000Z</LastModified>
<ETag>"aaaa18db4cc2f85cedef654fccc4a4x8"</ETag>
<Size>10485760</Size>
</Part>
</ListPartsResult>
Chilkat SQL Server Downloads
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
DECLARE @hr int
DECLARE @iTmp0 int
-- Important: Do not use nvarchar(max). See the warning about using nvarchar(max).
DECLARE @sTmp0 nvarchar(4000)
DECLARE @success int
SELECT @success = 0
-- This example requires the Chilkat API to have been previously unlocked.
-- See Global Unlock Sample for sample code.
-- Other S3 Multipart Upload Examples:
-- Initiate Multipart Upload
-- S3 Upload Parts
-- Complete Multipart Upload
-- Abort Multipart Upload
-- When the multipart upload was initiated, an UploadId was provided in the XML response, and
-- we saved it to a file. We'll get the upload ID from there..
DECLARE @xmlInit int
EXEC @hr = sp_OACreate 'Chilkat.Xml', @xmlInit OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
EXEC sp_OAMethod @xmlInit, 'LoadXmlFile', @success OUT, 's3_multipart_uploads/initiate.xml'
IF @success <> 1
BEGIN
PRINT 'Did not find the initiate.xml XML file.'
EXEC @hr = sp_OADestroy @xmlInit
RETURN
END
DECLARE @uploadId nvarchar(4000)
EXEC sp_OAMethod @xmlInit, 'GetChildContent', @uploadId OUT, 'UploadId'
PRINT 'UploadId = ' + @uploadId
DECLARE @rest int
EXEC @hr = sp_OACreate 'Chilkat.Rest', @rest OUT
-- Connect to the Amazon AWS REST server.
DECLARE @bTls int
SELECT @bTls = 1
DECLARE @port int
SELECT @port = 443
DECLARE @bAutoReconnect int
SELECT @bAutoReconnect = 1
EXEC sp_OAMethod @rest, 'Connect', @success OUT, 's3.amazonaws.com', @port, @bTls, @bAutoReconnect
-- ----------------------------------------------------------------------------
-- Important: For buckets created in regions outside us-east-1,
-- there are three important changes that need to be made.
-- See Working with S3 Buckets in Non-us-east-1 Regions for the details.
-- ----------------------------------------------------------------------------
-- Provide AWS credentials for the REST call.
DECLARE @authAws int
EXEC @hr = sp_OACreate 'Chilkat.AuthAws', @authAws OUT
EXEC sp_OASetProperty @authAws, 'AccessKey', 'AWS_ACCESS_KEY'
EXEC sp_OASetProperty @authAws, 'SecretKey', 'AWS_SECRET_KEY'
EXEC sp_OASetProperty @authAws, 'ServiceName', 's3'
EXEC sp_OAMethod @rest, 'SetAuthAws', @success OUT, @authAws
-- Set the bucket name via the HOST header.
-- In this case, the bucket name is "chilkat100".
EXEC sp_OASetProperty @rest, 'Host', 'chilkat100.s3.amazonaws.com'
-- Add the query parameters.
EXEC sp_OAMethod @rest, 'AddQueryParam', @success OUT, 'uploadId', @uploadId
EXEC sp_OAMethod @rest, 'AddQueryParam', @success OUT, 'max-parts', '100'
EXEC sp_OAMethod @rest, 'AddQueryParam', @success OUT, 'part-number-marker', '0'
-- Our ObjectName in this case is "somethingBig.zip".
DECLARE @responseXml nvarchar(4000)
EXEC sp_OAMethod @rest, 'FullRequestNoBody', @responseXml OUT, 'GET', '/somethingBig.zip'
EXEC sp_OAGetProperty @rest, 'LastMethodSuccess', @iTmp0 OUT
IF @iTmp0 <> 1
BEGIN
EXEC sp_OAGetProperty @rest, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @xmlInit
EXEC @hr = sp_OADestroy @rest
EXEC @hr = sp_OADestroy @authAws
RETURN
END
-- When successful, the S3 Storage service will respond with a 200 response code,
-- with an XML body.
EXEC sp_OAGetProperty @rest, 'ResponseStatusCode', @iTmp0 OUT
IF @iTmp0 <> 200
BEGIN
-- Examine the request/response to see what happened.
EXEC sp_OAGetProperty @rest, 'ResponseStatusCode', @iTmp0 OUT
PRINT 'response status code = ' + @iTmp0
EXEC sp_OAGetProperty @rest, 'ResponseStatusText', @sTmp0 OUT
PRINT 'response status text = ' + @sTmp0
EXEC sp_OAGetProperty @rest, 'ResponseHeader', @sTmp0 OUT
PRINT 'response header: ' + @sTmp0
PRINT 'response body: ' + @responseXml
PRINT '---'
EXEC sp_OAGetProperty @rest, 'LastRequestStartLine', @sTmp0 OUT
PRINT 'LastRequestStartLine: ' + @sTmp0
EXEC sp_OAGetProperty @rest, 'LastRequestHeader', @sTmp0 OUT
PRINT 'LastRequestHeader: ' + @sTmp0
END
DECLARE @xml int
EXEC @hr = sp_OACreate 'Chilkat.Xml', @xml OUT
EXEC sp_OAMethod @xml, 'LoadXml', @success OUT, @responseXml
EXEC sp_OAMethod @xml, 'GetXml', @sTmp0 OUT
PRINT @sTmp0
PRINT '----'
-- To iterate over the parts in the response, navigate to the 1st "Part" node
-- and then iterate over siblings until there are no more.
DECLARE @part int
EXEC sp_OAMethod @xml, 'FindChild', @part OUT, 'Part'
EXEC sp_OAGetProperty @xml, 'LastMethodSuccess', @iTmp0 OUT
IF @iTmp0 = 0
BEGIN
PRINT 'No parts exist.'
EXEC @hr = sp_OADestroy @xmlInit
EXEC @hr = sp_OADestroy @rest
EXEC @hr = sp_OADestroy @authAws
EXEC @hr = sp_OADestroy @xml
RETURN
END
DECLARE @hasMoreParts int
SELECT @hasMoreParts = 1
WHILE @hasMoreParts = 1
BEGIN
EXEC sp_OAMethod @part, 'GetChildContent', @sTmp0 OUT, 'PartNumber'
PRINT 'PartNumber: ' + @sTmp0
EXEC sp_OAMethod @part, 'GetChildContent', @sTmp0 OUT, 'LastModified'
PRINT 'LastModified: ' + @sTmp0
EXEC sp_OAMethod @part, 'GetChildContent', @sTmp0 OUT, 'ETag'
PRINT 'ETag: ' + @sTmp0
EXEC sp_OAMethod @part, 'GetChildContent', @sTmp0 OUT, 'Size'
PRINT 'Size: ' + @sTmp0
PRINT '----'
-- Advance to the next sibling until we run out.
EXEC sp_OAMethod @part, 'NextSibling2', @hasMoreParts OUT
END
EXEC @hr = sp_OADestroy @part
EXEC @hr = sp_OADestroy @xmlInit
EXEC @hr = sp_OADestroy @rest
EXEC @hr = sp_OADestroy @authAws
EXEC @hr = sp_OADestroy @xml
END
GO