Web Service (ISD Output Stage) Returning only one row
Posted: Mon Feb 20, 2012 11:21 am
Problem: After receiving the SOAP Response, I am only getting one row of XML formated data out, I should have more. For some reason, ISD web services seems to give me two options. One, output all my XML data within one row, or Two, into an array. If I output all my XML columns out, I get one row perfectly formatted the way I want it. If I change the job to output only one column with a the XML set to column_1 /, then I get all the rows in one huge line. The calling software can't parse the one line of data. I need to have multiple rows of neatly formatted XML. How do I do it?
Note to Admins: I have already searched the current posts. Nothing fits my problem exactly. I am NOT using the any of the Web Service Client stages.
Job Design Method: I have initially coded my job using input and output files to perfect the XML output format needed. Then i replaced these file stages with ISD Input and ISD output stages so as to prepare for web service deployment.
Job Design: ISD Input >> XML Input >> Transformer >> Stored Proc >> XML Output >> ISD Output
Desired Output:
<xs:schema elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="LookupResponse">
<xs:complexType mixed="true">
<xs:sequence>
<xs:element maxOccurs="unbounded" minOccurs="0" ref="DomesticLookup" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="DomesticLookup">
<xs:complexType mixed="true">
<xs:sequence>
<xs:element name="Human_Id" type="xs:string" />
<xs:element name="HH_Number" type="xs:string" />
<xs:element name="CN_First_Name" type="xs:string" />
<xs:element name="CN_Last_Name" type="xs:string" />
<xs:element name="LM_Address_1" type="xs:string" />
<xs:element name="LM_City" type="xs:string" />
<xs:element name="LM_State" type="xs:string" />
<xs:element name="LM_PostalCode" type="xs:string" />
<xs:element name="CNP_Number" type="xs:string" />
<xs:element name="CM_ID" type="xs:string" />
<xs:element name="LM_ID" type="xs:string" />
<xs:element name="CM_Abilitec_ID" type="xs:string" />
<xs:element name="LM_Abilitec_ID" type="xs:string" />
<xs:element name="Owner" type="xs:string" />
<xs:element name="Curr_Status" type="xs:string" />
<xs:element name="Lockout" type="xs:string" />
<xs:element name="Reservation" type="xs:string" />
<xs:element name="Good_To_Transfer_ORL" type="xs:string" />
<xs:element name="Good_To_Transfer_LV" type="xs:string" />
<xs:element name="Good_To_Transfer_NY" type="xs:string" />
<xs:element name="Good_To_Transfer_HAW" type="xs:string" />
<xs:element name="Good_To_Transfer_MRTLB" type="xs:string" />
<xs:element name="Good_To_Transfer_MAR" type="xs:string" />
<xs:element name="Good_To_Transfer_PCU" type="xs:string" />
<xs:element name="Good_To_Transfer_WAIK" type="xs:string" />
<xs:element name="Lead_Id" type="xs:string" />
<xs:element name="Income360" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
Thanks for your help! I appreciate any input that I can get.
Note to Admins: I have already searched the current posts. Nothing fits my problem exactly. I am NOT using the any of the Web Service Client stages.
Job Design Method: I have initially coded my job using input and output files to perfect the XML output format needed. Then i replaced these file stages with ISD Input and ISD output stages so as to prepare for web service deployment.
Job Design: ISD Input >> XML Input >> Transformer >> Stored Proc >> XML Output >> ISD Output
Desired Output:
<xs:schema elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="LookupResponse">
<xs:complexType mixed="true">
<xs:sequence>
<xs:element maxOccurs="unbounded" minOccurs="0" ref="DomesticLookup" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="DomesticLookup">
<xs:complexType mixed="true">
<xs:sequence>
<xs:element name="Human_Id" type="xs:string" />
<xs:element name="HH_Number" type="xs:string" />
<xs:element name="CN_First_Name" type="xs:string" />
<xs:element name="CN_Last_Name" type="xs:string" />
<xs:element name="LM_Address_1" type="xs:string" />
<xs:element name="LM_City" type="xs:string" />
<xs:element name="LM_State" type="xs:string" />
<xs:element name="LM_PostalCode" type="xs:string" />
<xs:element name="CNP_Number" type="xs:string" />
<xs:element name="CM_ID" type="xs:string" />
<xs:element name="LM_ID" type="xs:string" />
<xs:element name="CM_Abilitec_ID" type="xs:string" />
<xs:element name="LM_Abilitec_ID" type="xs:string" />
<xs:element name="Owner" type="xs:string" />
<xs:element name="Curr_Status" type="xs:string" />
<xs:element name="Lockout" type="xs:string" />
<xs:element name="Reservation" type="xs:string" />
<xs:element name="Good_To_Transfer_ORL" type="xs:string" />
<xs:element name="Good_To_Transfer_LV" type="xs:string" />
<xs:element name="Good_To_Transfer_NY" type="xs:string" />
<xs:element name="Good_To_Transfer_HAW" type="xs:string" />
<xs:element name="Good_To_Transfer_MRTLB" type="xs:string" />
<xs:element name="Good_To_Transfer_MAR" type="xs:string" />
<xs:element name="Good_To_Transfer_PCU" type="xs:string" />
<xs:element name="Good_To_Transfer_WAIK" type="xs:string" />
<xs:element name="Lead_Id" type="xs:string" />
<xs:element name="Income360" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
Thanks for your help! I appreciate any input that I can get.