Thursday, July 6, 2023

OIC -Upload file to UCM using Rest service

Usecase: Here I will show you how to create a csv file into stage and upload the file to UCM using rest service.

Rest service URI used:

/fscmRestApi/resources/11.13.18.05/erpintegrations

Sample request payload:

{

  "OperationName":"uploadFileToUCM",

  "DocumentContent":"UEsDBBQAAAAIABCInEgIHJSKCgAAAAgAAAAIAAAAdGVzdC50eHRzTEpWCEktLgEAUEsBAh8AFAAAAAgAEIicSAgclIoKAAAACAAAAAgAJAAAAAAAAAAgAAAAAAAAAHRlc3QudHh0CgAgAAAAAAABABgAW4FRYEGh0QEBIE9gQaHRAckeCWBBodEBUEsFBgAAAAABAAEAWgAAADAAAAAAAA==",

  "DocumentAccount":"fin$/payables$/import$",

  "ContentType":"zip",

  "FileName":"Test.zip",

  "DocumentId":null

}

About Request parameters:

  • OperationName: uploadFileToUCM
  • Document content: base64 encoded file. Here, I have used oraext:encodeReferenceToBase64() to encode from file reference to base64.
  • DocumentAccount: "fin$/payables$/import$" >> anyone you need
  • Content type: Document or zip
  • Filename : give the file name which to be uploaded to UCM


Detailed steps with screenshots:

Create a rest connection 



Integration flow:


Create a csv file into stage:







Call rest service to upload file:






References:


OIC - Upload file to UCM using webservice | ErpIntegrationService

Usecase: Here I will show you how to create a csv file into stage and upload the file to UCM using ErpIntegrationService webservice as follows:

  1. Call uploadFileToUcm operation and update the following in the mapping:
    1. Document content: base64 encoded file. Here, I have used oraext:encodeReferenceToBase64() to encode from file reference to base64.
    2. Filename : give the file name which to be uploaded to ucm
    3. Content type: file type(csv, Document or zip)
    4. DocumentTitle: filename
    5. DocumentSecurityGroup: FAFusionImportExport
    6. DocumentAccount: "fin$/payables$/import$" >> anyone you need

Detailed steps with screenshots:

Create a soap connection with

https://<erp_instance>/fscmService/ErpIntegrationService?wsdl



Integration flow:


Create a csv file into stage:






Call soap service to upload file:





Map the required fields:





Monday, July 3, 2023

OIC - Download file from ucm using webservice | ErpIntegrationService

Usecase: Here I will show you how to get the file from ucm using ErpIntegrationService webservice as follows:

Case1:

  1. First get document id by file prefix (doc title) 
  2. Second get document by document id , fetched from 1st step.
Case2:
  1. Get the document by file prefix(doc title) directly.

Detailed steps with screenshots:

Create a soap connection with

https://<erp_instance>/fscmService/ErpIntegrationService?wsdl




Case1 : Integration flow:


Call soap adapter to get doc id by file prefix







Call soap adaptet to get document by document id.






Aftet testing, got the document in base64 coded. To read it, we have to decode it.

Case2 : Integration flow


Call soap to get document by file prefix







Testing:


Sunday, July 2, 2023

OIC - Can file adapter and ftp adapter support high availability mode using connectivity agent

***The File Adapter and FTP Adapter are not supported in high availability environments. When using the File Adapter or FTP Adapter and some groups have multiple instances, use a dedicated agent group (with one agent only).

Reference:

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