regarding response to the service

Dedicated to DataStage and DataStage TX editions featuring IBM<sup>®</sup> Service-Oriented Architectures.

Moderators: chulett, rschirm

Post Reply
suryadev
Premium Member
Premium Member
Posts: 211
Joined: Sun Jul 11, 2010 7:39 pm

regarding response to the service

Post 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.
Thanks,
Surya
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

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

"You can never have too many knives" -- Logan Nine Fingers
suryadev
Premium Member
Premium Member
Posts: 211
Joined: Sun Jul 11, 2010 7:39 pm

Post by suryadev »

how can I check the format of the response,
the binding is SOAP over HTTP.
Thanks,
Surya
lstsaur
Participant
Posts: 1139
Joined: Thu Oct 21, 2004 9:59 pm

Post by lstsaur »

Look at the response parameters of the WSDL.
suryadev
Premium Member
Premium Member
Posts: 211
Joined: Sun Jul 11, 2010 7:39 pm

Post 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?
Thanks,
Surya
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post 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
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
suryadev
Premium Member
Premium Member
Posts: 211
Joined: Sun Jul 11, 2010 7:39 pm

Post by suryadev »

which format does the dataflow in a job which is invoked as a service

if the binding is SOAP over HTTP.
Thanks,
Surya
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post by eostic »

I'm sorry...I don't understand your question.....

Ernie
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
suryadev
Premium Member
Premium Member
Posts: 211
Joined: Sun Jul 11, 2010 7:39 pm

Post 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.
Thanks,
Surya
eostic
Premium Member
Premium Member
Posts: 3838
Joined: Mon Oct 17, 2005 9:34 am

Post 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
Ernie Ostic

blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Post Reply