One Star

[Input for tREST URL]

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 ?

One Star

Re: [Input for tREST URL]

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.
One Star

Re: [Input for tREST URL]

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.
One Star

Re: [Input for tREST URL]

We want to pass arguments to trest component or call trest component from tjava or tjavarow and pass parameters, is it possible ?