example xml to use for soap webservices

mike.whitlock · June 15, 2014, 6:51pm

Hi, I am just trying to create a new card using webservices through Soap Sonar (a soap testing tool). I can connect to the wsdl but get authentication errors when I try to do anything. I am just trying to use username = admin and password = admin. I read in the pdf about WSS but not sure how to do this in a XML. Does anyone have an example XML I can see to do a simple create card? Thanks Mike mwhitlock@ercot.com

mike.whitlock · June 16, 2014, 1:33am

I read on another post that…

Passwords have to be digested, unless the property force.ws.password.digest is set to false in auth.conf

If I make this change, can I just use basic authentication? If anyone has an example xml that is sent to the wdsl to create or update a card would help out so much. Please help!!!

Thanks in advance,

Mike

tecnoteca · June 16, 2014, 8:11am

Hi Mike, yes, as you read the password needs to be digested.

If you want to use the text password you need to:

1. stop tomcat

2. open the file ${cmdbuild_webapp}/WEB-INF/classes/org/cmdbuild/soapws-r1.xml

2. remove the comment marked as "Fix for non-standard webservice clients" that adds a new bean to the xml: <ref bean="addDefaultNamespaceInterceptor"/>

3. restart tomcat

Best regards,

the CMDBuild Team

mike.whitlock · June 16, 2014, 3:26pm

Thank you for your response. I did make that change as you said. After restarting tomcat, I logged into SoapUI and I am trying to use createCard. I am using username = admin and password = admin in the properties. I will put the xml and the response that I get back from SoapUI below. Based of those xmls, can you give me advice on how to get this to work and create a new Card through this web service? Thank you very much again!!!

Here are the xmls...

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:soap1="http://soap.services.cmdbuild.org">

<soap:Header/>

<soap:Body>

<soap1:createCard>

<soap1:cardType>

<soap1:attributeList>

<soap1:code>123</soap1:code>

<soap1:name>soapui1</soap1:name>

<soap1:value>1234</soap1:value>

</soap1:attributeList>

<soap1:beginDate></soap1:beginDate>

<soap1:className>Server</soap1:className>

<soap1:endDate></soap1:endDate>

<soap1:id>1000</soap1:id>

<soap1:metadata>

<soap1:key>soapui1</soap1:key>

<soap1:value>1234</soap1:value>

</soap1:metadata>

<soap1:user>admin</soap1:user>

</soap1:cardType>

</soap1:createCard>

</soap:Body>

</soap:Envelope>

I just get this response back...

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope">

<soap:Body>

<soap:Fault>

<soap:Code>

<soap:Value>soap:Sender</soap:Value>

<soap:Subcode>

<soap:Value xmlns:ns1="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd">ns1:InvalidSecurity</soap:Value>

</soap:Subcode>

</soap:Code>

<soap:Reason>

<soap:Text xml:lang="en">An error was discovered processing the <wsse:Security> header</soap:Text>

</soap:Reason>

</soap:Fault>

</soap:Body>

</soap:Envelope>

Please help.

mike.whitlock · June 16, 2014, 3:33pm

FYI… I just saw that in Request Properties in SoapUI, I had WSS-Pasword Type = None in the example above. If I change this drop down to WSS-Password Type = PasswordText then I get this response back…

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope">

<soap:Body>

<soap:Fault>

<soap:Code>

<soap:Value>soap:Sender</soap:Value>

</soap:Code>

<soap:Reason>

<soap:Text xml:lang="en">Unmarshalling Error:</soap:Text>

</soap:Reason>

</soap:Fault>

</soap:Body>

</soap:Envelope>

I am not sure what option to select on this, but wanted to show all the info so hopefully someone can help me get this web service to actually create a card. Thanks again.

Mike

mike.whitlock · June 16, 2014, 9:57pm

UPDATE… I changed the request again and now get a new error. I think it is actually receiving the request now because the error says “Fault occurred while processing.” Can someone help me out on what values to enter on the xml request??? Thanks, Mike

request...

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:soap1="http://soap.services.cmdbuild.org">

<soap:Header/>

<soap:Body>

<soap1:createCard>

<soap1:cardType>

<soap1:attributeList>

<soap1:code>123</soap1:code>

<soap1:name>soapuitest</soap1:name>

<soap1:value>1234</soap1:value>

</soap1:attributeList>

<soap1:id>100000</soap1:id>

<soap1:metadata>

<soap1:key>soapuitest</soap1:key>

<soap1:value>1234</soap1:value>

</soap1:metadata>

<soap1:user>admin</soap1:user>

</soap1:cardType>

</soap1:createCard>

</soap:Body>

</soap:Envelope>

response...

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope">

