Chilkat Online Tools

QueryTableRows Foxpro Example

Amazon Honeycode

LOCAL loRest
LOCAL lnSuccess
LOCAL loAuthAws
LOCAL loJson
LOCAL loSbRequestBody
LOCAL loSbResponseBody
LOCAL lnRespStatusCode
LOCAL loJResp
LOCAL lcStrVal
LOCAL lcRowId
LOCAL j
LOCAL lnCount_j
LOCAL lcFormat
LOCAL lcFormattedValue
LOCAL lcFormula
LOCAL lcRawValue
LOCAL k
LOCAL lnCount_k
LOCAL lcNextToken
LOCAL lnWorkbookCursor
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 = "honeycode"
* SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
loRest.SetAuthAws(loAuthAws)

* URL: https://honeycode.us-west-2.amazonaws.com/
* Use the same region as specified above.
lnSuccess = loRest.Connect("honeycode.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("filterFormula.contextRowId","string")
loJson.UpdateString("filterFormula.formula","string")
loJson.UpdateInt("maxResults",123)
loJson.UpdateString("nextToken","string")

* The JSON request body created by the above code:

* {
*   "filterFormula": {
*     "contextRowId": "string",
*     "formula": "string"
*   },
*   "maxResults": number,
*   "nextToken": "string"
* }

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

loSbRequestBody = CreateObject('Chilkat_9_5_0.StringBuilder')
loJson.EmitSb(loSbRequestBody)
loSbResponseBody = CreateObject('Chilkat_9_5_0.StringBuilder')
lnSuccess = loRest.FullRequestSb("POST","/workbooks/{workbookId}/tables/{tableId}/rows/query",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

lcNextToken = loJResp.StringOf("nextToken")
lnWorkbookCursor = loJResp.IntOf("workbookCursor")
i = 0
lnCount_i = loJResp.SizeOfArray("columnIds")
DO WHILE i < lnCount_i
    loJResp.I = i
    lcStrVal = loJResp.StringOf("columnIds[i]")
    i = i + 1
ENDDO
i = 0
lnCount_i = loJResp.SizeOfArray("rows")
DO WHILE i < lnCount_i
    loJResp.I = i
    lcRowId = loJResp.StringOf("rows[i].rowId")
    j = 0
    lnCount_j = loJResp.SizeOfArray("rows[i].cells")
    DO WHILE j < lnCount_j
        loJResp.J = j
        lcFormat = loJResp.StringOf("rows[i].cells[j].format")
        lcFormattedValue = loJResp.StringOf("rows[i].cells[j].formattedValue")
        lcFormula = loJResp.StringOf("rows[i].cells[j].formula")
        lcRawValue = loJResp.StringOf("rows[i].cells[j].rawValue")
        k = 0
        lnCount_k = loJResp.SizeOfArray("rows[i].cells[j].formattedValues")
        DO WHILE k < lnCount_k
            loJResp.K = k
            lcStrVal = loJResp.StringOf("rows[i].cells[j].formattedValues[k]")
            k = k + 1
        ENDDO
        j = j + 1
    ENDDO
    i = i + 1
ENDDO

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

* {
*   "columnIds": [
*     "string"
*   ],
*   "nextToken": "string",
*   "rows": [
*     {
*       "cells": [
*         {
*           "format": "string",
*           "formattedValue": "string",
*           "formattedValues": [
*             "string"
*           ],
*           "formula": "string",
*           "rawValue": "string"
*         }
*       ],
*       "rowId": "string"
*     }
*   ],
*   "workbookCursor": number
* }

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