BatchGetQueryExecution Xojo Example
// This example requires the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
Dim rest As New Chilkat.Rest
Dim success As Boolean
Dim authAws As New Chilkat.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 = "athena"
// SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
success = rest.SetAuthAws(authAws)
// URL: https://athena.us-west-2.amazonaws.com/
// Use the same region as specified above.
success = rest.Connect("athena.us-west-2.amazonaws.com",443,True,True)
If (success <> True) Then
System.DebugLog("ConnectFailReason: " + Str(rest.ConnectFailReason))
System.DebugLog(rest.LastErrorText)
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
Dim json As New Chilkat.JsonObject
success = json.UpdateString("QueryExecutionIds[0]","string")
// The JSON request body created by the above code:
// {
// "QueryExecutionIds": [
// "string"
// ]
// }
success = rest.AddHeader("Content-Type","application/x-amz-json-1.1")
success = rest.AddHeader("X-Amz-Target","AmazonAthena.BatchGetQueryExecution")
Dim sbRequestBody As New Chilkat.StringBuilder
success = json.EmitSb(sbRequestBody)
Dim sbResponseBody As New Chilkat.StringBuilder
success = rest.FullRequestSb("POST","/",sbRequestBody,sbResponseBody)
If (success <> True) Then
System.DebugLog(rest.LastErrorText)
Return
End If
Dim respStatusCode As Int32
respStatusCode = rest.ResponseStatusCode
System.DebugLog("response status code = " + Str(respStatusCode))
If (respStatusCode <> 200) Then
System.DebugLog("Response Header:")
System.DebugLog(rest.ResponseHeader)
System.DebugLog("Response Body:")
System.DebugLog(sbResponseBody.GetAsString())
Return
End If
Dim jResp As New Chilkat.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
Dim EffectiveEngineVersion As String
Dim SelectedEngineVersion As String
Dim Query As String
Dim Catalog As String
Dim Database As String
Dim QueryExecutionId As String
Dim S3AclOption As String
Dim EncryptionOption As String
Dim KmsKey As String
Dim ExpectedBucketOwner As String
Dim OutputLocation As String
Dim StatementType As String
Dim DataManifestLocation As String
Dim DataScannedInBytes As Int32
Dim EngineExecutionTimeInMillis As Int32
Dim QueryPlanningTimeInMillis As Int32
Dim QueryQueueTimeInMillis As Int32
Dim ServiceProcessingTimeInMillis As Int32
Dim TotalExecutionTimeInMillis As Int32
Dim ErrorCategory As Int32
Dim ErrorMessage As String
Dim ErrorType As Int32
Dim Retryable As Int32
Dim CompletionDateTime As Int32
Dim State As String
Dim StateChangeReason As String
Dim SubmissionDateTime As Int32
Dim WorkGroup As String
Dim ErrorCode As String
Dim i As Int32
i = 0
Dim count_i As Int32
count_i = jResp.SizeOfArray("QueryExecutions")
While i < count_i
jResp.I = i
EffectiveEngineVersion = jResp.StringOf("QueryExecutions[i].EngineVersion.EffectiveEngineVersion")
SelectedEngineVersion = jResp.StringOf("QueryExecutions[i].EngineVersion.SelectedEngineVersion")
Query = jResp.StringOf("QueryExecutions[i].Query")
Catalog = jResp.StringOf("QueryExecutions[i].QueryExecutionContext.Catalog")
Database = jResp.StringOf("QueryExecutions[i].QueryExecutionContext.Database")
QueryExecutionId = jResp.StringOf("QueryExecutions[i].QueryExecutionId")
S3AclOption = jResp.StringOf("QueryExecutions[i].ResultConfiguration.AclConfiguration.S3AclOption")
EncryptionOption = jResp.StringOf("QueryExecutions[i].ResultConfiguration.EncryptionConfiguration.EncryptionOption")
KmsKey = jResp.StringOf("QueryExecutions[i].ResultConfiguration.EncryptionConfiguration.KmsKey")
ExpectedBucketOwner = jResp.StringOf("QueryExecutions[i].ResultConfiguration.ExpectedBucketOwner")
OutputLocation = jResp.StringOf("QueryExecutions[i].ResultConfiguration.OutputLocation")
StatementType = jResp.StringOf("QueryExecutions[i].StatementType")
DataManifestLocation = jResp.StringOf("QueryExecutions[i].Statistics.DataManifestLocation")
DataScannedInBytes = jResp.IntOf("QueryExecutions[i].Statistics.DataScannedInBytes")
EngineExecutionTimeInMillis = jResp.IntOf("QueryExecutions[i].Statistics.EngineExecutionTimeInMillis")
QueryPlanningTimeInMillis = jResp.IntOf("QueryExecutions[i].Statistics.QueryPlanningTimeInMillis")
QueryQueueTimeInMillis = jResp.IntOf("QueryExecutions[i].Statistics.QueryQueueTimeInMillis")
ServiceProcessingTimeInMillis = jResp.IntOf("QueryExecutions[i].Statistics.ServiceProcessingTimeInMillis")
TotalExecutionTimeInMillis = jResp.IntOf("QueryExecutions[i].Statistics.TotalExecutionTimeInMillis")
ErrorCategory = jResp.IntOf("QueryExecutions[i].Status.AthenaError.ErrorCategory")
ErrorMessage = jResp.StringOf("QueryExecutions[i].Status.AthenaError.ErrorMessage")
ErrorType = jResp.IntOf("QueryExecutions[i].Status.AthenaError.ErrorType")
Retryable = jResp.IntOf("QueryExecutions[i].Status.AthenaError.Retryable")
CompletionDateTime = jResp.IntOf("QueryExecutions[i].Status.CompletionDateTime")
State = jResp.StringOf("QueryExecutions[i].Status.State")
StateChangeReason = jResp.StringOf("QueryExecutions[i].Status.StateChangeReason")
SubmissionDateTime = jResp.IntOf("QueryExecutions[i].Status.SubmissionDateTime")
WorkGroup = jResp.StringOf("QueryExecutions[i].WorkGroup")
i = i + 1
Wend
i = 0
count_i = jResp.SizeOfArray("UnprocessedQueryExecutionIds")
While i < count_i
jResp.I = i
ErrorCode = jResp.StringOf("UnprocessedQueryExecutionIds[i].ErrorCode")
ErrorMessage = jResp.StringOf("UnprocessedQueryExecutionIds[i].ErrorMessage")
QueryExecutionId = jResp.StringOf("UnprocessedQueryExecutionIds[i].QueryExecutionId")
i = i + 1
Wend
// 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"
// }
// ]
// }
