You are not logged in.
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 ?
Last edited by aditya3245 (2012-05-24 01:39:02)
According to your description, you can use tFileInputDelimited or tFileInputXML to extract this ID value.
Then link tJavaRow with tFileInputDelimited or tFileInputXML, save ID into context variable.
You needn't read from command line.
We tried implementing your suggestion - but ran into an error - if you could take a quick second and look at this (apologies for cross posting) - I would appreciate it.