Chilkat Online Tools

ListDatastores 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","ListDatastores")

set sbResponseBody = CreateObject("Chilkat_9_5_0.StringBuilder")
success = rest.FullRequestNoBodySb("GET","/datastores",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

nextToken = jResp.StringOf("nextToken")
i = 0
count_i = jResp.SizeOfArray("datastoreSummaries")
Do While i < count_i
    jResp.I = i
    creationTime = jResp.IntOf("datastoreSummaries[i].creationTime")
    datastoreName = jResp.StringOf("datastoreSummaries[i].datastoreName")
    Bucket = jResp.StringOf("datastoreSummaries[i].datastoreStorage.customerManagedS3.bucket")
    KeyPrefix = jResp.StringOf("datastoreSummaries[i].datastoreStorage.customerManagedS3.keyPrefix")
    RoleArn = jResp.StringOf("datastoreSummaries[i].datastoreStorage.customerManagedS3.roleArn")
    CustomerManagedS3StorageBucket = jResp.StringOf("datastoreSummaries[i].datastoreStorage.iotSiteWiseMultiLayerStorage.customerManagedS3Storage.bucket")
    CustomerManagedS3StorageKeyPrefix = jResp.StringOf("datastoreSummaries[i].datastoreStorage.iotSiteWiseMultiLayerStorage.customerManagedS3Storage.keyPrefix")
    fileFormatType = jResp.StringOf("datastoreSummaries[i].fileFormatType")
    lastMessageArrivalTime = jResp.IntOf("datastoreSummaries[i].lastMessageArrivalTime")
    lastUpdateTime = jResp.IntOf("datastoreSummaries[i].lastUpdateTime")
    status = jResp.StringOf("datastoreSummaries[i].status")
    j = 0
    count_j = jResp.SizeOfArray("datastoreSummaries[i].datastorePartitions.partitions")
    Do While j < count_j
        jResp.J = j
        AttributeName = jResp.StringOf("datastoreSummaries[i].datastorePartitions.partitions[j].attributePartition.attributeName")
        timestampPartitionAttributeName = jResp.StringOf("datastoreSummaries[i].datastorePartitions.partitions[j].timestampPartition.attributeName")
        TimestampFormat = jResp.StringOf("datastoreSummaries[i].datastorePartitions.partitions[j].timestampPartition.timestampFormat")
        j = j + 1
    Loop
    i = i + 1
Loop

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

' {
'   "datastoreSummaries": [
'     {
'       "creationTime": number,
'       "datastoreName": "string",
'       "datastorePartitions": {
'         "partitions": [
'           {
'             "attributePartition": {
'               "attributeName": "string"
'             },
'             "timestampPartition": {
'               "attributeName": "string",
'               "timestampFormat": "string"
'             }
'           }
'         ]
'       },
'       "datastoreStorage": {
'         "customerManagedS3": {
'           "bucket": "string",
'           "keyPrefix": "string",
'           "roleArn": "string"
'         },
'         "iotSiteWiseMultiLayerStorage": {
'           "customerManagedS3Storage": {
'             "bucket": "string",
'             "keyPrefix": "string"
'           }
'         },
'         "serviceManagedS3": {}
'       },
'       "fileFormatType": "string",
'       "lastMessageArrivalTime": number,
'       "lastUpdateTime": number,
'       "status": "string"
'     }
'   ],
'   "nextToken": "string"
' }

outFile.Close