Excel Add-In for IBM Cloud Object Storage

Build 24.0.9062

Objects

Returns information for objects inside a specific bucket.

Table Specific Information

Select

The 本製品 will use the IBM Cloud Object Storage API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.

  • Bucket supports the '=, IN' comparisons.
  • Key supports the '=, LIKE' comparisons.

For example, the following queries are processed server side:

SELECT * FROM Objects WHERE Bucket = 'testBucket' 

SELECT * FROM Objects WHERE Bucket IN ('testBucket', 'testBucket2') 

SELECT * FROM Objects WHERE Key LIKE 'ad%'

Columns

Name Type Description
Key [KEY] String Name of the object.
Size String Size of the object.
Etag String Etag of the object.
StorageClass String Storage class of the object.
LastModified Datetime Date the object was last modified.
Bucket [KEY] String Bucket in which the object is located.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062