ListStatements Swift Example
func chilkatTest() {
// This example requires the Chilkat API to have been previously unlocked.
// See Global Unlock Sample for sample code.
let rest = CkoRest()
var success: Bool
let authAws = CkoAuthAws()
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 = "redshift-data"
// SetAuthAws causes Chilkat to automatically add the following headers: Authorization, X-Amz-Date
rest.SetAuthAws(authAws)
// URL: https://redshift-data.us-west-2.amazonaws.com/
// Use the same region as specified above.
success = rest.Connect("redshift-data.us-west-2.amazonaws.com", port: 443, tls: true, autoReconnect: true)
if success != true {
print("ConnectFailReason: \(rest.ConnectFailReason.intValue)")
print("\(rest.LastErrorText)")
return
}
// 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
let json = CkoJsonObject()
json.UpdateInt("MaxResults", value: 123)
json.UpdateString("NextToken", value: "string")
json.UpdateInt("RoleLevel", value: 123)
json.UpdateString("StatementName", value: "string")
json.UpdateString("Status", value: "string")
// The JSON request body created by the above code:
// {
// "MaxResults": number,
// "NextToken": "string",
// "RoleLevel": boolean,
// "StatementName": "string",
// "Status": "string"
// }
rest.AddHeader("Content-Type", value: "application/x-amz-json-1.1")
rest.AddHeader("X-Amz-Target", value: "RedshiftData.ListStatements")
let sbRequestBody = CkoStringBuilder()
json.EmitSb(sbRequestBody)
let sbResponseBody = CkoStringBuilder()
success = rest.FullRequestSb("POST", uriPath: "/", requestBody: sbRequestBody, responseBody: sbResponseBody)
if success != true {
print("\(rest.LastErrorText)")
return
}
var respStatusCode: Int = rest.ResponseStatusCode.intValue
print("response status code = \(respStatusCode)")
if respStatusCode != 200 {
print("Response Header:")
print("\(rest.ResponseHeader)")
print("Response Body:")
print("\(sbResponseBody.GetAsString())")
return
}
let jResp = CkoJsonObject()
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
var CreatedAt: Int
var Id: String?
var IsBatchStatement: Int
var QueryString: String?
var SecretArn: String?
var StatementName: String?
var Status: String?
var UpdatedAt: Int
var j: Int
var count_j: Int
var name: String?
var value: String?
var strVal: String?
var NextToken: String? = jResp.StringOf("NextToken")
var i: Int = 0
var count_i: Int = jResp.SizeOfArray("Statements").intValue
while i < count_i {
jResp.I = i
CreatedAt = jResp.IntOf("Statements[i].CreatedAt").intValue
Id = jResp.StringOf("Statements[i].Id")
IsBatchStatement = jResp.IntOf("Statements[i].IsBatchStatement").intValue
QueryString = jResp.StringOf("Statements[i].QueryString")
SecretArn = jResp.StringOf("Statements[i].SecretArn")
StatementName = jResp.StringOf("Statements[i].StatementName")
Status = jResp.StringOf("Statements[i].Status")
UpdatedAt = jResp.IntOf("Statements[i].UpdatedAt").intValue
j = 0
count_j = jResp.SizeOfArray("Statements[i].QueryParameters").intValue
while j < count_j {
jResp.J = j
name = jResp.StringOf("Statements[i].QueryParameters[j].name")
value = jResp.StringOf("Statements[i].QueryParameters[j].value")
j = j + 1
}
j = 0
count_j = jResp.SizeOfArray("Statements[i].QueryStrings").intValue
while j < count_j {
jResp.J = j
strVal = jResp.StringOf("Statements[i].QueryStrings[j]")
j = j + 1
}
i = i + 1
}
// A sample JSON response body parsed by the above code:
// {
// "NextToken": "string",
// "Statements": [
// {
// "CreatedAt": number,
// "Id": "string",
// "IsBatchStatement": boolean,
// "QueryParameters": [
// {
// "name": "string",
// "value": "string"
// }
// ],
// "QueryString": "string",
// "QueryStrings": [
// "string"
// ],
// "SecretArn": "string",
// "StatementName": "string",
// "Status": "string",
// "UpdatedAt": number
// }
// ]
// }
}