Chilkat Online Tools

DescribeDatastore Powershell Example

AWS IoT Analytics

Add-Type -Path "C:\chilkat\ChilkatDotNet47-9.5.0-x64\ChilkatDotNet47.dll"

# This example requires the Chilkat API to have been previously unlocked.
# See Global Unlock Sample for sample code.

$rest = New-Object Chilkat.Rest

$authAws = New-Object Chilkat.AuthAws
$authAws.AccessKey = "AWS_ACCESS_KEY"
$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.)
$authAws.Region = "us-west-2"
$authAws.ServiceName = "iotanalytics"
# SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
$rest.SetAuthAws($authAws)

# URL: https://iotanalytics.us-west-2.amazonaws.com/
# Use the same region as specified above.
$success = $rest.Connect("iotanalytics.us-west-2.amazonaws.com",443,$true,$true)
if ($success -ne $true) {
    $("ConnectFailReason: " + $rest.ConnectFailReason)
    $($rest.LastErrorText)
    exit
}

$rest.AddHeader("Content-Type","application/x-amz-json-1.1")
$rest.AddHeader("X-Amz-Target","DescribeDatastore")

$sbResponseBody = New-Object Chilkat.StringBuilder
$success = $rest.FullRequestNoBodySb("GET","/datastores/{datastoreName}",$sbResponseBody)
if ($success -ne $true) {
    $($rest.LastErrorText)
    exit
}

$respStatusCode = $rest.ResponseStatusCode
$("response status code = " + $respStatusCode)
if ($respStatusCode -ne 200) {
    $("Response Header:")
    $($rest.ResponseHeader)
    $("Response Body:")
    $($sbResponseBody.GetAsString())
    exit
}

$jResp = New-Object Chilkat.JsonObject
$jResp.LoadSb($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

$Arn = $jResp.StringOf("datastore.arn")
$CreationTime = $jResp.IntOf("datastore.creationTime")
$LastMessageArrivalTime = $jResp.IntOf("datastore.lastMessageArrivalTime")
$LastUpdateTime = $jResp.IntOf("datastore.lastUpdateTime")
$Name = $jResp.StringOf("datastore.name")
$NumberOfDays = $jResp.IntOf("datastore.retentionPeriod.numberOfDays")
$Unlimited = $jResp.IntOf("datastore.retentionPeriod.unlimited")
$Status = $jResp.StringOf("datastore.status")
$Bucket = $jResp.StringOf("datastore.storage.customerManagedS3.bucket")
$KeyPrefix = $jResp.StringOf("datastore.storage.customerManagedS3.keyPrefix")
$RoleArn = $jResp.StringOf("datastore.storage.customerManagedS3.roleArn")
$CustomerManagedS3StorageBucket = $jResp.StringOf("datastore.storage.iotSiteWiseMultiLayerStorage.customerManagedS3Storage.bucket")
$CustomerManagedS3StorageKeyPrefix = $jResp.StringOf("datastore.storage.iotSiteWiseMultiLayerStorage.customerManagedS3Storage.keyPrefix")
$EstimatedOn = $jResp.IntOf("statistics.size.estimatedOn")
$EstimatedSizeInBytes = $jResp.IntOf("statistics.size.estimatedSizeInBytes")
$i = 0
$count_i = $jResp.SizeOfArray("datastore.datastorePartitions.partitions")
while ($i -lt $count_i) {
    $jResp.I = $i
    $AttributeName = $jResp.StringOf("datastore.datastorePartitions.partitions[i].attributePartition.attributeName")
    $timestampPartitionAttributeName = $jResp.StringOf("datastore.datastorePartitions.partitions[i].timestampPartition.attributeName")
    $TimestampFormat = $jResp.StringOf("datastore.datastorePartitions.partitions[i].timestampPartition.timestampFormat")
    $i = $i + 1
}

$i = 0
$count_i = $jResp.SizeOfArray("datastore.fileFormatConfiguration.parquetConfiguration.schemaDefinition.columns")
while ($i -lt $count_i) {
    $jResp.I = $i
    $name = $jResp.StringOf("datastore.fileFormatConfiguration.parquetConfiguration.schemaDefinition.columns[i].name")
    $v_type = $jResp.StringOf("datastore.fileFormatConfiguration.parquetConfiguration.schemaDefinition.columns[i].type")
    $i = $i + 1
}

# A sample JSON response body parsed by the above code:

# {
#   "datastore": {
#     "arn": "string",
#     "creationTime": number,
#     "datastorePartitions": {
#       "partitions": [
#         {
#           "attributePartition": {
#             "attributeName": "string"
#           },
#           "timestampPartition": {
#             "attributeName": "string",
#             "timestampFormat": "string"
#           }
#         }
#       ]
#     },
#     "fileFormatConfiguration": {
#       "jsonConfiguration": {},
#       "parquetConfiguration": {
#         "schemaDefinition": {
#           "columns": [
#             {
#               "name": "string",
#               "type": "string"
#             }
#           ]
#         }
#       }
#     },
#     "lastMessageArrivalTime": number,
#     "lastUpdateTime": number,
#     "name": "string",
#     "retentionPeriod": {
#       "numberOfDays": number,
#       "unlimited": boolean
#     },
#     "status": "string",
#     "storage": {
#       "customerManagedS3": {
#         "bucket": "string",
#         "keyPrefix": "string",
#         "roleArn": "string"
#       },
#       "iotSiteWiseMultiLayerStorage": {
#         "customerManagedS3Storage": {
#           "bucket": "string",
#           "keyPrefix": "string"
#         }
#       },
#       "serviceManagedS3": {}
#     }
#   },
#   "statistics": {
#     "size": {
#       "estimatedOn": number,
#       "estimatedSizeInBytes": number
#     }
#   }
# }