XML data in an XML tag as input to Web Service
Posted: Tue Jan 21, 2014 8:52 am
Hello,
Have a question regarding the XML format of Web Service
As of now our source is as below through a table
Name(char)
Entity(integer)
Account(integer)
Tran_CLOB(XML data)
Prod_cd
Prod_type
Now we are planning to build a web service with the same fields but as WISD input and WISD output as below
WISD input
<NAME>John</Name>
<Entity>123</Entity>
<Account>1234</Account>
<Tran_clob> has all the transactions in XML format inside this around 10,000 as separate records</Tran_clob>
<Prod_cd>CD</Prod_cd>
<Prod_type>K</Prod_type>
So the above data will be the input to WISD and we parse the XML , do the transformations and insert these records into table and send error report to WISD output.
Is it a good option to follow this procedure in ETL to insert around 10,000 records on the fly when ever a new request is sent to the web service...
Thank you!
Have a question regarding the XML format of Web Service
As of now our source is as below through a table
Name(char)
Entity(integer)
Account(integer)
Tran_CLOB(XML data)
Prod_cd
Prod_type
Now we are planning to build a web service with the same fields but as WISD input and WISD output as below
WISD input
<NAME>John</Name>
<Entity>123</Entity>
<Account>1234</Account>
<Tran_clob> has all the transactions in XML format inside this around 10,000 as separate records</Tran_clob>
<Prod_cd>CD</Prod_cd>
<Prod_type>K</Prod_type>
So the above data will be the input to WISD and we parse the XML , do the transformations and insert these records into table and send error report to WISD output.
Is it a good option to follow this procedure in ETL to insert around 10,000 records on the fly when ever a new request is sent to the web service...
Thank you!