BatchGetQueryExecution PowerBuilder Example
integer li_rc
oleobject loo_Rest
integer li_Success
oleobject loo_AuthAws
oleobject loo_Json
oleobject loo_SbRequestBody
oleobject loo_SbResponseBody
integer li_RespStatusCode
oleobject loo_JResp
string ls_EffectiveEngineVersion
string ls_SelectedEngineVersion
string ls_Query
string ls_Catalog
string ls_Database
string ls_QueryExecutionId
string ls_S3AclOption
string ls_EncryptionOption
string ls_KmsKey
string ls_ExpectedBucketOwner
string ls_OutputLocation
string ls_StatementType
string ls_DataManifestLocation
integer li_DataScannedInBytes
integer li_EngineExecutionTimeInMillis
integer li_QueryPlanningTimeInMillis
integer li_QueryQueueTimeInMillis
integer li_ServiceProcessingTimeInMillis
integer li_TotalExecutionTimeInMillis
integer li_ErrorCategory
string ls_ErrorMessage
integer li_ErrorType
integer li_Retryable
integer li_CompletionDateTime
string ls_State
string ls_StateChangeReason
integer li_SubmissionDateTime
string ls_WorkGroup
string ls_ErrorCode
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 = "athena"
// SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
loo_Rest.SetAuthAws(loo_AuthAws)
// URL: https://athena.us-west-2.amazonaws.com/
// Use the same region as specified above.
li_Success = loo_Rest.Connect("athena.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
// The following code creates the JSON request body.
// The JSON created by this code is shown below.
// Use this online tool to generate code from sample JSON:
// Generate Code to Create JSON
loo_Json = create oleobject
li_rc = loo_Json.ConnectToNewObject("Chilkat_9_5_0.JsonObject")
loo_Json.UpdateString("QueryExecutionIds[0]","string")
// The JSON request body created by the above code:
// {
// "QueryExecutionIds": [
// "string"
// ]
// }
loo_Rest.AddHeader("Content-Type","application/x-amz-json-1.1")
loo_Rest.AddHeader("X-Amz-Target","AmazonAthena.BatchGetQueryExecution")
loo_SbRequestBody = create oleobject
li_rc = loo_SbRequestBody.ConnectToNewObject("Chilkat_9_5_0.StringBuilder")
loo_Json.EmitSb(loo_SbRequestBody)
loo_SbResponseBody = create oleobject
li_rc = loo_SbResponseBody.ConnectToNewObject("Chilkat_9_5_0.StringBuilder")
li_Success = loo_Rest.FullRequestSb("POST","/",loo_SbRequestBody,loo_SbResponseBody)
if li_Success <> 1 then
Write-Debug loo_Rest.LastErrorText
destroy loo_Rest
destroy loo_AuthAws
destroy loo_Json
destroy loo_SbRequestBody
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_Json
destroy loo_SbRequestBody
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
i = 0
li_Count_i = loo_JResp.SizeOfArray("QueryExecutions")
do while i < li_Count_i
loo_JResp.I = i
ls_EffectiveEngineVersion = loo_JResp.StringOf("QueryExecutions[i].EngineVersion.EffectiveEngineVersion")
ls_SelectedEngineVersion = loo_JResp.StringOf("QueryExecutions[i].EngineVersion.SelectedEngineVersion")
ls_Query = loo_JResp.StringOf("QueryExecutions[i].Query")
ls_Catalog = loo_JResp.StringOf("QueryExecutions[i].QueryExecutionContext.Catalog")
ls_Database = loo_JResp.StringOf("QueryExecutions[i].QueryExecutionContext.Database")
ls_QueryExecutionId = loo_JResp.StringOf("QueryExecutions[i].QueryExecutionId")
ls_S3AclOption = loo_JResp.StringOf("QueryExecutions[i].ResultConfiguration.AclConfiguration.S3AclOption")
ls_EncryptionOption = loo_JResp.StringOf("QueryExecutions[i].ResultConfiguration.EncryptionConfiguration.EncryptionOption")
ls_KmsKey = loo_JResp.StringOf("QueryExecutions[i].ResultConfiguration.EncryptionConfiguration.KmsKey")
ls_ExpectedBucketOwner = loo_JResp.StringOf("QueryExecutions[i].ResultConfiguration.ExpectedBucketOwner")
ls_OutputLocation = loo_JResp.StringOf("QueryExecutions[i].ResultConfiguration.OutputLocation")
ls_StatementType = loo_JResp.StringOf("QueryExecutions[i].StatementType")
ls_DataManifestLocation = loo_JResp.StringOf("QueryExecutions[i].Statistics.DataManifestLocation")
li_DataScannedInBytes = loo_JResp.IntOf("QueryExecutions[i].Statistics.DataScannedInBytes")
li_EngineExecutionTimeInMillis = loo_JResp.IntOf("QueryExecutions[i].Statistics.EngineExecutionTimeInMillis")
li_QueryPlanningTimeInMillis = loo_JResp.IntOf("QueryExecutions[i].Statistics.QueryPlanningTimeInMillis")
li_QueryQueueTimeInMillis = loo_JResp.IntOf("QueryExecutions[i].Statistics.QueryQueueTimeInMillis")
li_ServiceProcessingTimeInMillis = loo_JResp.IntOf("QueryExecutions[i].Statistics.ServiceProcessingTimeInMillis")
li_TotalExecutionTimeInMillis = loo_JResp.IntOf("QueryExecutions[i].Statistics.TotalExecutionTimeInMillis")
li_ErrorCategory = loo_JResp.IntOf("QueryExecutions[i].Status.AthenaError.ErrorCategory")
ls_ErrorMessage = loo_JResp.StringOf("QueryExecutions[i].Status.AthenaError.ErrorMessage")
li_ErrorType = loo_JResp.IntOf("QueryExecutions[i].Status.AthenaError.ErrorType")
li_Retryable = loo_JResp.IntOf("QueryExecutions[i].Status.AthenaError.Retryable")
li_CompletionDateTime = loo_JResp.IntOf("QueryExecutions[i].Status.CompletionDateTime")
ls_State = loo_JResp.StringOf("QueryExecutions[i].Status.State")
ls_StateChangeReason = loo_JResp.StringOf("QueryExecutions[i].Status.StateChangeReason")
li_SubmissionDateTime = loo_JResp.IntOf("QueryExecutions[i].Status.SubmissionDateTime")
ls_WorkGroup = loo_JResp.StringOf("QueryExecutions[i].WorkGroup")
i = i + 1
loop
i = 0
li_Count_i = loo_JResp.SizeOfArray("UnprocessedQueryExecutionIds")
do while i < li_Count_i
loo_JResp.I = i
ls_ErrorCode = loo_JResp.StringOf("UnprocessedQueryExecutionIds[i].ErrorCode")
ls_ErrorMessage = loo_JResp.StringOf("UnprocessedQueryExecutionIds[i].ErrorMessage")
ls_QueryExecutionId = loo_JResp.StringOf("UnprocessedQueryExecutionIds[i].QueryExecutionId")
i = i + 1
loop
// A sample JSON response body parsed by the above code:
// {
// "QueryExecutions": [
// {
// "EngineVersion": {
// "EffectiveEngineVersion": "string",
// "SelectedEngineVersion": "string"
// },
// "Query": "string",
// "QueryExecutionContext": {
// "Catalog": "string",
// "Database": "string"
// },
// "QueryExecutionId": "string",
// "ResultConfiguration": {
// "AclConfiguration": {
// "S3AclOption": "string"
// },
// "EncryptionConfiguration": {
// "EncryptionOption": "string",
// "KmsKey": "string"
// },
// "ExpectedBucketOwner": "string",
// "OutputLocation": "string"
// },
// "StatementType": "string",
// "Statistics": {
// "DataManifestLocation": "string",
// "DataScannedInBytes": number,
// "EngineExecutionTimeInMillis": number,
// "QueryPlanningTimeInMillis": number,
// "QueryQueueTimeInMillis": number,
// "ServiceProcessingTimeInMillis": number,
// "TotalExecutionTimeInMillis": number
// },
// "Status": {
// "AthenaError": {
// "ErrorCategory": number,
// "ErrorMessage": "string",
// "ErrorType": number,
// "Retryable": boolean
// },
// "CompletionDateTime": number,
// "State": "string",
// "StateChangeReason": "string",
// "SubmissionDateTime": number
// },
// "WorkGroup": "string"
// }
// ],
// "UnprocessedQueryExecutionIds": [
// {
// "ErrorCode": "string",
// "ErrorMessage": "string",
// "QueryExecutionId": "string"
// }
// ]
// }
destroy loo_Rest
destroy loo_AuthAws
destroy loo_Json
destroy loo_SbRequestBody
destroy loo_SbResponseBody
destroy loo_JResp
