Sunday, July 2, 2023
OIC - Can file adapter and ftp adapter support high availability mode using connectivity agent
Thursday, June 29, 2023
OIC - Upload file to UCM using GenericSoapPort web service
Usecase: We will create a CSV file into stage and upload the base64 encoded file to UCM using GenericSoapPort webservice.
Request Payload format to upload to UCM:
Detailed steps with Screenshots:
Create a soap connection with the below wsdl :
https://<erp_instance>:443/idcws/GenericSoapPort?wsdl
Friday, June 23, 2023
OIC - Download file from UCM using SOAP webservice | GenericSoapPort webservice
Usecase: Here, we will show you how to download files from UCM using GenericSoapPort SOAP web service.
- Get the document id with dDocTitle or file title.
- Get the file based on the fetched document id.
- Write the file content to stage.
- Read the file content.
- Delete the file from UCM based on fetched documment id.
OIC - Upload file to UCM | Download file from UCM
We can upload and download the files to/ from UCM using the following services:
- Download file from UCM using GenericSoapPort webservice
- Download file from UCM using ErpIntegrationService webservice
- Download file from UCM using ERP cloud adapter and ErpIntegration Service.
- Using rest services
Tuesday, June 20, 2023
OIC - While reading or writting a file from/to stage, getting translation to native failed. Element not completed
- Just uncheck this property - USE FIRST ROW AS COLUMN HEADERS and it will work.
- Or add header field names explitcitly in the file.
Friday, June 16, 2023
OIC - How to call "upload as attachement REST integration" from another integration in Oracle Integration
Usecase: In my previous blogs, I have shown you how to upload single or multiple attachments in REST API. Here, I will show how to call that exposed REST API service from another integration.
For upload attachment in Rest API:
https://soalicious.blogspot.com/2023/06/oic-upload-attachment-in-rest-api.html
For upload multiple attachments in REST API:
https://soalicious.blogspot.com/2023/06/oic-upload-multiple-attachements-in.html
Logic steps:
- Create an OIC self REST invoke connection so that we can call the OIC rest upload attachment service.
- Confugure a rest trigger to get the employee details as json.
- Take a stage and write a file for example Employee.csv using sample CSV file and map the request employees to the csv file.
- Drag and drop the created OIC self connection and configure rest invoke with POST verb and resource URI of the upload attachment rest service. Take the request as multipart form-data.
- Map the stage file reference to attachement reference and provide content type as "text/CSV" and partname as filename of the stage write response.
Implementation steps with screenshots:
Create OIC self connection:
- Content type should be mapped while invoking to Rest upload attachment integration. This case we have mapped as "text/CSV", otherwise you will get the error: An error occurred while invoking the rest endpoint .[[Media type is null.]]. The 406 Not acceptable is an HTTP response statue code indicating that the client has requested a response using accept-headers that the server is unable to fulfill.
Featured Post
11g to 12c OSB projects migration points
1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper: File⇾Import⇾Service Bus Resources⇾ Se...
-
Please find the following links for OIC hands on and relevant information: Oracle Integration Cloud Introduction | Benefits | Services offer...
-
Credential Store Framework (CSF) is used in OWSM to manage the secure credentials. CSF provides a way to store, retrieve, and delete cred...
-
What is Throttling: Throttling is termed as "regulate the flow". Oracle Service Bus has throttling feature and by using that f...