DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
sandhya.budhi



Group memberships:
Premium Members

Joined: 15 Nov 2017
Posts: 3

Points: 22

Post Posted: Wed Nov 15, 2017 12:48 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,

I am looking for some guidance to invoke a JSON web service call using WST stage. The existing DS job calls an XML web service (SOAP) to push items onto the SharePoint hosted queue. The Job has to be modified to invoke the new JSON call and pushes the data to Azure cloud. Any examples I can refer to see how JSON calls were made from WST stage.

_________________
Thanks,
Sandhya
eostic

Premium Poster



Group memberships:
Premium Members

Joined: 17 Oct 2005
Posts: 3723

Points: 29735

Post Posted: Wed Nov 15, 2017 1:11 pm Reply with quote    Back to top    

You will need to learn how to use the Hierarchical Stage, which was updated around the 11.3 time frame to support REST calls using JSON and XML payloads.

Short of that, if you are on an older release with out REST support within the Hierarchical Stage (former XML Stage), you would need to write your own class and use the Java Integration Stage (or Java Client/JavaTransformer if in a really old release).

Ernie

_________________
Ernie Ostic

blogit!
Open IGC is Here!
Rate this response:  
Not yet rated
sandhya.budhi



Group memberships:
Premium Members

Joined: 15 Nov 2017
Posts: 3

Points: 22

Post Posted: Wed Nov 15, 2017 2:04 pm Reply with quote    Back to top    

Hi eostic,

The datastage version is 11.3 and I think REST is supported in the Hierarchical stage. I will try using it. Thanks

_________________
Thanks,
Sandhya
Rate this response:  
Not yet rated
sandhya.budhi



Group memberships:
Premium Members

Joined: 15 Nov 2017
Posts: 3

Points: 22

Post Posted: Fri Nov 17, 2017 9:12 am Reply with quote    Back to top    

I am using Hierarchical stage for create REST calls using JSON payload. I need to create a JSON file before doing a REST call. In the Hierarchical stage we have JSON composer which creates the JSON file. My data is not in XML format to feed in JSON composer. The data is stored in the dataset. Do I need to create the XML file before sending the data to the JSON composer or I can use dataset for creating the JSON file. Most of the examples I have seen used XML file as input to the JSON composer. Please help.

_________________
Thanks,
Sandhya
Rate this response:  
Not yet rated
eostic

Premium Poster



Group memberships:
Premium Members

Joined: 17 Oct 2005
Posts: 3723

Points: 29735

Post Posted: Mon Nov 20, 2017 10:48 am Reply with quote    Back to top    

It's the same as for XML, but the nice thing is, you don't need any kind of schema. Just get a sample json document and "import it" via the Library Manager. Then you will feed in your normal data ( ...

_________________
Ernie Ostic

blogit!
Open IGC is Here!
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours