DescribeDataset PowerBuilder Example
integer li_rc
oleobject loo_Rest
integer li_Success
oleobject loo_AuthAws
oleobject loo_SbResponseBody
integer li_RespStatusCode
oleobject loo_JResp
string ls_ActionName
string ls_ExecutionRoleArn
string ls_Image
string ls_ComputeType
integer li_VolumeSizeInGB
string ls_SqlQuery
integer j
integer li_Count_j
string ls_DatasetName
integer li_DoubleValue
string ls_Name
string ls_FileName
string ls_StringValue
integer li_OffsetSeconds
string ls_TimeExpression
string ls_InputName
string ls_RoleArn
string ls_Bucket
string ls_DatabaseName
string ls_TableName
string ls_Key
string ls_S3DestinationConfigurationRoleArn
string ls_EntryName
integer li_TimeoutInMinutes
string ls_RuleName
string ls_DatasetName
string ls_Expression
string ls_Arn
integer li_CreationTime
integer li_LastUpdateTime
string ls_Name
integer li_NumberOfDays
integer li_Unlimited
string ls_Status
integer li_MaxVersions
integer li_VersioningConfigurationUnlimited
integer i
integer li_Count_i
// This example requires the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
loo_Rest = create oleobject
li_rc = loo_Rest.ConnectToNewObject("Chilkat_9_5_0.Rest")
if li_rc < 0 then
destroy loo_Rest
MessageBox("Error","Connecting to COM object failed")
return
end if
loo_AuthAws = create oleobject
li_rc = loo_AuthAws.ConnectToNewObject("Chilkat_9_5_0.AuthAws")
loo_AuthAws.AccessKey = "AWS_ACCESS_KEY"
loo_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.)
loo_AuthAws.Region = "us-west-2"
loo_AuthAws.ServiceName = "iotanalytics"
// SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
loo_Rest.SetAuthAws(loo_AuthAws)
// URL: https://iotanalytics.us-west-2.amazonaws.com/
// Use the same region as specified above.
li_Success = loo_Rest.Connect("iotanalytics.us-west-2.amazonaws.com",443,1,1)
if li_Success <> 1 then
Write-Debug "ConnectFailReason: " + string(loo_Rest.ConnectFailReason)
Write-Debug loo_Rest.LastErrorText
destroy loo_Rest
destroy loo_AuthAws
return
end if
loo_Rest.AddHeader("Content-Type","application/x-amz-json-1.1")
loo_Rest.AddHeader("X-Amz-Target","DescribeDataset")
loo_SbResponseBody = create oleobject
li_rc = loo_SbResponseBody.ConnectToNewObject("Chilkat_9_5_0.StringBuilder")
li_Success = loo_Rest.FullRequestNoBodySb("GET","/datasets/{datasetName}",loo_SbResponseBody)
if li_Success <> 1 then
Write-Debug loo_Rest.LastErrorText
destroy loo_Rest
destroy loo_AuthAws
destroy loo_SbResponseBody
return
end if
li_RespStatusCode = loo_Rest.ResponseStatusCode
Write-Debug "response status code = " + string(li_RespStatusCode)
if li_RespStatusCode <> 200 then
Write-Debug "Response Header:"
Write-Debug loo_Rest.ResponseHeader
Write-Debug "Response Body:"
Write-Debug loo_SbResponseBody.GetAsString()
destroy loo_Rest
destroy loo_AuthAws
destroy loo_SbResponseBody
return
end if
loo_JResp = create oleobject
li_rc = loo_JResp.ConnectToNewObject("Chilkat_9_5_0.JsonObject")
loo_JResp.LoadSb(loo_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
ls_Arn = loo_JResp.StringOf("dataset.arn")
li_CreationTime = loo_JResp.IntOf("dataset.creationTime")
li_LastUpdateTime = loo_JResp.IntOf("dataset.lastUpdateTime")
ls_Name = loo_JResp.StringOf("dataset.name")
li_NumberOfDays = loo_JResp.IntOf("dataset.retentionPeriod.numberOfDays")
li_Unlimited = loo_JResp.IntOf("dataset.retentionPeriod.unlimited")
ls_Status = loo_JResp.StringOf("dataset.status")
li_MaxVersions = loo_JResp.IntOf("dataset.versioningConfiguration.maxVersions")
li_VersioningConfigurationUnlimited = loo_JResp.IntOf("dataset.versioningConfiguration.unlimited")
i = 0
li_Count_i = loo_JResp.SizeOfArray("dataset.actions")
do while i < li_Count_i
loo_JResp.I = i
ls_ActionName = loo_JResp.StringOf("dataset.actions[i].actionName")
ls_ExecutionRoleArn = loo_JResp.StringOf("dataset.actions[i].containerAction.executionRoleArn")
ls_Image = loo_JResp.StringOf("dataset.actions[i].containerAction.image")
ls_ComputeType = loo_JResp.StringOf("dataset.actions[i].containerAction.resourceConfiguration.computeType")
li_VolumeSizeInGB = loo_JResp.IntOf("dataset.actions[i].containerAction.resourceConfiguration.volumeSizeInGB")
ls_SqlQuery = loo_JResp.StringOf("dataset.actions[i].queryAction.sqlQuery")
j = 0
li_Count_j = loo_JResp.SizeOfArray("dataset.actions[i].containerAction.variables")
do while j < li_Count_j
loo_JResp.J = j
ls_DatasetName = loo_JResp.StringOf("dataset.actions[i].containerAction.variables[j].datasetContentVersionValue.datasetName")
li_DoubleValue = loo_JResp.IntOf("dataset.actions[i].containerAction.variables[j].doubleValue")
ls_Name = loo_JResp.StringOf("dataset.actions[i].containerAction.variables[j].name")
ls_FileName = loo_JResp.StringOf("dataset.actions[i].containerAction.variables[j].outputFileUriValue.fileName")
ls_StringValue = loo_JResp.StringOf("dataset.actions[i].containerAction.variables[j].stringValue")
j = j + 1
loop
j = 0
li_Count_j = loo_JResp.SizeOfArray("dataset.actions[i].queryAction.filters")
do while j < li_Count_j
loo_JResp.J = j
li_OffsetSeconds = loo_JResp.IntOf("dataset.actions[i].queryAction.filters[j].deltaTime.offsetSeconds")
ls_TimeExpression = loo_JResp.StringOf("dataset.actions[i].queryAction.filters[j].deltaTime.timeExpression")
j = j + 1
loop
i = i + 1
loop
i = 0
li_Count_i = loo_JResp.SizeOfArray("dataset.contentDeliveryRules")
do while i < li_Count_i
loo_JResp.I = i
ls_InputName = loo_JResp.StringOf("dataset.contentDeliveryRules[i].destination.iotEventsDestinationConfiguration.inputName")
ls_RoleArn = loo_JResp.StringOf("dataset.contentDeliveryRules[i].destination.iotEventsDestinationConfiguration.roleArn")
ls_Bucket = loo_JResp.StringOf("dataset.contentDeliveryRules[i].destination.s3DestinationConfiguration.bucket")
ls_DatabaseName = loo_JResp.StringOf("dataset.contentDeliveryRules[i].destination.s3DestinationConfiguration.glueConfiguration.databaseName")
ls_TableName = loo_JResp.StringOf("dataset.contentDeliveryRules[i].destination.s3DestinationConfiguration.glueConfiguration.tableName")
ls_Key = loo_JResp.StringOf("dataset.contentDeliveryRules[i].destination.s3DestinationConfiguration.key")
ls_S3DestinationConfigurationRoleArn = loo_JResp.StringOf("dataset.contentDeliveryRules[i].destination.s3DestinationConfiguration.roleArn")
ls_EntryName = loo_JResp.StringOf("dataset.contentDeliveryRules[i].entryName")
i = i + 1
loop
i = 0
li_Count_i = loo_JResp.SizeOfArray("dataset.lateDataRules")
do while i < li_Count_i
loo_JResp.I = i
li_TimeoutInMinutes = loo_JResp.IntOf("dataset.lateDataRules[i].ruleConfiguration.deltaTimeSessionWindowConfiguration.timeoutInMinutes")
ls_RuleName = loo_JResp.StringOf("dataset.lateDataRules[i].ruleName")
i = i + 1
loop
i = 0
li_Count_i = loo_JResp.SizeOfArray("dataset.triggers")
do while i < li_Count_i
loo_JResp.I = i
ls_DatasetName = loo_JResp.StringOf("dataset.triggers[i].dataset.name")
ls_Expression = loo_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
// }
// }
// }
destroy loo_Rest
destroy loo_AuthAws
destroy loo_SbResponseBody
destroy loo_JResp