We are using Open Studio for DI as an ETL solution for migration

We invoke a web service using tREST  (no WSDL - so we CANNOT use tWebServiceInput) and extract XML based on XPath queries defined in tExtractXMLField - we then use tMAP to pass on the result to a csv file - which in turn gets sFTPd over to a local server. See Diagram 1


There is an additional change we are looking to make:

[  ADD INPUT from an xml file/ csv file - and append it to the web service URL for tREST ]

Our goal is to APPEND further input to that URL in the tREST configuration (see attached diagram 2) - this input IS AN ID that will be ADDED AT THE END OF THE EXISTING URL

What is the best way to go about this ?

One option is to add a variable to the context (see attached diagram 3) and THEN APPEND this variable to the URL.

However, we need to figure out a way to do this WITHOUT READING FROM THE COMMAND LINE.

SO >> We want to read this variable instead from a XML or a CSV file. How exactly would we accomplish the transfer of variable values for one of the two options from diagram 4 ?


Thanks
-A

Last edited by aditya3245 (2012-05-24 01:39:02)