DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
rasampath



Group memberships:
Premium Members

Joined: 10 Nov 2016
Posts: 2
Location: Toronto
Points: 20

Post Posted: Wed Jan 04, 2017 6:03 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: Infosphere 11.3; REST 2.0 binding
Hi all,

We've created a couple of simple REST 2.0 services via ISD to retrieve data from a database via a DataStage job and have got them working.

We're now looking to see how we can implement the following and I'm looking for guidance/recommended approaches for doing this:

1. Pagination - When the underlying query returns more than a certain number of rows (e.g. 100), how can the resultset be paginated. REST practices recommend including a Limit/Offset or a next/previous link; however I'm curious as to the approaches members have taken with ISD and how they've been implemented.

2. Data shaping - for wide tables, how can the fields returned be controlled based on the fields required by the service consumer? For example, I have a customer table with 100's of fields, however, based on the list of fields specified via a query string parameter (e.g. ?fields=custName, custID,custCity), I'd like to return only the fields specified.

Thanks in advance.
eostic

Premium Poster



Group memberships:
Premium Members

Joined: 17 Oct 2005
Posts: 3773

Points: 30298

Post Posted: Thu Jan 05, 2017 1:09 pm Reply with quote    Back to top    

ISD Jobs are stateless; so there is no way to "buffer" or save rows for a particular user or session to get them on a subsequent call. You would have to code such logic yourself...perhaps saving ro ...

_________________
Ernie Ostic

blogit!
Open IGC is Here!
Rate this response:  
Not yet rated
rasampath



Group memberships:
Premium Members

Joined: 10 Nov 2016
Posts: 2
Location: Toronto
Points: 20

Post Posted: Thu Jan 12, 2017 8:19 am Reply with quote    Back to top    

Thanks Ernie, for your response.

We're trying to steer the design away from these approaches primarily due to the complexity and customization associated with implementing the logic to achieve this.

We'll keep the options you've provided in mind when finalizing the design.

Thanks
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