Chilkat Online Tools

StartTableDataImportJob Foxpro Example

Amazon Honeycode

LOCAL loRest
LOCAL lnSuccess
LOCAL loAuthAws
LOCAL loJson
LOCAL loSbRequestBody
LOCAL loSbResponseBody
LOCAL lnRespStatusCode
LOCAL loJResp
LOCAL lcJobId
LOCAL lcJobStatus

* 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("clientRequestToken","string")
loJson.UpdateString("dataFormat","string")
loJson.UpdateString("dataSource.dataSourceConfig.dataSourceUrl","string")
loJson.UpdateString("importOptions.delimitedTextOptions.dataCharacterEncoding","string")
loJson.UpdateString("importOptions.delimitedTextOptions.delimiter","string")
loJson.UpdateInt("importOptions.delimitedTextOptions.hasHeaderRow",123)
loJson.UpdateInt("importOptions.delimitedTextOptions.ignoreEmptyRows",123)
loJson.UpdateInt("importOptions.destinationOptions.columnMap.string.columnIndex",123)

* The JSON request body created by the above code:

* {
*   "clientRequestToken": "string",
*   "dataFormat": "string",
*   "dataSource": {
*     "dataSourceConfig": {
*       "dataSourceUrl": "string"
*     }
*   },
*   "importOptions": {
*     "delimitedTextOptions": {
*       "dataCharacterEncoding": "string",
*       "delimiter": "string",
*       "hasHeaderRow": boolean,
*       "ignoreEmptyRows": boolean
*     },
*     "destinationOptions": {
*       "columnMap": {
*         "string": {
*           "columnIndex": number
*         }
*       }
*     }
*   }
* }

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

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}/import",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

lcJobId = loJResp.StringOf("jobId")
lcJobStatus = loJResp.StringOf("jobStatus")

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

* {
*   "jobId": "string",
*   "jobStatus": "string"
* }

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