DescribeDatastore 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_AttributeName
string ls_TimestampPartitionAttributeName
string ls_TimestampFormat
string ls_Name
string ls_V_type
string ls_Arn
integer li_CreationTime
integer li_LastMessageArrivalTime
integer li_LastUpdateTime
string ls_Name
integer li_NumberOfDays
integer li_Unlimited
string ls_Status
string ls_Bucket
string ls_KeyPrefix
string ls_RoleArn
string ls_CustomerManagedS3StorageBucket
string ls_CustomerManagedS3StorageKeyPrefix
integer li_EstimatedOn
integer li_EstimatedSizeInBytes
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","DescribeDatastore")
loo_SbResponseBody = create oleobject
li_rc = loo_SbResponseBody.ConnectToNewObject("Chilkat_9_5_0.StringBuilder")
li_Success = loo_Rest.FullRequestNoBodySb("GET","/datastores/{datastoreName}",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("datastore.arn")
li_CreationTime = loo_JResp.IntOf("datastore.creationTime")
li_LastMessageArrivalTime = loo_JResp.IntOf("datastore.lastMessageArrivalTime")
li_LastUpdateTime = loo_JResp.IntOf("datastore.lastUpdateTime")
ls_Name = loo_JResp.StringOf("datastore.name")
li_NumberOfDays = loo_JResp.IntOf("datastore.retentionPeriod.numberOfDays")
li_Unlimited = loo_JResp.IntOf("datastore.retentionPeriod.unlimited")
ls_Status = loo_JResp.StringOf("datastore.status")
ls_Bucket = loo_JResp.StringOf("datastore.storage.customerManagedS3.bucket")
ls_KeyPrefix = loo_JResp.StringOf("datastore.storage.customerManagedS3.keyPrefix")
ls_RoleArn = loo_JResp.StringOf("datastore.storage.customerManagedS3.roleArn")
ls_CustomerManagedS3StorageBucket = loo_JResp.StringOf("datastore.storage.iotSiteWiseMultiLayerStorage.customerManagedS3Storage.bucket")
ls_CustomerManagedS3StorageKeyPrefix = loo_JResp.StringOf("datastore.storage.iotSiteWiseMultiLayerStorage.customerManagedS3Storage.keyPrefix")
li_EstimatedOn = loo_JResp.IntOf("statistics.size.estimatedOn")
li_EstimatedSizeInBytes = loo_JResp.IntOf("statistics.size.estimatedSizeInBytes")
i = 0
li_Count_i = loo_JResp.SizeOfArray("datastore.datastorePartitions.partitions")
do while i < li_Count_i
loo_JResp.I = i
ls_AttributeName = loo_JResp.StringOf("datastore.datastorePartitions.partitions[i].attributePartition.attributeName")
ls_TimestampPartitionAttributeName = loo_JResp.StringOf("datastore.datastorePartitions.partitions[i].timestampPartition.attributeName")
ls_TimestampFormat = loo_JResp.StringOf("datastore.datastorePartitions.partitions[i].timestampPartition.timestampFormat")
i = i + 1
loop
i = 0
li_Count_i = loo_JResp.SizeOfArray("datastore.fileFormatConfiguration.parquetConfiguration.schemaDefinition.columns")
do while i < li_Count_i
loo_JResp.I = i
ls_Name = loo_JResp.StringOf("datastore.fileFormatConfiguration.parquetConfiguration.schemaDefinition.columns[i].name")
ls_V_type = loo_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
// }
// }
// }
destroy loo_Rest
destroy loo_AuthAws
destroy loo_SbResponseBody
destroy loo_JResp
