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:
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 ?
Hi 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. Regards, Pedro
Hi pedro:
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.
