Chilkat Online Tools

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

set sbResponseBody = CreateObject("Chilkat_9_5_0.StringBuilder")
success = rest.FullRequestNoBodySb("GET","/datasets/{datasetName}",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("dataset.arn")
CreationTime = jResp.IntOf("dataset.creationTime")
LastUpdateTime = jResp.IntOf("dataset.lastUpdateTime")
Name = jResp.StringOf("dataset.name")
NumberOfDays = jResp.IntOf("dataset.retentionPeriod.numberOfDays")
Unlimited = jResp.IntOf("dataset.retentionPeriod.unlimited")
Status = jResp.StringOf("dataset.status")
MaxVersions = jResp.IntOf("dataset.versioningConfiguration.maxVersions")
VersioningConfigurationUnlimited = jResp.IntOf("dataset.versioningConfiguration.unlimited")
i = 0
count_i = jResp.SizeOfArray("dataset.actions")
Do While i < count_i
    jResp.I = i
    actionName = jResp.StringOf("dataset.actions[i].actionName")
    ExecutionRoleArn = jResp.StringOf("dataset.actions[i].containerAction.executionRoleArn")
    Image = jResp.StringOf("dataset.actions[i].containerAction.image")
    ComputeType = jResp.StringOf("dataset.actions[i].containerAction.resourceConfiguration.computeType")
    VolumeSizeInGB = jResp.IntOf("dataset.actions[i].containerAction.resourceConfiguration.volumeSizeInGB")
    SqlQuery = jResp.StringOf("dataset.actions[i].queryAction.sqlQuery")
    j = 0
    count_j = jResp.SizeOfArray("dataset.actions[i].containerAction.variables")
    Do While j < count_j
        jResp.J = j
        DatasetName = jResp.StringOf("dataset.actions[i].containerAction.variables[j].datasetContentVersionValue.datasetName")
        doubleValue = jResp.IntOf("dataset.actions[i].containerAction.variables[j].doubleValue")
        name = jResp.StringOf("dataset.actions[i].containerAction.variables[j].name")
        FileName = jResp.StringOf("dataset.actions[i].containerAction.variables[j].outputFileUriValue.fileName")
        stringValue = jResp.StringOf("dataset.actions[i].containerAction.variables[j].stringValue")
        j = j + 1
    Loop
    j = 0
    count_j = jResp.SizeOfArray("dataset.actions[i].queryAction.filters")
    Do While j < count_j
        jResp.J = j
        OffsetSeconds = jResp.IntOf("dataset.actions[i].queryAction.filters[j].deltaTime.offsetSeconds")
        TimeExpression = jResp.StringOf("dataset.actions[i].queryAction.filters[j].deltaTime.timeExpression")
        j = j + 1
    Loop
    i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("dataset.contentDeliveryRules")
Do While i < count_i
    jResp.I = i
    InputName = jResp.StringOf("dataset.contentDeliveryRules[i].destination.iotEventsDestinationConfiguration.inputName")
    RoleArn = jResp.StringOf("dataset.contentDeliveryRules[i].destination.iotEventsDestinationConfiguration.roleArn")
    Bucket = jResp.StringOf("dataset.contentDeliveryRules[i].destination.s3DestinationConfiguration.bucket")
    DatabaseName = jResp.StringOf("dataset.contentDeliveryRules[i].destination.s3DestinationConfiguration.glueConfiguration.databaseName")
    TableName = jResp.StringOf("dataset.contentDeliveryRules[i].destination.s3DestinationConfiguration.glueConfiguration.tableName")
    Key = jResp.StringOf("dataset.contentDeliveryRules[i].destination.s3DestinationConfiguration.key")
    S3DestinationConfigurationRoleArn = jResp.StringOf("dataset.contentDeliveryRules[i].destination.s3DestinationConfiguration.roleArn")
    entryName = jResp.StringOf("dataset.contentDeliveryRules[i].entryName")
    i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("dataset.lateDataRules")
Do While i < count_i
    jResp.I = i
    TimeoutInMinutes = jResp.IntOf("dataset.lateDataRules[i].ruleConfiguration.deltaTimeSessionWindowConfiguration.timeoutInMinutes")
    ruleName = jResp.StringOf("dataset.lateDataRules[i].ruleName")
    i = i + 1
Loop
i = 0
count_i = jResp.SizeOfArray("dataset.triggers")
Do While i < count_i
    jResp.I = i
    datasetName = jResp.StringOf("dataset.triggers[i].dataset.name")
    Expression = jResp.StringOf("dataset.triggers[i].schedule.expression")
    i = i + 1
Loop

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

' {
'   "dataset": {
'     "actions": [
'       {
'         "actionName": "string",
'         "containerAction": {
'           "executionRoleArn": "string",
'           "image": "string",
'           "resourceConfiguration": {
'             "computeType": "string",
'             "volumeSizeInGB": number
'           },
'           "variables": [
'             {
'               "datasetContentVersionValue": {
'                 "datasetName": "string"
'               },
'               "doubleValue": number,
'               "name": "string",
'               "outputFileUriValue": {
'                 "fileName": "string"
'               },
'               "stringValue": "string"
'             }
'           ]
'         },
'         "queryAction": {
'           "filters": [
'             {
'               "deltaTime": {
'                 "offsetSeconds": number,
'                 "timeExpression": "string"
'               }
'             }
'           ],
'           "sqlQuery": "string"
'         }
'       }
'     ],
'     "arn": "string",
'     "contentDeliveryRules": [
'       {
'         "destination": {
'           "iotEventsDestinationConfiguration": {
'             "inputName": "string",
'             "roleArn": "string"
'           },
'           "s3DestinationConfiguration": {
'             "bucket": "string",
'             "glueConfiguration": {
'               "databaseName": "string",
'               "tableName": "string"
'             },
'             "key": "string",
'             "roleArn": "string"
'           }
'         },
'         "entryName": "string"
'       }
'     ],
'     "creationTime": number,
'     "lastUpdateTime": number,
'     "lateDataRules": [
'       {
'         "ruleConfiguration": {
'           "deltaTimeSessionWindowConfiguration": {
'             "timeoutInMinutes": number
'           }
'         },
'         "ruleName": "string"
'       }
'     ],
'     "name": "string",
'     "retentionPeriod": {
'       "numberOfDays": number,
'       "unlimited": boolean
'     },
'     "status": "string",
'     "triggers": [
'       {
'         "dataset": {
'           "name": "string"
'         },
'         "schedule": {
'           "expression": "string"
'         }
'       }
'     ],
'     "versioningConfiguration": {
'       "maxVersions": number,
'       "unlimited": boolean
'     }
'   }
' }

outFile.Close