Chilkat Online Tools

UpdateWorkGroup Foxpro Example

Athena

LOCAL loRest
LOCAL lnSuccess
LOCAL loAuthAws
LOCAL loJson
LOCAL loSbRequestBody
LOCAL loSbResponseBody
LOCAL lnRespStatusCode

* This example requires the Chilkat API to have been previously unlocked.
* See Global Unlock Sample for sample code.

loRest = CreateObject('Chilkat_9_5_0.Rest')

loAuthAws = CreateObject('Chilkat_9_5_0.AuthAws')
loAuthAws.AccessKey = "AWS_ACCESS_KEY"
loAuthAws.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.)
loAuthAws.Region = "us-west-2"
loAuthAws.ServiceName = "athena"
* SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
loRest.SetAuthAws(loAuthAws)

* URL: https://athena.us-west-2.amazonaws.com/
* Use the same region as specified above.
lnSuccess = loRest.Connect("athena.us-west-2.amazonaws.com",443,1,1)
IF (lnSuccess <> 1) THEN
    ? "ConnectFailReason: " + STR(loRest.ConnectFailReason)
    ? loRest.LastErrorText
    RELEASE loRest
    RELEASE loAuthAws
    CANCEL
ENDIF

* 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

loJson = CreateObject('Chilkat_9_5_0.JsonObject')
loJson.UpdateInt("ConfigurationUpdates.BytesScannedCutoffPerQuery",123)
loJson.UpdateInt("ConfigurationUpdates.EnforceWorkGroupConfiguration",123)
loJson.UpdateString("ConfigurationUpdates.EngineVersion.EffectiveEngineVersion","string")
loJson.UpdateString("ConfigurationUpdates.EngineVersion.SelectedEngineVersion","string")
loJson.UpdateInt("ConfigurationUpdates.PublishCloudWatchMetricsEnabled",123)
loJson.UpdateInt("ConfigurationUpdates.RemoveBytesScannedCutoffPerQuery",123)
loJson.UpdateInt("ConfigurationUpdates.RequesterPaysEnabled",123)
loJson.UpdateString("ConfigurationUpdates.ResultConfigurationUpdates.AclConfiguration.S3AclOption","string")
loJson.UpdateString("ConfigurationUpdates.ResultConfigurationUpdates.EncryptionConfiguration.EncryptionOption","string")
loJson.UpdateString("ConfigurationUpdates.ResultConfigurationUpdates.EncryptionConfiguration.KmsKey","string")
loJson.UpdateString("ConfigurationUpdates.ResultConfigurationUpdates.ExpectedBucketOwner","string")
loJson.UpdateString("ConfigurationUpdates.ResultConfigurationUpdates.OutputLocation","string")
loJson.UpdateInt("ConfigurationUpdates.ResultConfigurationUpdates.RemoveAclConfiguration",123)
loJson.UpdateInt("ConfigurationUpdates.ResultConfigurationUpdates.RemoveEncryptionConfiguration",123)
loJson.UpdateInt("ConfigurationUpdates.ResultConfigurationUpdates.RemoveExpectedBucketOwner",123)
loJson.UpdateInt("ConfigurationUpdates.ResultConfigurationUpdates.RemoveOutputLocation",123)
loJson.UpdateString("Description","string")
loJson.UpdateString("State","string")
loJson.UpdateString("WorkGroup","string")

* The JSON request body created by the above code:

* {
*   "ConfigurationUpdates": {
*     "BytesScannedCutoffPerQuery": number,
*     "EnforceWorkGroupConfiguration": boolean,
*     "EngineVersion": {
*       "EffectiveEngineVersion": "string",
*       "SelectedEngineVersion": "string"
*     },
*     "PublishCloudWatchMetricsEnabled": boolean,
*     "RemoveBytesScannedCutoffPerQuery": boolean,
*     "RequesterPaysEnabled": boolean,
*     "ResultConfigurationUpdates": {
*       "AclConfiguration": {
*         "S3AclOption": "string"
*       },
*       "EncryptionConfiguration": {
*         "EncryptionOption": "string",
*         "KmsKey": "string"
*       },
*       "ExpectedBucketOwner": "string",
*       "OutputLocation": "string",
*       "RemoveAclConfiguration": boolean,
*       "RemoveEncryptionConfiguration": boolean,
*       "RemoveExpectedBucketOwner": boolean,
*       "RemoveOutputLocation": boolean
*     }
*   },
*   "Description": "string",
*   "State": "string",
*   "WorkGroup": "string"
* }

loRest.AddHeader("Content-Type","application/x-amz-json-1.1")
loRest.AddHeader("X-Amz-Target","AmazonAthena.UpdateWorkGroup")

loSbRequestBody = CreateObject('Chilkat_9_5_0.StringBuilder')
loJson.EmitSb(loSbRequestBody)
loSbResponseBody = CreateObject('Chilkat_9_5_0.StringBuilder')
lnSuccess = loRest.FullRequestSb("POST","/",loSbRequestBody,loSbResponseBody)
IF (lnSuccess <> 1) THEN
    ? loRest.LastErrorText
    RELEASE loRest
    RELEASE loAuthAws
    RELEASE loJson
    RELEASE loSbRequestBody
    RELEASE loSbResponseBody
    CANCEL
ENDIF

lnRespStatusCode = loRest.ResponseStatusCode
? "response status code = " + STR(lnRespStatusCode)
IF (lnRespStatusCode <> 200) THEN
    ? "Response Header:"
    ? loRest.ResponseHeader
    ? "Response Body:"
    ? loSbResponseBody.GetAsString()
    RELEASE loRest
    RELEASE loAuthAws
    RELEASE loJson
    RELEASE loSbRequestBody
    RELEASE loSbResponseBody
    CANCEL
ENDIF

* If the action is successful, the service sends back an HTTP 200 response with an empty HTTP body.

RELEASE loRest
RELEASE loAuthAws
RELEASE loJson
RELEASE loSbRequestBody
RELEASE loSbResponseBody