With the Amazon S3 Collector and Amazon S3 Forwarder functions you can send and receive data to and from Amazon S3 buckets.

Before using the functions you must ensure that the Amazon S3 bucket(s) are setup using an IAM policy with the following minimum content:

{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Sid": "AllowGetPutDelete",
            "Effect": "Allow",
            "Action": [
                "s3:GetObject*",
                "s3:PutObject*",
                "s3:DeleteObject*",
                "s3:AbortMultipartUpload",
                "s3:ListMultipartUploadParts"
            ],
            "Resource": "arn:aws:s3:::<bucket-name>/*"
        },
        {
            "Sid": "AllowListingBucket",
            "Effect": "Allow",
            "Action": [
                "s3:ListBucket",
                "s3:ListBucketMultipartUploads"
            ],
            "Resource": "arn:aws:s3:::<bucket-name>"
        }
    ]
}

"Resource": "arn:aws:s3:::<bucket-name>/*" means that actions in a statement are applicable to all objects in the S3 bucket arn:aws:s3:::<bucket-name>.

If you only want to share a certain key (folder) in the S3 bucket, you can specify the folder after the bucket name like this: arn:aws:s3:::<bucket-name>/<directory-to-share>/* in the Resource section, but this is only applicable for the AllowGetPutDelete statement.

See https://docs.aws.amazon.com/s3/ for more information on how to setup IAM policies.

To connect to your bucket, you need to have your Access Key and Secret Access Key, see https://docs.aws.amazon.com/general/latest/gr/managing-aws-access-keys.html for information on how to find this information. You also need to enter the folder from or to which you are collecting or sending data.

See Stream using Amazon S3 Functions - Acme EV for an example how the Amazone S3 collector and forwarder can be used in a stream.

Common Configurations

For both functions, you need to configure AWS Credentials and File location.

AWS Credentials

The AWS Credentials can either be specified directly in the configuration dialog for the functions, or in an AWS Secret in the Secrets Wallet, and must contain:

File location

The File location settings include:

Amazon S3 Collector Configuration

With the Amazon S3 Collector you can collect data from your AWS S3 bucket for processing in your stream.

To configure the Amazon S3 collector:

1. Place the function in your stream and double-click to open the Configuration dialog.
   

   

2. Configure the Common Configurations as described above.
   All files in the subfolder(s) to the main folder stated in the Folder field will be collected. You can also choose to not include files from any subfolders by selecting the Do not include files from subfolders checkbox.  

3. In the After Collection section you can select to Remove files from Amazon server after collection. 

4. In File information section you can specify the selection criteria for your files including how to Select files and the File format:

Setting	Description
File selection
All files in folder	Select this option to collect all files in the specified folder.
Based on filename	Select this option to collect files based on specific file names. You can specify one or several file names.
Based on regular expression	Select this option to collect files based on file name patterns that you state using regular expressions.
Based on list of files	Select this option to collect files using a meta file containing the path to another file. If there is more than one meta file present, they will be processed simultaneously. You need to specify the following for the meta file: There are also three mandatory prerequisites for this option: If there are more than one meta file, all of them need to be stored in the same folder. The meta files must be in CSV format with a single header. If this type of collection is no longer used, the meta file must be removed manuall
File format	Depending on what option you select in the this drop-down, you will see different complimentary settings beneath the drop-down list.
CSV	Select this option to collect files in CSV format. Select the Include table header check box to include the table header in the collected file(s). Select the delimiter for the CSV file(s) in the Delimiter field. Comma is selected by default but you can also select Tab, Semicolon, Space, or Other. If you select Other you can specify a custom delimiter in the Custom delimiter field that will then be displayed.
Excel	Select this option to collect files in Excel format. Select the Include table header check box to include the table header in the collected file(s). Select the All sheets in file option to collect everything in the file, or the Specific Sheet(s) option to specify which sheets you want to collect in the Select sheet(s) field that will be displayed.
JSON	Select this option to collect files in XML format.
XML	Select this option to collect files in XML format

You have now configured the Amazon S3 Collection function.

Amazon S3 Forwarder

With the Amazon S3 Forwarder function you can send data to an Amazon S3 bucket from your stream.

To configure the Amazon S3 forwarder:

1. Place the function in your stream and double-click to open the Configuration dialog.
   

   

2. Configure the Common Configurations as described above.
   The folder path stated in the Folder field cannot begin or end with a '/'.

3. In Output file Information section, specify how you want to handle the output file(s) in Filename options:

4. Select the Append timestamp checkbox to append the timestamp to the name of the output file. For a CSV file, the file name will then be <myfile>_<timestamp>.csv.

5. In File format, select the format of the output file(s) from the following options:

6. File format	Description
   CSV	Select to send the output file in CSV format. Select Include table header to include the table header in the output file(s). Specify a Delimiter for the CSV file format. The default value is ' , '. Compression can be toggled by enabling the Compress file option. A dropdown menu is used to select the format – Zip and GZIP are supported.  An additional option toggles the Bucket owner full control.
   Excel	Select to send the output file in Excel format. You can also specify the Sheet name. The default sheet name is Sheet 1. Compression can be toggled by enabling the Compress file option. A dropdown menu is used to select the format – Zip and GZIP are supported.  An additional option toggles the Bucket owner full control.
   Buffer	Select to send the output file in the Buffer format.  If you are reading or processing files containing binary data (Buffer format), for example for performance or other reasons, you can write these files through the AWS S3 Forwarder. Compression can be toggled by enabling the Compress file option. A dropdown menu is used to select the format – Zip and GZIP are supported.  An additional option toggles the Bucket owner full control.
   JSON	Select to send the output file in JSON format. Select the preferred output format, Action on records: one file with All in one array, one file with All in one array with key, or One file per record. Note! If One file per record is selected, you must also select Append timestamp, otherwise, the files will be overwritten. Compression can be toggled by enabling the Compress file option. A dropdown menu is used to select the format – Zip and GZIP are supported.  An additional option toggles the Bucket owner full control.  JSON files can be formatted for easier reading by selecting the  Output file in pretty print option.

   
   

7. To output JSON files in a more compact form, deselect the Output file in pretty print checkbox. By default, pretty print is on.

   Note!

   Selecting pretty print increases the size of the output file.

   
   

8. To compress the output file, select the Compress file checkbox and specify the Compression format. The supported formats are:

   • Zip

   • GZip

9. You have the option to provide the S3 bucket owners full access to the object that are written by other S3 account holders. Select the checkbox, Bucket owner full control, to give this permission. To be able to do this Usage Engine uses an option called as Access Control List (ACL) and is enabled as ACL = bucket-owner-full-control.

Amazon S3 Metadata

You can view and access the following metadata properties of Amazon S3. To view the metadata, see the documentation of the meta object mentioned in the Script function.

log.info(meta.fileName);

log.info(meta.filePath);

log.info(meta.fileSize); 

log.info(meta.sheetName);

log.info(meta.collectionTime);