DescribeTableDataImportJob Classic ASP Example
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<%
' This example requires the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.
set rest = Server.CreateObject("Chilkat_9_5_0.Rest")
set authAws = Server.CreateObject("Chilkat_9_5_0.AuthAws")
authAws.AccessKey = "AWS_ACCESS_KEY"
authAws.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.)
authAws.Region = "us-west-2"
authAws.ServiceName = "honeycode"
' SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
success = rest.SetAuthAws(authAws)
' URL: https://honeycode.us-west-2.amazonaws.com/
' Use the same region as specified above.
success = rest.Connect("honeycode.us-west-2.amazonaws.com",443,1,1)
If (success <> 1) Then
Response.Write "<pre>" & Server.HTMLEncode( "ConnectFailReason: " & rest.ConnectFailReason) & "</pre>"
Response.Write "<pre>" & Server.HTMLEncode( rest.LastErrorText) & "</pre>"
Response.End
End If
success = rest.AddHeader("Content-Type","application/x-amz-json-1.1")
success = rest.AddHeader("X-Amz-Target","DescribeTableDataImportJob")
set sbResponseBody = Server.CreateObject("Chilkat_9_5_0.StringBuilder")
success = rest.FullRequestNoBodySb("GET","/workbooks/{workbookId}/tables/{tableId}/import/{jobId}",sbResponseBody)
If (success <> 1) Then
Response.Write "<pre>" & Server.HTMLEncode( rest.LastErrorText) & "</pre>"
Response.End
End If
respStatusCode = rest.ResponseStatusCode
Response.Write "<pre>" & Server.HTMLEncode( "response status code = " & respStatusCode) & "</pre>"
If (respStatusCode <> 200) Then
Response.Write "<pre>" & Server.HTMLEncode( "Response Header:") & "</pre>"
Response.Write "<pre>" & Server.HTMLEncode( rest.ResponseHeader) & "</pre>"
Response.Write "<pre>" & Server.HTMLEncode( "Response Body:") & "</pre>"
Response.Write "<pre>" & Server.HTMLEncode( sbResponseBody.GetAsString()) & "</pre>"
Response.End
End If
set jResp = Server.CreateObject("Chilkat_9_5_0.JsonObject")
success = jResp.LoadSb(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 = jResp.StringOf("errorCode")
DataSourceUrl = jResp.StringOf("jobMetadata.dataSource.dataSourceConfig.dataSourceUrl")
DataCharacterEncoding = jResp.StringOf("jobMetadata.importOptions.delimitedTextOptions.dataCharacterEncoding")
Delimiter = jResp.StringOf("jobMetadata.importOptions.delimitedTextOptions.delimiter")
HasHeaderRow = jResp.IntOf("jobMetadata.importOptions.delimitedTextOptions.hasHeaderRow")
IgnoreEmptyRows = jResp.IntOf("jobMetadata.importOptions.delimitedTextOptions.ignoreEmptyRows")
ColumnIndex = jResp.IntOf("jobMetadata.importOptions.destinationOptions.columnMap.string.columnIndex")
v_Email = jResp.StringOf("jobMetadata.submitter.email")
UserArn = jResp.StringOf("jobMetadata.submitter.userArn")
SubmitTime = jResp.IntOf("jobMetadata.submitTime")
jobStatus = jResp.StringOf("jobStatus")
message = jResp.StringOf("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"
' }
%>
</body>
</html>
