Uploading and downloading

You can set up your Web UI Framework (WUF) applications to attach files to records of a table, upload files, and download attached files. Uploads and downloads flow between internal file systems and the application database.

With this feature, you can do the following:
  • Perform a file upload or download in a single transaction.
  • Have multiple file uploads within a single API call.
  • Restrict the types and sizes of files being uploaded.
  • Perform authentication during a file download.
  • Perform authorization during a file download.
  • Download one file at a time.
  • Attach more than one document per record.

This feature has the following limitations:

  • Two or more files with the same name cannot be uploaded and attached to a particular record of a database table. The application must have customized validation to prevent two or more files with the same name from being uploaded.
  • It is not supported for the Console UI Framework, HTTPTester, End Point, and remote clients.
  • In Windows, file names are case-insensitive within a particular directory, but in Linux®, file names are case-sensitive. At the Sterling Application Platform level, the case insensitivity of file names will not be checked before the files are imported into the database. That is, at the Sterling Application Platform level, abc.txt and ABC.txt are two different files. Application developers will have to decide if the application allows files of the same name but in different cases to be uploaded for a record of a database table.