topic Re: How to fetch file from Oracle ucm using tsoap component in Talend Studio

How to fetch file from Oracle ucm using tsoap component

SK1694344715 — Fri, 15 Nov 2024 21:14:20 GMT

Hi Team,

I need inputs on this query ASAP.

Currently I am trying to download file from Oracle ucm using soap ui,there it is working with simple payload .

But when I try to implement same logic in talend job,getting response as XML ,but unable to retrieve file from ucm ,need help.

Referred Oracle and talend docs, not got much information on fetching file from ucm...

Re: How to fetch file from Oracle ucm using tsoap component

Anonymous — Thu, 23 Nov 2023 02:31:57 GMT

Hello,

Are you getting Message send failed when executing tSOAP component?

As SOAP cannot get all attributes individually, If the return value of Body column is a XML string, you'd better use tExtractXMLField to retrieve them.

We will appreciate it a lot if you could post your component setting screenshots here which will be helpful for us to address your issue.

Best regards

Sabrina

Re: How to fetch file from Oracle ucm using tsoap component

SK1694344715 — Thu, 23 Nov 2023 03:03:39 GMT

My requirement is to download physical file present on Oracle ucm..

Yes,I am getting body as response in XML format and can see all fields like docie,docname etc...

I have used tsoap -->tlogrow, to fetch body as response till now..

Now nest step is to retrieve file from Oracle ucm,which component we have to use...

Also, I have used tfilefetch-->tlogrow component,in response I am getting 200 Ok response, but unable to retrieve file...

Need help

Re: How to fetch file from Oracle ucm using tsoap component

Anonymous — Fri, 24 Nov 2023 03:06:10 GMT

@Satya K I'm not family with Oracle UCM API, do you have a public documentation link about the API? With tSOAP component, does the response XML string contain the file content?

Re: How to fetch file from Oracle ucm using tsoap component

SK1694344715 — Fri, 24 Nov 2023 03:17:37 GMT

Yes,

Please find the wsdl link below:

https://{host}/idcws/GenericSoapPort?wsdl

We will provide host details and load to soap ui and provide document I'd in payload,then run, in response we will get XML and file present under attachments tab...

We will provide content I'd in the payload and submit it...

If we enable MTOM under soap ui "request properties ", file content will be downloaded as Base64 in soap ui...

Unfortunately,in payload we don't have any option to pass these parameters to fetch base64(file content)...

If you can suggest how to add parameters to standard payload ,I will try it out...

This is other way to download file via web service...