Chilkat Online Tools

DescribeTableDataImportJob PureBasic Example

Amazon Honeycode

IncludeFile "CkJsonObject.pb"
IncludeFile "CkStringBuilder.pb"
IncludeFile "CkRest.pb"
IncludeFile "CkAuthAws.pb"

Procedure ChilkatExample()

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

    rest.i = CkRest::ckCreate()
    If rest.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    success.i

    authAws.i = CkAuthAws::ckCreate()
    If authAws.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    CkAuthAws::setCkAccessKey(authAws, "AWS_ACCESS_KEY")
    CkAuthAws::setCkSecretKey(authAws, "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.)
    CkAuthAws::setCkRegion(authAws, "us-west-2")
    CkAuthAws::setCkServiceName(authAws, "honeycode")
    ; SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
    CkRest::ckSetAuthAws(rest,authAws)

    ; URL: https://honeycode.us-west-2.amazonaws.com/
    ; Use the same region as specified above.
    success = CkRest::ckConnect(rest,"honeycode.us-west-2.amazonaws.com",443,1,1)
    If success <> 1
        Debug "ConnectFailReason: " + Str(CkRest::ckConnectFailReason(rest))
        Debug CkRest::ckLastErrorText(rest)
        CkRest::ckDispose(rest)
        CkAuthAws::ckDispose(authAws)
        ProcedureReturn
    EndIf

    CkRest::ckAddHeader(rest,"Content-Type","application/x-amz-json-1.1")
    CkRest::ckAddHeader(rest,"X-Amz-Target","DescribeTableDataImportJob")

    sbResponseBody.i = CkStringBuilder::ckCreate()
    If sbResponseBody.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    success = CkRest::ckFullRequestNoBodySb(rest,"GET","/workbooks/{workbookId}/tables/{tableId}/import/{jobId}",sbResponseBody)
    If success <> 1
        Debug CkRest::ckLastErrorText(rest)
        CkRest::ckDispose(rest)
        CkAuthAws::ckDispose(authAws)
        CkStringBuilder::ckDispose(sbResponseBody)
        ProcedureReturn
    EndIf

    respStatusCode.i = CkRest::ckResponseStatusCode(rest)
    Debug "response status code = " + Str(respStatusCode)
    If respStatusCode <> 200
        Debug "Response Header:"
        Debug CkRest::ckResponseHeader(rest)
        Debug "Response Body:"
        Debug CkStringBuilder::ckGetAsString(sbResponseBody)
        CkRest::ckDispose(rest)
        CkAuthAws::ckDispose(authAws)
        CkStringBuilder::ckDispose(sbResponseBody)
        ProcedureReturn
    EndIf

    jResp.i = CkJsonObject::ckCreate()
    If jResp.i = 0
        Debug "Failed to create object."
        ProcedureReturn
    EndIf

    CkJsonObject::ckLoadSb(jResp,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

    errorCode.s = CkJsonObject::ckStringOf(jResp,"errorCode")
    DataSourceUrl.s = CkJsonObject::ckStringOf(jResp,"jobMetadata.dataSource.dataSourceConfig.dataSourceUrl")
    DataCharacterEncoding.s = CkJsonObject::ckStringOf(jResp,"jobMetadata.importOptions.delimitedTextOptions.dataCharacterEncoding")
    Delimiter.s = CkJsonObject::ckStringOf(jResp,"jobMetadata.importOptions.delimitedTextOptions.delimiter")
    HasHeaderRow.i = CkJsonObject::ckIntOf(jResp,"jobMetadata.importOptions.delimitedTextOptions.hasHeaderRow")
    IgnoreEmptyRows.i = CkJsonObject::ckIntOf(jResp,"jobMetadata.importOptions.delimitedTextOptions.ignoreEmptyRows")
    ColumnIndex.i = CkJsonObject::ckIntOf(jResp,"jobMetadata.importOptions.destinationOptions.columnMap.string.columnIndex")
    v_Email.s = CkJsonObject::ckStringOf(jResp,"jobMetadata.submitter.email")
    UserArn.s = CkJsonObject::ckStringOf(jResp,"jobMetadata.submitter.userArn")
    SubmitTime.i = CkJsonObject::ckIntOf(jResp,"jobMetadata.submitTime")
    jobStatus.s = CkJsonObject::ckStringOf(jResp,"jobStatus")
    message.s = CkJsonObject::ckStringOf(jResp,"message")

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

    ; {
    ;   "errorCode": "string",
    ;   "jobMetadata": {
    ;     "dataSource": {
    ;       "dataSourceConfig": {
    ;         "dataSourceUrl": "string"
    ;       }
    ;     },
    ;     "importOptions": {
    ;       "delimitedTextOptions": {
    ;         "dataCharacterEncoding": "string",
    ;         "delimiter": "string",
    ;         "hasHeaderRow": boolean,
    ;         "ignoreEmptyRows": boolean
    ;       },
    ;       "destinationOptions": {
    ;         "columnMap": {
    ;           "string": {
    ;             "columnIndex": number
    ;           }
    ;         }
    ;       }
    ;     },
    ;     "submitter": {
    ;       "email": "string",
    ;       "userArn": "string"
    ;     },
    ;     "submitTime": number
    ;   },
    ;   "jobStatus": "string",
    ;   "message": "string"
    ; }


    CkRest::ckDispose(rest)
    CkAuthAws::ckDispose(authAws)
    CkStringBuilder::ckDispose(sbResponseBody)
    CkJsonObject::ckDispose(jResp)


    ProcedureReturn
EndProcedure