<soap:Body>

<soap:Fault>

<soap:Code>

<soap:Value>soap:Receiver</soap:Value>

</soap:Code>

<soap:Reason>

<soap:Text xml:lang="en">Fault occurred while processing.</soap:Text>

</soap:Reason>

</soap:Fault>

</soap:Body>

</soap:Envelope>

tecnoteca · June 17, 2014, 7:05am

Mike, it looks like you don't have inserted any credential because the Header tag is empty.

<soap:Header/>

Best regards,

the CMDBuild Team

mike.whitlock · June 17, 2014, 4:16pm

Thanks again. Here is the request with the header information. What I am asking is what fields do I need to put data into to create a card in the xml? For example, do I need to put a value in for the id field (and if so what number do I put here or is it auto-generated). What other fields are required because I just keep getting errors.

Sent...

soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:soap1="http://soap.services.cmdbuild.org">

<soap:Header><wsse:Security soap:mustUnderstand="true" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd"><wsse:UsernameToken wsu:Id="UsernameToken-79D9ADA18644B2B346140302128070912"><wsse:Username>admin</wsse:Username><wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">admin</wsse:Password><wsse:Nonce EncodingType="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-soap-message-security-1.0#Base64Binary">tKiHqVbkmE4Bwe7quSLFAg==</wsse:Nonce><wsu:Created>2014-06-17T16:08:00.708Z</wsu:Created></wsse:UsernameToken></wsse:Security></soap:Header>

<soap:Body>

<soap1:createCard>

<soap1:cardType>

<soap1:attributeList>

<soap1:code>1</soap1:code>

<soap1:name>2</soap1:name>

<soap1:value>3</soap1:value>

</soap1:attributeList>

<soap1:beginDate>2014-06-17</soap1:beginDate>

<soap1:className>Asset</soap1:className>

<soap1:endDate>2014-07-17</soap1:endDate>

<soap1:id>777</soap1:id>

<soap1:metadata>

<soap1:key>8</soap1:key>

<soap1:value>9</soap1:value>

</soap1:metadata>

<soap1:user>10</soap1:user>

</soap1:cardType>

</soap1:createCard>

</soap:Body>

</soap:Envelope>

Response...

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope">

<soap:Body>

<soap:Fault>

<soap:Code>

<soap:Value>soap:Receiver</soap:Value>

</soap:Code>

<soap:Reason>

<soap:Text xml:lang="en">Fault occurred while processing.</soap:Text>

</soap:Reason>

</soap:Fault>

</soap:Body>

</soap:Envelope>

Any help?

mike.whitlock · June 17, 2014, 5:37pm

Thanks again for the response. Here is the request and response with the header information but I keep getting "Fault occurred while processing". What I am looking for is what fields are required for the CreateCard to actually create a card?

request...

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:soap1="http://soap.services.cmdbuild.org">

<soap:Header><wsse:Security soap:mustUnderstand="true" xmlns:wsse="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" xmlns:wsu="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd"><wsse:UsernameToken wsu:Id="UsernameToken-79D9ADA18644B2B346140302654425915"><wsse:Username>admin</wsse:Username><wsse:Password Type="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText">admin</wsse:Password><wsse:Nonce EncodingType="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-soap-message-security-1.0#Base64Binary">lb2zldM7WyD9SsDpLluIgA==</wsse:Nonce><wsu:Created>2014-06-17T17:35:44.259Z</wsu:Created></wsse:UsernameToken></wsse:Security></soap:Header>

<soap:Body>

<soap1:createCard>

<soap1:cardType>

<soap1:attributeList>

<soap1:code>1</soap1:code>

<soap1:name>2</soap1:name>

<soap1:value>3</soap1:value>

</soap1:attributeList>

<soap1:beginDate>2014-06-17</soap1:beginDate>

<soap1:className>5</soap1:className>

<soap1:endDate>2014-07-17</soap1:endDate>

<soap1:id>777</soap1:id>

<soap1:metadata>

<soap1:key>8</soap1:key>

<soap1:value>9</soap1:value>

</soap1:metadata>

<soap1:user>10</soap1:user>

</soap1:cardType>

</soap1:createCard>

</soap:Body>

</soap:Envelope>

response...

<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope">

<soap:Body>

<soap:Fault>

<soap:Code>

<soap:Value>soap:Receiver</soap:Value>

</soap:Code>

<soap:Reason>

<soap:Text xml:lang="en">Fault occurred while processing.</soap:Text>

</soap:Reason>

</soap:Fault>

</soap:Body>

</soap:Envelope>

mike.whitlock · June 18, 2014, 1:46am

I was able to get the web services to work. Thanks -Mike