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:

<ns0:GenericRequest webKey="CS">
<ns0:Service  IdcService="CHECKIN_NEW">
<ns0:Document>
<ns0:Field name="dDocTitle">test.csv</ns0:Field>
<ns0:Field name="dDocType">Document</ns0:Field>
<ns0:Field name="dSecurityGroup">FAFusionImportExport</ns0:Field>
<ns0:Field name="dDocAccount">fin$/payables$/importExport$</ns0:Field>
<ns0:File href="test.csv" name="primaryFile">
<ns0:Contents>TmFtZSxJRCxBZ2UsRGVwdAp0ZXN0LDIsMjMsT1NQCg=</ns0:Contents>
</ns0:File>
</ns0:Document>
</ns0:Service>
</ns0:GenericRequest>

Note: we can also add dUser, dDocAuthor and other fields as required.

Detailed steps with Screenshots:

Create a soap connection with the below wsdl :

https://<erp_instance>:443/idcws/GenericSoapPort?wsdl



Integration flow:


Write a CSV file:









Call the SOAP adpater and configure:





Map the required details:



Go to UCM server and check the file:
https://<erp_instance>/cs



We can also check the file from below navigation:

Login erp instance >> tools >>File import and export >> search with file name and account details:



No comments:

Post a Comment

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...