Chilkat Online Tools

GetTableMetadata Foxpro Example

Athena

LOCAL loRest
LOCAL lnSuccess
LOCAL loAuthAws
LOCAL loJson
LOCAL loSbRequestBody
LOCAL loSbResponseBody
LOCAL lnRespStatusCode
LOCAL loJResp
LOCAL lcComment
LOCAL lcV_Type
LOCAL lnCreateTime
LOCAL lnLastAccessTime
LOCAL lcName
LOCAL lcV_String
LOCAL lcTableType
LOCAL i
LOCAL lnCount_i

* 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.UpdateString("CatalogName","string")
loJson.UpdateString("DatabaseName","string")
loJson.UpdateString("TableName","string")

* The JSON request body created by the above code:

* {
*   "CatalogName": "string",
*   "DatabaseName": "string",
*   "TableName": "string"
* }

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

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

loJResp = CreateObject('Chilkat_9_5_0.JsonObject')
loJResp.LoadSb(loSbResponseBody)

* 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

lnCreateTime = loJResp.IntOf("TableMetadata.CreateTime")
lnLastAccessTime = loJResp.IntOf("TableMetadata.LastAccessTime")
lcName = loJResp.StringOf("TableMetadata.Name")
lcV_String = loJResp.StringOf("TableMetadata.Parameters.string")
lcTableType = loJResp.StringOf("TableMetadata.TableType")
i = 0
lnCount_i = loJResp.SizeOfArray("TableMetadata.Columns")
DO WHILE i < lnCount_i
    loJResp.I = i
    lcComment = loJResp.StringOf("TableMetadata.Columns[i].Comment")
    lcName = loJResp.StringOf("TableMetadata.Columns[i].Name")
    lcV_Type = loJResp.StringOf("TableMetadata.Columns[i].Type")
    i = i + 1
ENDDO
i = 0
lnCount_i = loJResp.SizeOfArray("TableMetadata.PartitionKeys")
DO WHILE i < lnCount_i
    loJResp.I = i
    lcComment = loJResp.StringOf("TableMetadata.PartitionKeys[i].Comment")
    lcName = loJResp.StringOf("TableMetadata.PartitionKeys[i].Name")
    lcV_Type = loJResp.StringOf("TableMetadata.PartitionKeys[i].Type")
    i = i + 1
ENDDO

* A sample JSON response body parsed by the above code:

* {
*   "TableMetadata": {
*     "Columns": [
*       {
*         "Comment": "string",
*         "Name": "string",
*         "Type": "string"
*       }
*     ],
*     "CreateTime": number,
*     "LastAccessTime": number,
*     "Name": "string",
*     "Parameters": {
*       "string": "string"
*     },
*     "PartitionKeys": [
*       {
*         "Comment": "string",
*         "Name": "string",
*         "Type": "string"
*       }
*     ],
*     "TableType": "string"
*   }
* }

RELEASE loRest
RELEASE loAuthAws
RELEASE loJson
RELEASE loSbRequestBody
RELEASE loSbResponseBody
RELEASE loJResp