DynamicFileNames.md

Dynamic file names are tricky

Sources

Amazon S3 Bucket

Amazon S3 buckets can use dynamically named sources through In-Out parameters. These can be assigned using taskflows.

1. In a Taskflow, create an assignment task and add a function.

2. Add a template file to your S3 bucket that includes all headers and full example of the dynamic file name (for example, MyFile_20230512.csv). This file will need to remain in your bucket for the life of the integration/mapping.

3. Add into the Mapping Task source Advanced settings the input parameter from the Assignment task.

Targets

Flat File

Flat Files are able to be named dynamically using the "Dynamic File Name" property when creating a new target at runtime. Official documentation on this process can be found In This Document.

Flat files can also be set up to output to a dynamic file name based on date in the same way an S3 bucket can. Refer to the section below.

Amazon S3 Bucket

Amazon S3 connections can be set up to output to a dynamic file name based on the date using special characters. Official Documentation on this process can be found In This Document.

S3 Bucket targets can also be renamed via in-out parameters, similar to the process above used for dyanmic source filenames. Official documentation can be found At This Page.

Box

Box connections are unable to output dynamically named files of any kind. If dynamic file naming is an absolute requirement for your integration, use a different service to host target files.