Unable to extract fields from WSDL

Anonymous — Sat, 16 Nov 2024 02:28:04 GMT

Hi,

I have a requirement for a project to extract fields from a WSDL. It is a P6 Primavera WSDL:

https://pr2006-04-01.myloadspring.com/p6ws/services/ActivityCodeService?wsdl

we have user authentication enabled for this. The below is the expected scenario:

Input>><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v1="http://xmlns.oracle.com/Primavera/P6/WS/ActivityCode/V1">
<soapenv:Header/>
<soapenv:Body>
<v1:ReadActivityCodes>

<v1:Field>CodeValue</v1:Field>
<v1:Field>Description</v1:Field>
<v1:Field>ParentObjectId</v1:Field>
<v1:Field>CodeTypeName</v1:Field>

<v1:Filter>CodeTypeName='Global Activity Code'</v1:Filter>
</v1:ReadActivityCodes>
</soapenv:Body>
</soapenv:Envelope>

output>> <SOAP-ENV:Envelope xmlnsOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
<SOAP-ENV:Header>
<work:WorkContext xmlns:work="http://oracle.com/weblogic/soap/workarea/">rO0ABXdOABV3ZWJsb2dpYy5hcHAucDZ3c1BERVYAAADWAAAAI3dlYmxvZ2ljLndvcmthcmVhLlN0cmluZ1dvcmtDb250ZXh0AAgxNi4yLjkuMAAA</work:WorkContext>
</SOAP-ENV:Header>
<SOAP-ENV:Body>
<ReadActivityCodesResponse xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.oracle.com/Primavera/P6/WS/ActivityCode/V1">
<ActivityCode>
<CodeTypeName>Global Activity Code</CodeTypeName>
<CodeValue>PXP</CodeValue>
<Description>Project Execution Plan Approval</Description>
<ObjectId>400378</ObjectId>
<ParentObjectId>400604</ParentObjectId>
</ActivityCode>
<ActivityCode>
<CodeTypeName>Global Activity Code</CodeTypeName>
<CodeValue>PPSRM</CodeValue>
<Description>Project Planning Scope Review Meeting</Description>
<ObjectId>400379</ObjectId>
<ParentObjectId>400604</ParentObjectId>
</ActivityCode>……….

I want the values of the fields CodeTypeName, CodeValue, Description, ObjectId, ParentObjectId in a tabular/CSV format.

I tried tWebService_1 component. However it throws me the below error:

"Exception in component tWebService_1 (Job_P6_To_ACQ_Extracts_000)
org.apache.cxf.binding.soap.SoapFault: WSS header is missing from request. Can't do username token authentication.
at org.apache.cxf.binding.soap.interceptor.Soap11FaultInInterceptor.unmarshalFault(Soap11FaultInInterceptor.java:86)
at org.apache.cxf.binding.soap.interceptor.Soap11FaultInInterceptor.handleMessage(Soap11FaultInInterceptor.java:52)
at org.apache.cxf.binding.soap.interceptor.Soap11FaultInInterceptor.handleMessage(Soap11FaultInInterceptor.java:41)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:308)
at org.apache.cxf.interceptor.AbstractFaultChainInitiatorObserver.onMessage(AbstractFaultChainInitiatorObserver.java:112)
at org.apache.cxf.binding.soap.interceptor.CheckFaultInterceptor.handleMessage(CheckFaultInterceptor.java:69)
at org.apache.cxf.binding.soap.interceptor.CheckFaultInterceptor.handleMessage(CheckFaultInterceptor.java:34)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:308)
[FATAL]: edwprojectfinancial.job_p6_to_acq_extracts_000_0_1.Job_P6_To_ACQ_Extracts_000 - tWebService_1 WSS header is missing from request. Can't do username token authentication."

I have attached the screenshots of all the components involved and their parameters along with the overall job design. Can you please let me know if I am doing anything wrong here or is there another way of doing it?

Regards,

Debadutta

topic Unable to extract fields from WSDL in Talend Studio

Unable to extract fields from WSDL