How To Upload/Download Attachments to UCM using OIC

In the previous blog we discussed about how to upload and download attachments in VBCS and also how to implement OJ-FILE-PICKER in your VBCS application. For more info, you can check out the blog – Uploading a file in VBCS using file picker.

Problem

What if you want to store your attachments temporarily or you don’t have database instance available?

Solution

In this blog we will explain how to upload & download attachments to UCM through OIC.

WSDL : https://{xxx}/idcws/GenericSoapPort?wsdl

Step 1: Upload.

Step 2: Here we have created App driven integration which accepts below parameter.

Step 3: Using the standard oracle SOAP web-service connection with below mentioned details.

The operation should accept attachment as a response and send attachment as a request.

Once the process is successfully completed, it will return the unique content id which can be used as a reference to download the attachment from UCM when required.

Attachment: Upload request

Attachment: Upload response

Step 4: Download.

In this section, we have created App driven Integration to download the same attachment which we have uploaded to UCM service.

Step 5: Here we have query parameter in the integration which accepts document name as input.

Step 6: Use the standard oracle SOAP web-service connection with below mentioned details.

The operation should accept attachment as a response and send attachment as a request.

Once the process is successful, it will return the file content in base64 along with the file details such as file name, file size etc.

Attachment: Download request

Karan Tulsani

Karan works as the Delivery Head at Conneqtion Group, a Oracle iPaaS and Process Automation company. He has an extensive experience with various Banking and financial services, FMCG, Supply chain management & public sector clients. He has also led/been part of teams in multitude of consulting engagements. He was part of Evosys and Oracle’s consulting team previously and worked for clients in NA, EMEA & APAC region.