Chilkat Online Tools

DescribeDatastore VBScript Example

AWS IoT Analytics

Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
Set outFile = fso.CreateTextFile("output.txt", True)

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

set rest = CreateObject("Chilkat_9_5_0.Rest")

set authAws = CreateObject("Chilkat_9_5_0.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
success = 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,1,1)
If (success <> 1) Then
    outFile.WriteLine("ConnectFailReason: " & rest.ConnectFailReason)
    outFile.WriteLine(rest.LastErrorText)
    WScript.Quit
End If

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

set sbResponseBody = CreateObject("Chilkat_9_5_0.StringBuilder")
success = rest.FullRequestNoBodySb("GET","/datastores/{datastoreName}",sbResponseBody)
If (success <> 1) Then
    outFile.WriteLine(rest.LastErrorText)
    WScript.Quit
End If

respStatusCode = rest.ResponseStatusCode
outFile.WriteLine("response status code = " & respStatusCode)
If (respStatusCode <> 200) Then
    outFile.WriteLine("Response Header:")
    outFile.WriteLine(rest.ResponseHeader)
    outFile.WriteLine("Response Body:")
    outFile.WriteLine(sbResponseBody.GetAsString())
    WScript.Quit
End If

set jResp = CreateObject("Chilkat_9_5_0.JsonObject")
success = 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")
Do While i < 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
Loop
i = 0
count_i = jResp.SizeOfArray("datastore.fileFormatConfiguration.parquetConfiguration.schemaDefinition.columns")
Do While i < 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
Loop

' 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
'     }
'   }
' }

outFile.Close