Page 1 of 1
regarding response to the service
Posted: Tue Jul 13, 2010 2:28 pm
by suryadev
I used a WISD input and WISD output to invoke the job as a service,
Used a tool to test the service but the thing is if there are 5 fields but I get the response as 3 fields because other 2 fields have null values.
Is there any way where I could see null in the response for those two fields.
Posted: Tue Jul 13, 2010 2:48 pm
by chulett
Is your response in XML? If so, there should be an option to convert those nulls to an empty element rather than exlude them, I believe.
Posted: Tue Jul 13, 2010 3:11 pm
by suryadev
how can I check the format of the response,
the binding is SOAP over HTTP.
Posted: Wed Jul 14, 2010 11:33 am
by lstsaur
Look at the response parameters of the WSDL.
Posted: Wed Jul 14, 2010 3:50 pm
by suryadev
this are the response parameters
<element name="school_nm" nillable="true" type="xsd:string"/>
<element name="school_cd" nillable="true" type="xsd:string"/>
<element name="city" nillable="true" type="xsd:string"/>
<element name="state" nillable="true" type="xsd:string"/>
<element name="zip" nillable="true" type="xsd:string"/>
can anyone tell me which format is this?
Posted: Wed Jul 14, 2010 5:51 pm
by eostic
I'm not entirely sure, but I think the SOAP representation for a null xml element (one that is allowed to be nillable, as you showed us above) is to simply not include it in the body. The tool receiving the response should know that if the element isn't present, it must be null.......
xml is very flexible with null values.....they can be "not present" or present and have an attribute of null="true", or have some type of application value (blanks or a string like "null" as a value).
Try some other tools for testing to compare.
Ernie
Posted: Thu Jul 15, 2010 8:51 am
by suryadev
which format does the dataflow in a job which is invoked as a service
if the binding is SOAP over HTTP.
Posted: Thu Jul 15, 2010 10:44 am
by eostic
I'm sorry...I don't understand your question.....
Ernie
Posted: Thu Jul 15, 2010 11:57 am
by suryadev
The response to the service in the form of data is passing by in the job.
so if the client requires an output or the response in XML how can I do that?
by using XML output stage before WISD output stage........do I get the output in XML format.
Posted: Thu Jul 15, 2010 2:24 pm
by eostic
Yes.... just put a single column on the output link of your xmlOutput Stage....make it longvarchar with some long length and put a single "/" in the Description.......the whole completed xml will go into a single column.
...test it first by sending to a flat file with no delimiter and no quote characters......
...then send that to your wisdOutput Stage.
Ernie