Upload and Store
APEX Collection
Image Uploader Pro supports uploading and storing files directly into APEX collections. In order to implement this functionality, the following settings need to be set:
| Attribute Name | Attribute Value | Description |
|---|---|---|
| Storage type | APEX Collection | - |
| Collection / Table Name | DROPZONE_UPLOAD | Keep the default collection name or change it to any value |
Custom Table
Image Uploader Pro supports uploading and storing files directly into a custom table and allows you to define the custom columns where file metadata will be saved.
Furthermore, it supports foreign key column and item definitions. Images will be ready in your table without the need of further metadata manipulation.
In order to have this functionality, the following settings need to be set:
| Attribute Name | Attribute Value | Description |
|---|---|---|
| Storage Type | Custom Table | - |
| PK Column | ID | Varchar2/Number column where the primary key will be returned. The Primary Key (PK) must be processed with a Before Insert Trigger. The column value is used for after upload processing. |
| MIME Type Column | MIME_TYPE | Varchar2 column where the MIME type will be saved. |
| Filename Column | FILENAME | Varchar2 column where the name of the file will be saved. |
| FK Item | P4_FOREIGN_KEY | Item where the foreign key value is calculated. Values have to be in session state before loading the upload form. |
| FK Column | FK_ID | Varchar2/Number column where the foreign Key will be saved. |
| Date Column | CREATED_ON | Optional date field, where the upload date will be saved. |
| Collection / Table Name | IUP_IMAGES | Name of the destination table where the images will be saved. |
| BLOB Column | BLOB_CONTENT | BLOB Column where the file contents will be saved. |
Web Service
Image Uploader Pro allows you to push your images to a Web Service directly from the client, avoiding database interaction.
In order to have this functionality, the following settings need to be set:
| Attribute Name | Attribute Value | Description |
|---|---|---|
| Storage Type | Web service | - |
| Web service parameters | {"url":"https://example.com/upload/image","method":"POST","headers": {"Authorization":"Bearer x"}} | The JSON file with the Web service parameters has to include the following settings: - URL: End-point of the web service - Method: POST/PUT depending on your web service needs - Headers: HTTP-Headers object |