PowerBuilder

Download S3 CloudTrail Log and Un-Gzip

See more Amazon S3 Examples

Demonstrates how to download a Amazon CloudTrail log from an S3 bucket. The file in this example is a .json.gz. The file is uncompressed and the JSON parsed. PowerBuilder

integer li_rc
long li_Success
oleobject loo_Http
string ls_BucketName
string ls_ObjectName
string ls_LocalFilePath
long li_StatusCode
string ls_JsonPath
oleobject loo_Gzip
oleobject loo_Json

li_Success = 0

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

loo_Http = create oleobject
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")
if li_rc < 0 then
    destroy loo_Http
    MessageBox("Error","Connecting to COM object failed")
    return
end if

loo_Http.AwsAccessKey = "AWS_ACCESS_KEY"
loo_Http.AwsSecretKey = "AWS_SECRET_KEY"
loo_Http.AwsRegion = "us-west-2"
loo_Http.AwsEndpoint = "s3-us-west-2.amazonaws.com"

ls_BucketName = "chilkat.logs"
ls_ObjectName = "/AWSLogs/957491831129/CloudTrail/us-west-1/2016/11/12/957491831129_CloudTrail_us-west-1_20161112T1335Z_umXfD4RxHE5nDGuI.json.gz"
ls_LocalFilePath = "qa_output/cloudTrailLog.json.gz"

li_Success = loo_Http.S3_DownloadFile(ls_BucketName,ls_ObjectName,ls_LocalFilePath)
if li_Success <> 1 then
    Write-Debug loo_Http.LastErrorText
    destroy loo_Http
    return
end if

li_StatusCode = loo_Http.LastStatus
if li_StatusCode <> 200 then
    Write-Debug "Failed to download, response status code = " + string(li_StatusCode)
    destroy loo_Http
    return
end if

ls_JsonPath = "qa_output/cloudTrailLog.json"
loo_Gzip = create oleobject
li_rc = loo_Gzip.ConnectToNewObject("Chilkat.Gzip")

li_Success = loo_Gzip.UncompressFile(ls_LocalFilePath,ls_JsonPath)
if li_Success = 0 then
    Write-Debug loo_Gzip.LastErrorText
    destroy loo_Http
    destroy loo_Gzip
    return
end if

loo_Json = create oleobject
li_rc = loo_Json.ConnectToNewObject("Chilkat.JsonObject")

loo_Json.LoadFile(ls_JsonPath)
loo_Json.EmitCompact = 0
Write-Debug loo_Json.Emit()

//  Sample JSON is shown below.
//  Go to http://tools.chilkat.io/jsonParse.cshtml 
//  and copy/paste the JSON into the online tool to generate parsing code.

//  {
//    "Records": [
//      {
//        "eventVersion": "1.05",
//        "userIdentity": {
//          "type": "Root",
//          "principalId": "954591834127",
//          "arn": "arn:aws:iam::954591834127:root",
//          "accountId": "954591834127",
//          "accessKeyId": "ASIAJ3DEMXUXI43B6FYQ",
//          "sessionContext": {
//            "attributes": {
//              "mfaAuthenticated": "false",
//              "creationDate": "2016-11-12T13:09:31Z"
//            }
//          }
//        },
//        "eventTime": "2016-11-12T13:34:39Z",
//        "eventSource": "cloudtrail.amazonaws.com",
//        "eventName": "DescribeTrails",
//        "awsRegion": "us-west-1",
//        "sourceIPAddress": "98.228.98.57",
//        "userAgent": "console.amazonaws.com",
//        "requestParameters": {
//          "trailNameList": [
//          ]
//        },
//        "responseElements": null,
//        "requestID": "c2a0376c-a8dc-11e6-89e7-85ac5ce5ee56",
//        "eventID": "eb5afd70-dae1-41f0-82b4-91c3c936d9ba",
//        "eventType": "AwsApiCall",
//        "recipientAccountId": "954591834127"
//      }
//    ]
//  }


destroy loo_Http
destroy loo_Gzip
destroy loo_Json