DSXchange

To avoid confusing, the expecting data is like the following. Notice that Relationship_With_Mitre and Organization_type are the arrays. This is required. {"results":[{"organization":"{"OrganizationID":"17136","OrganizationNumber":"16292&quo...

Hi Ernie, My JSON format data is required to be hierarchy structured, the expecting result is like the following. {"results":[{"organization":"{"OrganizationID":"17136","OrganizationNumber":"16292","OrganizationName":"TH...

In Datastage, My job design is Oracle Connector -> XML stage -> ISD output and sequential file In XML stage, I have two HJoin steps for hierarchy with two JSON composers respectively and the final JSON composer to mapping the previous steps result. My expecting result is to send the JSON formatted s...

Hi, I have a web service JSON formatted job with two output stages: one is the sequential file only for viewing the JSON data and another is ISD output stage. I deployed this job in ISD binding it as rest2.0 HTTP. Here are the issues. 1) Since the output file in sequential file looks good as JSON fo...

I have tried your design. I run the URL to test it, like http://servername:port/wisd-txhttp/Clarity/PersonPortfolio/getPortfolio I get this message "/apps/appmgr/Datastage/devl/ODS/webservice/scripts/xml/Clarity_Portfolio.xml" in the web page. Why do I not get the XML data in the web page?...

I would really appreciate if you could shed some light on how to do this .
Jane

I already provided the receiver with the flat json Web service, But they insisted on the hierarchy data. Is it legitimate to say that Data stage and ISD can not be used to create a hierarchy structure data RESTful Web Service as JSON format?
Thank you very much!
-Jane

If I remove the xml output stage, the Database stage gives me relational data, but I need the hierarchy data as Web Service. How can I achieve this?
Thank you very much! -Jane

I try to follow your advice. 1) Master-detail data from Oracle stage -> XML output(Hierarchy data) -> ISD output. 2) deploy it as Web service in ISD selecting JSON format. However I got messed up data. Do you have any document to show step by step on how to do "Topology II job"? Thank you!

Without XML stage, I will get a relational structure data. I need a heirarchy structure data.
I try to transfer the xml data from xml output stage to a sequential file using one big size column, but my data is really big like 800,000 bytes exceed the max 131072.
Please advice.
Thanks!
Jane

The web service with the tree structure data will be used in Gadget for our company's web site. Soi it has to be the restful JSON format for each attribute. In XML output stage, I define the output as one output file mydata.xml in "Option" tab. But after run, there are many mydata.xml gets...

Hi My goal is to create a web service as an ISD job with a heirarchy structure data in RESTFUL JSON format. Here is my design. Oracle Stage to query Master data having Lookup stage to get detail data -> Join Stage -> XML output to get a heirarchy structure data -> what stage ??? to call a java class...

Can you tell me what clients are better to test Web Service?
Thanks
Jane

In ISD, the bindings that I make are SOAP over HTTP and REST.

In Operation, I use XML or JSON. If I define it as XML Or JSON, I will use browser to test my web service and save it as a text file. I also use SOAPUI to test them. None of them returns the number of records that I expect.

Thanks!
Jane

Now I have two jobs. One is oracle stage -> Transformer -> Sequential File. Another one is Sequential File -> WISDOutput The number of the records in Sequencial File is 10,997 that is the same as oracle stage output link. But the number of the records from XML is 709. I still get less data through I...